AP Invoice To GL Tracking

SELECT *
FROM   ap_invoices_all aia
WHERE  1 =1
AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019')SELECT *
FROM   ap_invoice_lines_all aila
WHERE  aila.invoice_id=
       (
              SELECT aia.invoice_id
              FROM   ap_invoices_all aia
              WHERE  1 =1
              AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019')) 

===================================================================================================================================================================

SELECT *
FROM   ap_invoice_distributions_all aida
WHERE  aida.invoice_id=
       (
              SELECT aia.invoice_id
              FROM   ap_invoices_all aia
              WHERE  1 =1
              AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019')) 

===================================================================================================================================================================

SELECT *
FROM   xla_events xe
WHERE  xe.event_id =
       (
              SELECT aida.accounting_event_id
              FROM   ap_invoice_distributions_all aida
              WHERE  aida.invoice_id=
                     (
                            SELECT aia.invoice_id
                            FROM   ap_invoices_all aia
                            WHERE  1 =1
                            AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019'))) 

===================================================================================================================================================================

SELECT *
FROM   xla_ae_headers xah
WHERE  xah.event_id =
       (
              SELECT xe.event_id
              FROM   xla_events xe
              WHERE  xe.event_id =
                     (
                            SELECT aida.accounting_event_id
                            FROM   ap_invoice_distributions_all aida
                            WHERE  aida.invoice_id=
                                   (
                                          SELECT aia.invoice_id
                                          FROM   ap_invoices_all aia
                                          WHERE  1 =1
                                          AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019')))) 

===================================================================================================================================================================

SELECT *
FROM   xla_ae_lines xal
WHERE  xal.ae_header_id =
       (
              SELECT xah.ae_header_id
              FROM   xla_ae_headers xah
              WHERE  xah.event_id =
                     (
                            SELECT xe.event_id
                            FROM   xla_events xe
                            WHERE  xe.event_id =
                                   (
                                          SELECT aida.accounting_event_id
                                          FROM   ap_invoice_distributions_all aida
                                          WHERE  aida.invoice_id=
                                                 (
                                                        SELECT aia.invoice_id
                                                        FROM   ap_invoices_all aia
                                                        WHERE  1 =1
                                                        AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019'))))) 

===================================================================================================================================================================

SELECT *
FROM   xla_distribution_links xdl
WHERE  xdl.ae_header_id=
       (
              SELECT xah.ae_header_id
              FROM   xla_ae_headers xah
              WHERE  xah.event_id =
                     (
                            SELECT xe.event_id
                            FROM   xla_events xe
                            WHERE  xe.event_id =
                                   (
                                          SELECT aida.accounting_event_id
                                          FROM   ap_invoice_distributions_all aida
                                          WHERE  aida.invoice_id=
                                                 (
                                                        SELECT aia.invoice_id
                                                        FROM   ap_invoices_all aia
                                                        WHERE  1 =1
                                                        AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019'))))) 

===================================================================================================================================================================

SELECT *
FROM   gl_import_references gir
WHERE  gir.gl_sl_link_id IN
       (
              SELECT xal.gl_sl_link_id
              FROM   xla_ae_lines xal
              WHERE  xal.ae_header_id =
                     (
                            SELECT xah.ae_header_id
                            FROM   xla_ae_headers xah
                            WHERE  xah.event_id =
                                   (
                                          SELECT xe.event_id
                                          FROM   xla_events xe
                                          WHERE  xe.event_id =
                                                 (
                                                        SELECT aida.accounting_event_id
                                                        FROM   ap_invoice_distributions_all aida
                                                        WHERE  aida.invoice_id=
                                                               (
                                                                      SELECT aia.invoice_id
                                                                      FROM   ap_invoices_all aia
                                                                      WHERE  1 =1
                                                                      AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019')))))) 

===================================================================================================================================================================

SELECT *
FROM   gl_je_headers gjl
WHERE  gjl.je_header_id IN
       (
              SELECT gir.je_header_id
              FROM   gl_import_references gir
              WHERE  gir.gl_sl_link_id IN
                     (
                            SELECT xal.gl_sl_link_id
                            FROM   xla_ae_lines xal
                            WHERE  xal.ae_header_id =
                                   (
                                          SELECT xah.ae_header_id
                                          FROM   xla_ae_headers xah
                                          WHERE  xah.event_id =
                                                 (
                                                        SELECT xe.event_id
                                                        FROM   xla_events xe
                                                        WHERE  xe.event_id =
                                                               (
                                                                      SELECT aida.accounting_event_id
                                                                      FROM   ap_invoice_distributions_all aida
                                                                      WHERE  aida.invoice_id=
                                                                             (
                                                                                    SELECT aia.invoice_id
                                                                                    FROM   ap_invoices_all aia
                                                                                    WHERE  1 =1
                                                                                    AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019'))))))) 

===================================================================================================================================================================

SELECT *
FROM   gl_je_lines gjl
WHERE  gjl.je_header_id IN
       (
              SELECT gir.je_header_id
              FROM   gl_import_references gir
              WHERE  gir.gl_sl_link_id IN
                     (
                            SELECT xal.gl_sl_link_id
                            FROM   xla_ae_lines xal
                            WHERE  xal.ae_header_id =
                                   (
                                          SELECT xah.ae_header_id
                                          FROM   xla_ae_headers xah
                                          WHERE  xah.event_id =
                                                 (
                                                        SELECT xe.event_id
                                                        FROM   xla_events xe
                                                        WHERE  xe.event_id =
                                                               (
                                                                      SELECT aida.accounting_event_id
                                                                      FROM   ap_invoice_distributions_all aida
                                                                      WHERE  aida.invoice_id=
                                                                             (
                                                                                    SELECT aia.invoice_id
                                                                                    FROM   ap_invoices_all aia
                                                                                    WHERE  1 =1
                                                                                    AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019')))))))) 

===================================================================================================================================================================

SELECT *
FROM   gl_je_batches gjb
WHERE  gjb.batch_id IN
       (
              SELECT gir.je_batch_id
              FROM   gl_import_references gir
              WHERE  gir.gl_sl_link_id IN
                     (
                            SELECT xal.gl_sl_link_id
                            FROM   xla_ae_lines xal
                            WHERE  xal.ae_header_id =
                                   (
                                          SELECT xah.ae_header_id
                                          FROM   xla_ae_headers xah
                                          WHERE  xah.event_id =
                                                 (
                                                        SELECT xe.event_id
                                                        FROM   xla_events xe
                                                        WHERE  xe.event_id =
                                                               (
                                                                      SELECT aida.accounting_event_id
                                                                      FROM   ap_invoice_distributions_all aida
                                                                      WHERE  aida.invoice_id=
                                                                             (
                                                                                    SELECT aia.invoice_id
                                                                                    FROM   ap_invoices_all aia
                                                                                    WHERE  1 =1
                                                                                    AND    aia.invoice_num=Nvl(:P_INVOICE_NUM,'0010-06/2019'))))))) 

===================================================================================================================================================================