SPECIAL CHARACTER IS TO REMOVE FROM THE TABLE IN ORACLE APPS

      SPECIAL CHARACTER IS TO REMOVE  FROM THE TABLE  IN ORACLE APPS

1, select regexp_replace('This is a test $%&^*&*'||chr(10)||'*"ú%bsf-d.', '( *[[:punct:]])', '') from dual

2, select regexp_replace(descriptions, '( *[[:punct:]])', '') from apps.mtl_system_items_b

P2p link o2C Link between Internal requisition and Internal sales order

//////////// P2P TO O2C Link between Internal requisition and Internal sales order////////////


1. OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID =
    po_requisition_lines_all.REQUISITION_LINE_ID
2.  OE_ORDER_LINES_ALL.ORIG_SYS_DOCUMENT_REF=       
      po_requisition_HEADERs_all.SEGMENT1(Requisition Number)
3.  OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF=         
      po_requisition_HEADERs_all.SEGMENT1(Requisition number)

P2P TO O2C LINKS

                                          P2P TO  O2C  LINKS  

/* Formatted on 2013/02/11 17:56 (Formatter Plus v4.8.8) */
SELECT oola.ordered_item, oola.org_id, oola.ordered_quantity,
       oola.cust_po_number, oola.ship_from_org_id, oola.inventory_item_id,
       oola.item_type_code, oola.source_type_code, oola.flow_status_code,
       mt.subinventory_code, pol.item_id
  FROM apps.mtl_reservations mt,
       apps.oe_order_lines_all oola,
       apps.po_lines_all pol
 WHERE mt.demand_source_line_id = oola.line_id
   AND mt.supply_source_line_id = pol.po_line_id
   AND pol.po_line_id = 163219