Supplier Invoice Payment Register Details

SELECT
    PSV.SEGMENT1                                             AS Supplier_Number,
    NVL(
        SUBSTR(ACA.REMIT_TO_SUPPLIER_NAME, 1, 39),
        SUBSTR(ACA.VENDOR_NAME, 1, 39)
    )                                                        AS Supplier_Name,
    NVL(ACA.REMIT_TO_ADDRESS_NAME, PSSV.VENDOR_SITE_CODE)    AS Supplier_Site_Code,
    PSV.VENDOR_TYPE_LOOKUP_CODE                              AS Supplier_Type,
    ACA.CHECK_NUMBER                                         AS Payment_Number,
    ACA.CURRENCY_CODE                                        AS Payment_Currency,
    AIA.INVOICE_NUM                                          AS Invoice_Number,
    DECODE(
        ACA.PAYMENT_TYPE_FLAG,
        'R', 'Electronic Payment',
        ACA.PAYMENT_TYPE_FLAG
    )                                                        AS Payment_Type,
    TO_CHAR(ACA.CHECK_DATE, 'YYYY-MM-DD')                    AS Payment_Date,
    ALC.DISPLAYED_FIELD                                      AS Payment_Status,
    APSA.GROSS_AMOUNT                                        AS Payment_Gross_Amount,
    AIPA.PAYMENT_BASE_AMOUNT                                 AS Payment_Net_Amount_USD,
    AIPA.AMOUNT                                              AS Payment_Net_Amount,
    ROUND((AIPA.AMOUNT * NVL(AIPA.EXCHANGE_RATE, 1)), 3)     AS Payment_Amount_Functional_Currency,
    CBBV.BANK_NAME                                           AS Company_Bank_Name,
    CBBV.BANK_BRANCH_NAME                                    AS Company_Bank_Branch_Name,
    ACA.BANK_ACCOUNT_NAME                                    AS Company_Bank_Account_Name,
    CBA.BANK_ACCOUNT_NUM                                     AS Bank_Account_Number,
    TO_CHAR(AIA.INVOICE_DATE, 'YYYY-MM-DD')                  AS Invoice_Date,
    AIA.INVOICE_TYPE_LOOKUP_CODE                             AS Invoice_Type,
    AIA.INVOICE_AMOUNT                                       AS Invoice_Amount,
    TO_CHAR(APSA.DUE_DATE, 'YYYY-MM-DD')                     AS Due_Date,
    DECODE(AIPA.POSTED_FLAG, 'Y', 'Yes', 'No')               AS Accounting_Status,
    DECODE(ACA.RECON_FLAG, 'Y', 'Yes', 'No')                 AS Reconciled_Flag
FROM
    AP_CHECKS_ALL                 ACA,
    AP_INVOICE_PAYMENTS_ALL       AIPA,
    AP_INVOICES_ALL               AIA,
    AP_PAYMENT_SCHEDULES_ALL      APSA,
    CE_BANK_ACCOUNTS              CBA,
    CE_BANK_ACCT_USES_ALL         CBAUA,
    CE_BANK_BRANCHES_V            CBBV,
    AP_LOOKUP_CODES               ALC,
    POZ_SUPPLIER_SITES_V          PSSV,
    POZ_SUPPLIERS_V               PSV
WHERE
        ACA.CE_BANK_ACCT_USE_ID   = CBAUA.BANK_ACCT_USE_ID
    AND CBAUA.BANK_ACCOUNT_ID     = CBA.BANK_ACCOUNT_ID
    AND CBA.BANK_BRANCH_ID        = CBBV.BRANCH_PARTY_ID
    AND ACA.VENDOR_ID             = PSSV.VENDOR_ID (+)
    AND ACA.VENDOR_ID             = PSV.VENDOR_ID (+)
    AND ACA.VENDOR_SITE_ID        = PSSV.VENDOR_SITE_ID (+)
    AND ACA.CHECK_ID              = AIPA.CHECK_ID
    AND AIPA.INVOICE_ID           = AIA.INVOICE_ID
    AND AIA.INVOICE_ID            = APSA.INVOICE_ID
    AND AIPA.PAYMENT_NUM          = APSA.PAYMENT_NUM
    AND ALC.LOOKUP_TYPE           = 'CHECK STATE'
    AND ALC.DISPLAYED_FIELD       <> 'Voided'
    AND ALC.LOOKUP_CODE           = ACA.STATUS_LOOKUP_CODE
ORDER BY
    PSV.SEGMENT1,
    ACA.CURRENCY_CODE,
    ACA.CHECK_NUMBER,
    AIA.INVOICE_NUM