VIEW: APPS.JTF_TASK_SECURITY_V

Source

View Text - Preformatted

SELECT group_id rs_id , 'RS_GROUP' rs_type , 'JTF_TASK_FULL_ACCESS' privelege , to_char( resource_id) logged_resource_in from jtf_rs_group_members union all select resource_id , 'RS_'||category ,'JTF_TASK_FULL_ACCESS' privelege , to_char( resource_id) logged_resource_in from jtf_rs_resource_extns where user_id = fnd_global.user_id union all select team_id , 'RS_TEAM' , 'JTF_TASK_FULL_ACCESS' privelege , to_char(team_resource_id) logged_resource_in from jtf_rs_team_members union all select to_number(fg.instance_pk1_value) , fg.instance_pk2_value , fff.function_name , grantee_key logged_resource_in from fnd_form_functions fff, fnd_menu_entries fme, fnd_menus fm, fnd_grants fg, fnd_objects WHERE fff.function_id = fme.function_id AND fme.menu_id = fm.menu_id and fm.menu_id = fg.menu_id and fg.object_id = fnd_objects.object_id and obj_name = 'JTF_TASK_RESOURCE'

View Text - HTML Formatted

SELECT GROUP_ID RS_ID
, 'RS_GROUP' RS_TYPE
, 'JTF_TASK_FULL_ACCESS' PRIVELEGE
, TO_CHAR( RESOURCE_ID) LOGGED_RESOURCE_IN
FROM JTF_RS_GROUP_MEMBERS UNION ALL SELECT RESOURCE_ID
, 'RS_'||CATEGORY
, 'JTF_TASK_FULL_ACCESS' PRIVELEGE
, TO_CHAR( RESOURCE_ID) LOGGED_RESOURCE_IN
FROM JTF_RS_RESOURCE_EXTNS
WHERE USER_ID = FND_GLOBAL.USER_ID UNION ALL SELECT TEAM_ID
, 'RS_TEAM'
, 'JTF_TASK_FULL_ACCESS' PRIVELEGE
, TO_CHAR(TEAM_RESOURCE_ID) LOGGED_RESOURCE_IN
FROM JTF_RS_TEAM_MEMBERS UNION ALL SELECT TO_NUMBER(FG.INSTANCE_PK1_VALUE)
, FG.INSTANCE_PK2_VALUE
, FFF.FUNCTION_NAME
, GRANTEE_KEY LOGGED_RESOURCE_IN
FROM FND_FORM_FUNCTIONS FFF
, FND_MENU_ENTRIES FME
, FND_MENUS FM
, FND_GRANTS FG
, FND_OBJECTS
WHERE FFF.FUNCTION_ID = FME.FUNCTION_ID
AND FME.MENU_ID = FM.MENU_ID
AND FM.MENU_ID = FG.MENU_ID
AND FG.OBJECT_ID = FND_OBJECTS.OBJECT_ID
AND OBJ_NAME = 'JTF_TASK_RESOURCE'