因为问题中没有具体提到。我编写的查询假设AR发票数据存储在AR_INVOICES_ALL表中，并且客户和帐户信息从HZ_PARTIES表中检索。

SELECT
    c.CUSTOMER_NAME,
    a.ACCOUNT_NAME,
    i.INVOICE_NUMBER,
    CASE
        WHEN i.DUE_DATE >= TRUNC(SYSDATE) THEN i.INVOICE_AMOUNT
        ELSE 0
    END AS CURRENT,
    CASE
        WHEN i.DUE_DATE < TRUNC(SYSDATE) AND i.DUE_DATE >= TRUNC(SYSDATE) - 30 THEN i.INVOICE_AMOUNT
        ELSE 0
    END AS "1-30 PAST DUE",
    CASE
        WHEN i.DUE_DATE < TRUNC(SYSDATE) - 30 AND i.DUE_DATE >= TRUNC(SYSDATE) - 60 THEN i.INVOICE_AMOUNT
        ELSE 0
    END AS "31-60 PAST DUE",
    CASE
        WHEN i.DUE_DATE < TRUNC(SYSDATE) - 60 AND i.DUE_DATE >= TRUNC(SYSDATE) - 90 THEN i.INVOICE_AMOUNT
        ELSE 0
    END AS "61-90 PAST DUE",
    CASE
        WHEN i.DUE_DATE < TRUNC(SYSDATE) - 90 THEN i.INVOICE_AMOUNT
        ELSE 0
    END AS ">90 PAST DUE",
    i.INVOICE_AMOUNT AS TOTAL
FROM
    AR_INVOICES_ALL i
    JOIN HZ_PARTIES c ON i.CUSTOMER_ID = c.PARTY_ID
    JOIN HZ_PARTIES a ON i.ACCOUNT_ID = a.PARTY_ID
WHERE
    i.INVOICE_TYPE = 'Invoice'
    AND i.INVOICE_STATUS = 'Approved'
ORDER BY
    c.CUSTOMER_NAME, i.INVOICE_NUMBER;