https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html
SELECT
acr.cash_receipt_id,
acr.receipt_number,
acr.receipt_date,
araa.amount_applied ,
araa.apply_date ,
araa.gl_date,
araa.gl_posted_date,
a.ae_header_id,
a.accounting_date , a.gl_transfer_date , a.gl_transfer_status_code,
d.name Journal_name,
e.status,
f.segment1||'-'||f.segment2||'-'||f.segment3||'-'||f.segment4||'-'||f.segment5||'-'||f.segment6||'-'||f.segment7 GL_Account,
e.accounted_dr , e.accounted_cr
FROM
ar_cash_receipts_all acr,
ar_receivable_applications_all araa,
xla_ae_headers a,
xla_ae_lines b,
gl_import_references c,
gl_je_headers d,
gl_je_lines e,
gl_code_combinations f
WHERE 1 = 1
AND araa.cash_receipt_id = acr.cash_receipt_id
and araa.set_of_books_id = acr.set_of_books_id
AND acr.receipt_number = 'Advance SPR_ 666184- 1st' --p_receipt_number
and a.event_id = araa.event_id
and a.ledger_id = araa.set_of_books_id
and b.code_combination_id = araa.code_combination_id
and a.ae_header_id = b.ae_header_id
and a.ledger_id = b.ledger_id
and a.application_id = b.application_id
and a.application_id = 222
and c.gl_sl_link_id = b.gl_sl_link_id
and c.gl_sl_link_table = b.gl_sl_link_table
and c.je_header_id = d.je_header_id
and d.ledger_id = d.ledger_id
and d.je_header_id = e.je_header_id
and e.je_line_num = c.je_line_num
and e.ledger_id = d.ledger_id
and f.code_combination_id = e.code_combination_id
