- Amount overdue at bill-to at bill-to level is greater than on-account (on-account credit + on account cash) at the bill-to level.
- Amount overdue at bill-to at bill-to level is equal to on-account (on-account credit + on account cash) at the bill-to level.
- There is no amount overdue at bill-to level is equal and on-account (on-account credit + on account cash) is more than 0 at the bill-to level.
Any advice would be helpful.
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.
Dig Deeper on Oracle E-Business Suite
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.