Oracle EBS: 取得AR invoice balance資料

SQL:

SELECT a.trx_number,
       a.trx_date,
       b.customer_name,
       b.customer_number,
       a.amount_due_original,
       a.amount_due_remaining,
       a.amount_applied
 FROM ar_payment_schedules_all a
       ra_customers b
 where a.customer_id=b.customer_id
   and trx_number=<Give Inv Number>


Ref:  AR Invoice balance
https://it.toolbox.com/question/ar-invoice-balance-011709