CP

• Sep 2nd, 2011

 

Following should work for standard POs

Code
 


SELECT  * 


FROM    po_headers_all pha


       ,po_lines_all pla


       ,po_line_locations_all plla


       ,po_distributions_all pda


WHERE   pha.segment1 = '<enter PO number here>'


AND     pla.po_header_id = pha.po_header_id


AND     plla.po_line_id = pla.po_line_id


AND     plla.po_header_id = pha.po_header_id


AND     pda.line_location_id = plla.line_location_id


AND     pda.po_header_id = pha.po_header_id