Query to find out info from PR to PO

Posted on by

Oracle EBS R12

Query to find out info from PR to PO

select distinct u.description “Requestor”,
porh.segment1 as “Req Number”,
trunc(porh.Creation_Date) “Created On”,
pord.LAST_UPDATED_BY,
porh.Authorization_Status “Status”,
porh.Description “Description”,
poh.segment1 “PO Number”,
trunc(poh.Creation_date) “PO Creation Date”,
poh.AUTHORIZATION_STATUS “PO Status”,
trunc(poh.Approved_Date) “Approved Date”
from apps.po_headers_all poh,
apps.po_distributions_all pod,
apps.po_req_distributions_all pord,
apps.po_requisition_lines_all porl,
apps.po_requisition_headers_all porh,
apps.fnd_user u
where porh.requisition_header_id = porl.requisition_header_id
and porl.requisition_line_id = pord.requisition_line_id
and pord.distribution_id = pod.req_distribution_id(+)
and pod.po_header_id = poh.po_header_id(+)
and porh.created_by = u.user_id
order by 2