R12 SQL query what links between PO/PO distributions and GL Journals

Hello there,

We just upgraded to 12.2.4 and we are working on the query scripts between GL and PO.  I just wonder if there is standard sql script linking PO/PO Distributions and GL Journals.  Here is what I created.  It worked for some POs but not all of them, not sure why:

select *

FROM gl.gl_je_batches gjb, gl.gl_je_headers gjh,  gl.gl_je_lines gjl,  gl.gl_code_combinations gcc, gl.gl_import_references imp,

xla.xla_ae_lines xal,  xla.xla_ae_headers xah, xla.xla_events xe, xla.xla_transaction_entities xte,

ap.ap_suppliers asu, po.po_headers_all pha, po.po_distributions_all pda