PO Module

How to join the tables in PO modules?

Questions by bramhi.86

Showing Answers 1 - 0 of 0 Answers

CP

  • Sep 2nd, 2011
 

Following should work for standard POs

Code
  1.  

  2. SELECT  *

  3. FROM    po_headers_all pha

  4.        ,po_lines_all pla

  5.        ,po_line_locations_all plla

  6.        ,po_distributions_all pda

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

  8. AND     pla.po_header_id = pha.po_header_id

  9. AND     plla.po_line_id = pla.po_line_id

  10. AND     plla.po_header_id = pha.po_header_id

  11. AND     pda.line_location_id = plla.line_location_id

  12. AND     pda.po_header_id = pha.po_header_id

  13.  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions