Query to Link AP Invoices, GL and SLA Tables: R12 AP GL XLA
SELECT SUM (xal.accounted_cr), SUM (xal.accounted_dr), aia.invoice_amount, invoice_num FROM ap_invoices_all aia, xla.xla_transaction_entities xte, xla_ae_headers xah, xla_ae_lines xal, gl.gl_import_references gir, gl_je_lines gjl, gl_je_headers gjh WHERE 1 = 1 AND aia.invoice_id = NVL…
Read More