/* ------ 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;
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