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