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 change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...