View: JTF_TASK_SECURITY_V

Product:	JTF - CRM Foundation
Description:	This view is used to get the group or team resources granting full access to a login resource and group/team or employee resources granting a certain level of access to a login resource.
Implementation/DBA Data:	APPS.JTF_TASK_SECURITY_V

View Text

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'

Columns