AP Invoice to Payment 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   ap_invoice_payments_all aipa
WHERE  aipa.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_checks_all aca
WHERE  aca.check_id = (SELECT aipa.check_id
                       FROM   ap_invoice_payments_all aipa
                       WHERE  aipa.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_payment_schedules_all apsa
WHERE  apsa.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'))
============================================================================================