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;

No comments:

Post a Comment

How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...