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