PO Purchase Requisition Interface

Description
Categories: Enginatics, Toolkit - Operations, Toolkit - Setup & Support
Repository: Github Columns: Segment1, 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 ...
Purchase requisitions interface listing with status for support and operational purposes.
select 
msib.segment1,
pria.rowid, 
pria.process_flag, 
pria.org_id, 
pria.deliver_to_requestor_name, 
pria.deliver_to_requestor_id,
pria.requisition_header_id,              
pria.requisition_line_id,              
pria.req_distribution_id, 
pria.req_number_segment1,
pria.*
from 
po_requisitions_interface_all pria,
mtl_system_items_b msib
where 1=1
and pria.item_id=msib.inventory_item_id
and msib.organization_id=pria.destination_organization_id
--and interface_source_code='msc'
Parameter Name SQL text Validation
Requestor
pria.deliver_to_requestor_name=:requestor
LOV Oracle