View to show the available roles for company and cost center security webadi upload
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT M.MENU_NAME ROLE_NAME , M.USER_MENU_NAME ROLE_USER_NAME , M.DESCRIPTION FROM FND_MENUS_VL M , FND_MENU_ENTRIES E WHERE TYPE = 'SECURITY' AND M.MENU_ID = E.MENU_ID AND FUNCTION_ID IS NOT NULL AND FUNCTION_ID IN ( SELECT FUNCTION_ID FROM FND_FORM_FUNCTIONS WHERE FUNCTION_NAME IN ('FII_EA_EXPENSE_PRIVILEGE' , 'FII_EA_REVENUE_PRIVILEGE' , 'FII_PSI_FUND_PRIVILEGE' , 'FII_EA_EXPENSE_PRIVILEGE') )