All current INACTIVE Customers with transactions

[dbarookie]

I?m new to Oracle Apps; I need a query to get all current INACTIVE Customers with transactions, orders, or service contracts. Can anyone guide me with the query? How do I validate the query output?

thanks

[SIVAKUMAR_G]

Hi

I guess Your requirement should be possible through Bill Presentment Architecture Module (BPA) which holds the information of OM, Service Contracts and Invoices for active and inactive customers.

From receivables you can find the details of inactive customers as follows
Receivables Responsibility
Collections/ Customer Accounts
Click and choose status as Inactive Customers and click on Find it will list all inactive customers then for each customer if you click Account overview you get the details of Invoices, credit memo Debit memo etc.,

I tried to find the view name from Record history and unable to find. May be if you check with eTRM, you might get it

Hope this helps

Regards
Sivakumar