Query to Link AP Invoices/AP Payments, GL and SLA Tables: R12 AP GL XLA
SELECT SUM (xal.accounted_cr), SUM (xal.accounted_dr)
FROM 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 P_INVOICE_ID OR P_CHECK_ID = NVL ("SOURCE_ID_INT_1", (-99))
AND xte.entity_code = 'AP_INVOICES' OR 'AP_PAYMENTS'
AND xte.application_id = 200
AND xte.entity_id = xah.entity_id
AND xah.ae_header_id = xal.ae_header_id
AND xal.gl_sl_link_id = gir.gl_sl_link_id
AND xal.gl_sl_link_table = gir.gl_sl_link_table
AND gir.je_header_id = gjl.je_header_id
AND gir.je_line_num = gjl.je_line_num
AND gjl.je_header_id = gjh.je_header_id
FROM 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 P_INVOICE_ID OR P_CHECK_ID = NVL ("SOURCE_ID_INT_1", (-99))
AND xte.entity_code = 'AP_INVOICES' OR 'AP_PAYMENTS'
AND xte.application_id = 200
AND xte.entity_id = xah.entity_id
AND xah.ae_header_id = xal.ae_header_id
AND xal.gl_sl_link_id = gir.gl_sl_link_id
AND xal.gl_sl_link_table = gir.gl_sl_link_table
AND gir.je_header_id = gjl.je_header_id
AND gir.je_line_num = gjl.je_line_num
AND gjl.je_header_id = gjh.je_header_id
No comments:
Post a Comment