VIEW: APPS.HZ_DSS_GRANTS_V

Source

View Text - Preformatted

SELECT DISTINCT FG.PROGRAM_TAG DSS_GROUP_CODE, FG.GRANTEE_TYPE DSS_GRANTEE_TYPE, FG.GRANTEE_KEY DSS_GRANTEE_KEY, (SELECT 'Y' FROM FND_GRANTS GV, FND_MENUS MV where GV.OBJECT_ID = FG.OBJECT_ID AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE AND GV.GRANTEE_KEY = FG.GRANTEE_KEY AND GV.PROGRAM_TAG = FG.PROGRAM_TAG AND GV.MENU_ID = MV.MENU_ID AND MV.MENU_NAME = 'HZ_DSS_SELECT' AND ROWNUM=1) VIEW_FLAG, (SELECT 'Y' FROM FND_GRANTS GV, FND_MENUS MV WHERE GV.OBJECT_ID = FG.OBJECT_ID AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE AND GV.GRANTEE_KEY = FG.GRANTEE_KEY AND GV.PROGRAM_TAG = FG.PROGRAM_TAG AND GV.MENU_ID = MV.MENU_ID AND MV.MENU_NAME = 'HZ_DSS_INSERT' AND ROWNUM=1) INSERT_FLAG, (SELECT 'Y' FROM FND_GRANTS GV, FND_MENUS MV WHERE GV.OBJECT_ID = FG.OBJECT_ID AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE AND GV.GRANTEE_KEY = FG.GRANTEE_KEY AND GV.PROGRAM_TAG = FG.PROGRAM_TAG AND GV.MENU_ID = MV.MENU_ID AND MV.MENU_NAME = 'HZ_DSS_UPDATE' AND ROWNUM=1) UPDATE_FLAG, (SELECT 'Y' FROM FND_GRANTS GV, FND_MENUS MV WHERE GV.OBJECT_ID = FG.OBJECT_ID AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE AND GV.GRANTEE_KEY = FG.GRANTEE_KEY AND GV.PROGRAM_TAG = FG.PROGRAM_TAG AND GV.MENU_ID = MV.MENU_ID AND MV.MENU_NAME = 'HZ_DSS_DELETE' AND ROWNUM=1) DELETE_FLAG FROM FND_GRANTS FG, FND_OBJECTS FO WHERE FO.OBJ_NAME = 'HZ_DSS_GROUPS' AND FG.OBJECT_ID = FO.OBJECT_ID AND FG.GRANTEE_TYPE IN ('USER','GLOBAL','GROUP')

View Text - HTML Formatted

SELECT DISTINCT FG.PROGRAM_TAG DSS_GROUP_CODE
, FG.GRANTEE_TYPE DSS_GRANTEE_TYPE
, FG.GRANTEE_KEY DSS_GRANTEE_KEY
, (SELECT 'Y'
FROM FND_GRANTS GV
, FND_MENUS MV
WHERE GV.OBJECT_ID = FG.OBJECT_ID
AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE
AND GV.GRANTEE_KEY = FG.GRANTEE_KEY
AND GV.PROGRAM_TAG = FG.PROGRAM_TAG
AND GV.MENU_ID = MV.MENU_ID
AND MV.MENU_NAME = 'HZ_DSS_SELECT'
AND ROWNUM=1) VIEW_FLAG
, (SELECT 'Y'
FROM FND_GRANTS GV
, FND_MENUS MV
WHERE GV.OBJECT_ID = FG.OBJECT_ID
AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE
AND GV.GRANTEE_KEY = FG.GRANTEE_KEY
AND GV.PROGRAM_TAG = FG.PROGRAM_TAG
AND GV.MENU_ID = MV.MENU_ID
AND MV.MENU_NAME = 'HZ_DSS_INSERT'
AND ROWNUM=1) INSERT_FLAG
, (SELECT 'Y'
FROM FND_GRANTS GV
, FND_MENUS MV
WHERE GV.OBJECT_ID = FG.OBJECT_ID
AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE
AND GV.GRANTEE_KEY = FG.GRANTEE_KEY
AND GV.PROGRAM_TAG = FG.PROGRAM_TAG
AND GV.MENU_ID = MV.MENU_ID
AND MV.MENU_NAME = 'HZ_DSS_UPDATE'
AND ROWNUM=1) UPDATE_FLAG
, (SELECT 'Y'
FROM FND_GRANTS GV
, FND_MENUS MV
WHERE GV.OBJECT_ID = FG.OBJECT_ID
AND GV.GRANTEE_TYPE = FG.GRANTEE_TYPE
AND GV.GRANTEE_KEY = FG.GRANTEE_KEY
AND GV.PROGRAM_TAG = FG.PROGRAM_TAG
AND GV.MENU_ID = MV.MENU_ID
AND MV.MENU_NAME = 'HZ_DSS_DELETE'
AND ROWNUM=1) DELETE_FLAG
FROM FND_GRANTS FG
, FND_OBJECTS FO
WHERE FO.OBJ_NAME = 'HZ_DSS_GROUPS'
AND FG.OBJECT_ID = FO.OBJECT_ID
AND FG.GRANTEE_TYPE IN ('USER'
, 'GLOBAL'
, 'GROUP')