XLA to GL Link

 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