Useful Queries

Friends, Here are some useful queries.

1. Database and Application Information?
http://retoscripts.blogspot.com/2009/09/database-and-application-information.html

2. Get onhand quantity at given date
http://retoscripts.blogspot.com/2009/09/onhand-quantity-at-given-date.html

3. Link Purchase Order and Requisition
http://retoscripts.blogspot.com/2009/09/link-purchase-order-and-requisition.html

4. Different Types of Table in Oracle Apps
http://retoscripts.blogspot.com/2009/09/different-types-of-table-in-oracle-apps.html

5. Which User is Locking the table?
http://retoscripts.blogspot.com/2009/09/which-user-is-locking-table.html

6. Query for Customer Receipt Details
http://retoscripts.blogspot.com/2009/09/query-for-customer-receipt-details.html

7. Query for Supplier Bank Details
http://retoscripts.blogspot.com/2009/09/query-for-supplier-bank-details.html

8. Query for Customer Address Details
http://retoscripts.blogspot.com/2009/09/query-for-customer-address-details.html

9. Query for Sales Order Details
http://retoscripts.blogspot.com/2009/09/query-for-sales-order-details.html

10. Query to get Request Group Details Responsibility wise
http://retoscripts.blogspot.com/2009/09/query-to-get-request-group-details.html

11. Query to find who and when update an Oracle Application user's profile
http://retoscripts.blogspot.com/2009/09/query-to-find-who-and-when-update.html

Thanks & Regards,
Anto Joe Natesh I