--Responsibility on the base of Form
SELECT fr.*
FROM FND_MENU_ENTRIES FME,
FND_RESPONSIBILITY_VL fr
WHERE EXISTS
(SELECT 'FUNCTION_ID'
FROM FND_FORM FF,
FND_FORM_FUNCTIONS F3
WHERE FF.FORM_NAME = 'FORM_NAME'
AND F3.FORM_ID = FF.FORM_ID
AND F3.APPLICATION_ID =
FF.APPLICATION_ID
AND FME.FUNCTION_ID = F3.FUNCTION_ID)
AND
fr.MENU_ID = fme.menu_id
No comments:
Post a Comment