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