AR Invoice Summary Details

SELECT
    RCTA.TRX_NUMBER                                          AS Invoice_Number,
    RCTTA.NAME                                               AS Invoice_Type,
    RCTA.PURCHASE_ORDER                                      AS Purchase_Order,
    HP.PARTY_NAME                                            AS Customer_Name,
    NVL(
        (
            SELECT
                SUM(RCTLA.EXTENDED_AMOUNT)
            FROM
                RA_CUSTOMER_TRX_LINES_ALL     RCTLA
            WHERE
                    RCTLA.CUSTOMER_TRX_ID     = RCTA.CUSTOMER_TRX_ID
                AND RCTLA.LINE_TYPE           = 'LINE'
        ),
        0
    )                                                        AS Invoice_Amount,
    NVL(
        (
            SELECT
                SUM(RCTLA.EXTENDED_AMOUNT)
            FROM
                RA_CUSTOMER_TRX_LINES_ALL     RCTLA
            WHERE
                    RCTLA.CUSTOMER_TRX_ID     = RCTA.CUSTOMER_TRX_ID
                AND RCTLA.LINE_TYPE           = 'TAX'
        ),
        0
    )                                                        AS Tax_Amount,
    NVL(
        (
            SELECT
                SUM(RCTLA.EXTENDED_AMOUNT)
            FROM
                RA_CUSTOMER_TRX_LINES_ALL     RCTLA
            WHERE
                    RCTLA.CUSTOMER_TRX_ID     = RCTA.CUSTOMER_TRX_ID
                AND RCTLA.LINE_TYPE           = 'FREIGHT'
        ),
        0
    )                                                        AS Freight_Amount,
    NVL(
        (
            SELECT
                SUM(RCTLA.EXTENDED_AMOUNT)
            FROM
                RA_CUSTOMER_TRX_LINES_ALL     RCTLA
            WHERE
                RCTLA.CUSTOMER_TRX_ID         = RCTA.CUSTOMER_TRX_ID
        ),
        0
    )                                                        AS Total_Amount,
    RCTA.INVOICE_CURRENCY_CODE                               AS Currency_Code,
    DECODE(RCTA.COMPLETE_FLAG, 'Y', 'Complete', 'N', 'Incomplete')
                                                             AS Invoice_Status,
    NVL(APSA.AMOUNT_DUE_REMAINING, 0)                        AS Balance_Due
FROM
    RA_CUSTOMER_TRX_ALL          RCTA,
    RA_CUST_TRX_TYPES_ALL        RCTTA,
    HZ_PARTIES                   HP,
    HZ_CUST_ACCOUNTS             HCA,
    AR_PAYMENT_SCHEDULES_ALL     APSA
WHERE
        RCTA.CUST_TRX_TYPE_SEQ_ID = RCTTA.CUST_TRX_TYPE_SEQ_ID
    AND RCTA.BILL_TO_CUSTOMER_ID  = HCA.CUST_ACCOUNT_ID
    AND HCA.PARTY_ID              = HP.PARTY_ID
    AND RCTA.CUSTOMER_TRX_ID      = APSA.CUSTOMER_TRX_ID (+)
ORDER BY
    RCTTA.NAME