AR Receipt Application Details

SELECT
    FABUV.BU_NAME                      AS Business_Unit_Name,
    ARAA.GL_DATE                       AS Accounting_Date,
    HP.PARTY_NAME                      AS Customer_Name,
    HCA.ACCOUNT_NUMBER                 AS Account_Number,
    ABA.NAME                           AS Batch_Name,
    ACRA.RECEIPT_NUMBER                AS Receipt_Number,
    RCTA.TRX_NUMBER                    AS Transaction_Number,
    ACRA.AMOUNT                        AS Receipt_Amount,
    ARAA.AMOUNT_APPLIED                AS Amount_Applied,
    ARAA.EARNED_DISCOUNT_TAKEN         AS Earned_Discount_Taken,
    ARAA.UNEARNED_DISCOUNT_TAKEN       AS Unearned_Discount_Taken,
    ACRA.CURRENCY_CODE                 AS Currency_Code,
    ARAA.ACCTD_AMOUNT_APPLIED_TO       AS Accounted_Amount_Applied_To,
    ARAA.EXCEPTION_REASON_CODE         AS Exception_Reason_Code
FROM
    FUSION.RA_CUSTOMER_TRX_ALL                 RCTA,
    FUSION.HZ_PARTIES                          HP,
    FUSION.AR_BATCHES_ALL                      ABA,
    FUSION.HZ_CUST_ACCOUNTS                    HCA,
    FUSION.AR_RECEIVABLE_APPLICATIONS_ALL      ARAA,
    FUSION.AR_CASH_RECEIPTS_ALL                ACRA,
    FUSION.FUN_ALL_BUSINESS_UNITS_V            FABUV
WHERE
        FABUV.BU_ID                 = ACRA.ORG_ID
    AND ACRA.CASH_RECEIPT_ID        = ARAA.CASH_RECEIPT_ID (+)
    AND ACRA.PAY_FROM_CUSTOMER      = HCA.CUST_ACCOUNT_ID (+)
    AND ACRA.RECEIPT_BATCH_ID       = ABA.BATCH_ID (+)
    AND HCA.PARTY_ID                = HP.PARTY_ID (+)
    AND ARAA.APPLIED_CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID (+)
    AND ARAA.APPLICATION_TYPE (+)   = 'CASH'
    AND ARAA.STATUS (+)             = 'APP'