PO RCV Interface

Description
Categories: Toolkit - Setup & Support
Columns: Rowid, Process Flag, Org Id, Deliver To Requestor Name, Deliver To Requestor Id, Requisition Header Id, Requisition Line Id, Req Distribution Id, Req Number Segment1, Segment1 ...
Requisition Interface Errors
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')