1. Get unlimited access to documents by upgrading to Premium Membership.
  2. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice
kiran.marla

Oracle applications useful queries 2011-03-19

Oracle applications useful queries

  1. kiran.marla
    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
    Ajayvk likes this.