PO RCV Interface

select pr.rowid,
       pr.process_flag,
       pr.org_id,
       pr.DELIVER_TO_REQUESTOR_NAME,
       pr.DELIVER_TO_REQUESTOR_id,
       pr.Requisition_header_id,
       pr.Requisition_line_id,
       pr.Req_distribution_id,
       pr.Req_number_segment1,
       msi.segment1,
       pr.*
  from po_requisitions_interface_all pr, mtl_system_items msi
 where 1=1
   and pr.item_id = msi.inventory_item_id
   and msi.organization_id = pr.destination_organization_id
   and interface_source_code in ('MRP','INV','MSC', 'PO','ONT')