VIEW: APPS.IBC_DIRECTORY_PERMISSIONS_V

Source

View Text - Preformatted

SELECT obj.obj_name object_name, instance_pk1_value directory_node_id, MAX(ig.grant_id), DECODE(grantee_user_id, NULL, DECODE(grantee_resource_id, NULL, 'GLOBAL', DECODE(grantee_resource_type, 'RS_GROUP', 'GROUP', grantee_resource_type)), 'USER') , DECODE(grantee_user_id, NULL, DECODE(grantee_resource_id, NULL, NULL, grantee_resource_id), grantee_user_id), action, MAX(DECODE(permission_code, 'DIR_EDIT', 'Y', 'N')), MAX(DECODE(permission_code, 'DIR_CREATE', 'Y', 'N')), MAX(DECODE(permission_code, 'CITEM_EDIT', 'Y', 'N')), MAX(DECODE(permission_code, 'CITEM_APPROVE', 'Y', 'N')), MAX(DECODE(permission_code, 'CITEM_APPROVE_TRANSLATE', 'Y', 'N')), MAX(DECODE(permission_code, 'CITEM_TRANSLATE', 'Y', 'N')), MAX(DECODE(permission_code, 'CITEM_READ', 'Y', 'N')), MAX(DECODE(permission_code, 'PD_EDIT', 'Y', 'N')), MAX(DECODE(permission_code, 'PD_PUBLISH', 'Y', 'N')), MAX(DECODE(permission_code, 'PD_VIEW', 'Y', 'N')) FROM fnd_objects obj, ibc_object_grant_groups grantg, ibc_grants ig WHERE grantg.object_id = obj.object_id AND obj.obj_name IN ('IBC_DIRECTORY_NODE', 'IBC_CATEGORY_NODE') AND grantg.grant_group_id = ig.grant_group_id GROUP BY obj_name, instance_pk1_value, grantee_user_id, grantee_resource_id, grantee_resource_type, action

View Text - HTML Formatted

SELECT OBJ.OBJ_NAME OBJECT_NAME
, INSTANCE_PK1_VALUE DIRECTORY_NODE_ID
, MAX(IG.GRANT_ID)
, DECODE(GRANTEE_USER_ID
, NULL
, DECODE(GRANTEE_RESOURCE_ID
, NULL
, 'GLOBAL'
, DECODE(GRANTEE_RESOURCE_TYPE
, 'RS_GROUP'
, 'GROUP'
, GRANTEE_RESOURCE_TYPE))
, 'USER')
, DECODE(GRANTEE_USER_ID
, NULL
, DECODE(GRANTEE_RESOURCE_ID
, NULL
, NULL
, GRANTEE_RESOURCE_ID)
, GRANTEE_USER_ID)
, ACTION
, MAX(DECODE(PERMISSION_CODE
, 'DIR_EDIT'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'DIR_CREATE'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'CITEM_EDIT'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'CITEM_APPROVE'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'CITEM_APPROVE_TRANSLATE'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'CITEM_TRANSLATE'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'CITEM_READ'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'PD_EDIT'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'PD_PUBLISH'
, 'Y'
, 'N'))
, MAX(DECODE(PERMISSION_CODE
, 'PD_VIEW'
, 'Y'
, 'N'))
FROM FND_OBJECTS OBJ
, IBC_OBJECT_GRANT_GROUPS GRANTG
, IBC_GRANTS IG
WHERE GRANTG.OBJECT_ID = OBJ.OBJECT_ID
AND OBJ.OBJ_NAME IN ('IBC_DIRECTORY_NODE'
, 'IBC_CATEGORY_NODE')
AND GRANTG.GRANT_GROUP_ID = IG.GRANT_GROUP_ID GROUP BY OBJ_NAME
, INSTANCE_PK1_VALUE
, GRANTEE_USER_ID
, GRANTEE_RESOURCE_ID
, GRANTEE_RESOURCE_TYPE
, ACTION