AP [message #386109] |
Thu, 12 February 2009 12:55 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
bharatt19
Messages: 7 Registered: February 2009 Location: banglore
|
Junior Member |
|
|
Detailed Problem Statement: We are in the process of cleaning up our supplier records. I would appreciate if there are any scripts available to identify no-activity suppliers since one year. This script output would help us inactivating the said suppliers.
no-active suppliers mean that we have not done any business with them since 1 year or so (no payment/invoices/PO etc..) The transactions should include PO, AP Invoices and Payments
hye i have this requirement would any one please ans or gve the select query for this????
|
|
|
Re: AP [message #386129 is a reply to message #386109] |
Thu, 12 February 2009 17:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Your test would have been better if you had used the 'Spell-check Message' facility.
David
|
|
|