Showing posts with label Query to find Oracle Form attached to Responsibility. Show all posts
Showing posts with label Query to find Oracle Form attached to Responsibility. Show all posts

Monday, 11 November 2019

Query to find Oracle Form attached to Responsibility , Menu and users in oracle apps EBS

/* ------ Query to find Oracle Form attached to Responsibility , Menu and users in oracle apps EBS  ------- */

SELECT DISTINCT U.USER_NAME,
       RTL.RESPONSIBILITY_NAME,
       FF.FUNCTION_NAME,
       FFL.USER_FUNCTION_NAME,
       FM.MENU_NAME
  FROM FND_COMPILED_MENU_FUNCTIONS CMF,
       FND_FORM_FUNCTIONS FF,
       FND_FORM_FUNCTIONS_TL FFL,
       FND_RESPONSIBILITY R,
       FND_RESPONSIBILITY_TL RTL,
       FND_USER_RESP_GROUPS URG,
       FND_USER U,
       FND_MENUS FM
 WHERE CMF.FUNCTION_ID       = FF.FUNCTION_ID
   AND R.MENU_ID             = CMF.MENU_ID
   AND URG.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
   AND RTL.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
   AND CMF.GRANT_FLAG        = 'Y'
   AND R.APPLICATION_ID      = URG.RESPONSIBILITY_APPLICATION_ID
   AND U.USER_ID             = URG.USER_ID
   AND UPPER (FFL.USER_FUNCTION_NAME) = UPPER ('XXBEXMUSHAKFORM')
   AND FF.FUNCTION_ID        = FFL.FUNCTION_ID
   AND CMF.MENU_ID           = FM.MENU_ID 
ORDER BY U.USER_NAME;

How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

  How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...