VIEW: APPS.FII_CCC_SEC_ROLES_V

Source

View Text - Preformatted

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') )

View Text - HTML Formatted

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') )