Mapping between AP, XLA and GL tables in Oracle Fusion

Use the below queries to link AP, XLA and GL tables in Oracle Fusion:

SELECT *
FROM   ap_invoices_all
WHERE  creation_date >= SYSDATE - 30;

SELECT invoice_id
FROM   ap_invoices_all
WHERE  invoice_num = '14012023';

SELECT *
FROM   ap_invoice_distributions_all
WHERE  invoice_id = '300000005209928';

SELECT *
FROM   xla_transaction_entities
WHERE  source_id_int_1 = (SELECT invoice_id --300000005209928
                          FROM   ap_invoices_all
                          WHERE  invoice_num = '14012023');

SELECT *
FROM   xla_events
WHERE  event_id IN (SELECT accounting_event_id
                    FROM   ap_invoice_distributions_all
                    WHERE  invoice_id = '300000005209928'); 

SELECT gl_sl_link_id --36020 
FROM   xla_ae_lines
WHERE  ae_line_num  = '1'
AND    ae_header_id = (SELECT ae_header_id --38007
                    FROM   xla_ae_headers
                    WHERE  event_id = '81015'); 

SELECT je_batch_id,
       je_header_id,
       je_line_num
FROM   gl_import_references
WHERE  gl_sl_link_id = (SELECT gl_sl_link_id --36020 
                        FROM   xla_ae_lines
                        WHERE  ae_line_num = '1'
                        AND ae_header_id = (SELECT ae_header_id --38007
                                            FROM   xla_ae_headers
                                            WHERE  event_id = '81015'))
AND gl_sl_link_table = 'XLAJEL';