1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
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.