PO Purchase Requisition Interface

Description
Categories: Draft, Toolkit - Operations, Toolkit - Setup & Support
Purchase requisitions interface listing with status for support and operational purposes.
Run PO Purchase Requisition Interface and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™