Oracle applications useful queries 2011-03-19

This Document contains ready made query scripts for querying several useful information in Oracle Apps.

The Queries are:

• Responsibilities Listing
• To get Menus Associated with responsibility
• To get submenus and Function attached to this Main menu.
• To get assigned responsibility to a user.
• To get responsibility and attached request groups.
• To get modified profile options.
• To get Patch Level.
• To get all Functions
• To get all Request attached to a responsibility
• To get all request with application
• To Count Module Wise Report
• To calculate request time
• Check responsibility assigned to a specific USER
• Check Current Applied Patch