QUESTION POSED ON: 08 November 2006
This is in regards to account queries in Oracle AR Receivables. We need to generate the below three queries to develop a marketing campaign. All these queries are based on Oracle AR Receivables.
- 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.
|