View: HZ_DSS_GRANTS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_DSS_GRANTS_V

View Text

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

Columns