How to join XLA_AE_HEADERS to PO_HEADERS_ALL

Summary:

need to get the PO numbers of all receipt accounting subledger lines on fusion cloud

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT xah.ledger_id,
gir.je_header_id,
gir.je_line_num,
ph.segment1 po_num,
ph.po_header_id,
xe.entity_id,
(SELECT xam.name
FROM xla_acctg_methods_tl xam
WHERE xam.language = USERENV ('LANG')
AND xam.accounting_method_code = xah.product_rule_code
) sla_rule,
SUM (xal.entered_dr) entered_dr,
SUM (xal.entered_cr) entered_cr,