PO Purchase Requisition Interface

Description
Categories: Draft
Purchase requisitions interface listing with status for support and operational purposes.

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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