oracle.mallik

 Profile Answers by oracle.mallik 

• Sep 22nd, 2010

 

Here you can find all the details, If you want more fields you can add it.

select pha.segment1 "PO Number",
pha.segment1 "REQ Number",
pha.org_id
from
apps.po_headers_all pha,
apps.po_lines_all pla,
apps.po_line_locations_all plla,
apps.po_distributions_all pda,
apps.po_requisition_headers_all prha,
apps.po_requisition_lines_all prla,
apps.po_req_distributions_all prda
where
pha.po_header_id = pla.po_header_id
and pla.po_line_id = plla.po_line_id
and plla.line_location_id = pda.line_location_id
and pda.req_distribution_id = prda.distribution_id
and prha.requisition_header_id = prla.requisition_header_id
and prla.requisition_line_id = prda.requisition_line_id
-- and prha.segment1='xxx' --Requisition Number
and pha.org_id=123 --- Org id

Thanks,
Mallikarjun