EXPERT RESPONSE
Hi,
ar_invoice_commitment_info_v will give you commitment balances for deposits.
This is a view, so you will need to source your environment to view the data.
ar_payment_schedules_all will give you the due amounts.
What you are asking for sounds rather complex for a single query and possibly slow for a set of views. In the past when I needed to generate custom dunning letters and reports of this nature, I would create a package that contained a series of functions, then write a query to call the functions. You will find this approach easier to tune, maintain and add future reporting requirements to.
Enjoy,
Russell
|
