VIEW: APPS.FND_OBJ_INS_SET_GRANTS_V

Source

View Text - Preformatted

SELECT DISTINCT instance_sets.predicate predicate, grants.grantee_key grantee_key, grants.grantee_type grantee_type, grants.object_id object_id, grants.instance_set_id, functions.function_name FROM fnd_grants grants, fnd_form_functions functions, fnd_menu_entries role_privileges, fnd_object_instance_sets instance_sets WHERE grants.instance_type = 'SET' AND trunc(grants.start_date)<=trunc(SYSDATE) AND ( grants.end_date IS NULL OR trunc(grants.end_date) >= trunc(SYSDATE) ) AND role_privileges.function_id = functions.function_id AND grants.instance_set_id = instance_sets.instance_set_id AND role_privileges.menu_id in (select m.menu_id from fnd_menu_entries m connect by m.menu_id=prior m.sub_menu_id start with m.menu_id=grants.menu_id)

View Text - HTML Formatted

SELECT DISTINCT INSTANCE_SETS.PREDICATE PREDICATE
, GRANTS.GRANTEE_KEY GRANTEE_KEY
, GRANTS.GRANTEE_TYPE GRANTEE_TYPE
, GRANTS.OBJECT_ID OBJECT_ID
, GRANTS.INSTANCE_SET_ID
, FUNCTIONS.FUNCTION_NAME
FROM FND_GRANTS GRANTS
, FND_FORM_FUNCTIONS FUNCTIONS
, FND_MENU_ENTRIES ROLE_PRIVILEGES
, FND_OBJECT_INSTANCE_SETS INSTANCE_SETS
WHERE GRANTS.INSTANCE_TYPE = 'SET'
AND TRUNC(GRANTS.START_DATE)<=TRUNC(SYSDATE)
AND ( GRANTS.END_DATE IS NULL OR TRUNC(GRANTS.END_DATE) >= TRUNC(SYSDATE) )
AND ROLE_PRIVILEGES.FUNCTION_ID = FUNCTIONS.FUNCTION_ID
AND GRANTS.INSTANCE_SET_ID = INSTANCE_SETS.INSTANCE_SET_ID
AND ROLE_PRIVILEGES.MENU_ID IN (SELECT M.MENU_ID
FROM FND_MENU_ENTRIES M CONNECT BY M.MENU_ID=PRIOR M.SUB_MENU_ID START WITH M.MENU_ID=GRANTS.MENU_ID)