Is it possible to get Invoice, Credit Memo, and Account Credit Data "As Of A Given Date"

I have a requirement to create a report for customers and provide an account summary showing all the invoices, credit memos (and their amount_due_remaining as of a given date), and in the end sum of all "on account" credit amount_due remaining as of a given date.

I was able to create a query to get the sum of all Account Credit as of a given date as below:

SELECT SUM(APS.AMOUNT_DUE_REMAINING) ON_ACCOUNT
 FROM AR_PAYMENT_SCHEDULES_ALL      APS,
      AR_RECEIVABLE_APPLICATIONS_ALL ARA,
      AR_CASH_RECEIPTS_V            ACR
WHERE APS.CLASS IN ('PMT')
  AND APS.STATUS <> 'CL'
  AND APS.AMOUNT_DUE_REMAINING <> 0
  AND APS.PAYMENT_SCHEDULE_ID = ARA.PAYMENT_SCHEDULE_ID
  AND ARA.STATUS = 'ACC'
  AND ARA.AMOUNT_APPLIED > 0
  AND APS.CASH_RECEIPT_ID = ACR.CASH_RECEIPT_ID
  AND ARA.RECEIVABLE_APPLICATION_ID IN
      (SELECT MAX(ARA.RECEIVABLE_APPLICATION_ID) "Rec App ID"
         FROM AR_PAYMENT_SCHEDULES_ALL      APS,
              AR_RECEIVABLE_APPLICATIONS_ALL ARA,
              AR_CASH_RECEIPTS_V            ACR
        WHERE APS.CLASS IN ('PMT')
          AND APS.STATUS <> 'CL'
          AND APS.AMOUNT_DUE_REMAINING <> 0
          AND APS.PAYMENT_SCHEDULE_ID = ARA.PAYMENT_SCHEDULE_ID
          AND ARA.STATUS = 'ACC'
          AND ARA.AMOUNT_APPLIED > 0
          AND ARA.APPLY_DATE < '25-DEC-2022'
          AND APS.CASH_RECEIPT_ID = ACR.CASH_RECEIPT_ID
          AND APS.CUSTOMER_ID = (SELECT CUST_ACCOUNT_ID
                                   from HZ_CUST_ACCOUNTS
                                  where account_number = 'ACC_NUM')
        GROUP BY APS.CASH_RECEIPT_ID)
  AND APS.CUSTOMER_ID = (SELECT CUST_ACCOUNT_ID
                           from HZ_CUST_ACCOUNTS
                          where account_number = 'ACC_NUM')
ORDER BY APS.CASH_RECEIPT_ID,
         ARA.APPLY_DATE,
         ARA.RECEIVABLE_APPLICATION_ID