View: IBC_CITEM_PERMISSIONS_V

Product:	IBC - Content Manager
Description:
Implementation/DBA Data:	APPS.IBC_CITEM_PERMISSIONS_V

View Text

SELECT DISTINCT IG.OBJECT_ID
, IG.PERMISSION_CODE
, CI.*
FROM IBC_OBJECT_GRANT_GROUPS OGG
, IBC_CONTENT_ITEMS CI
, FND_OBJECTS GRANTED_AT
, IBC_GRANTS IG
, FND_OBJECTS GRANTED_TO
WHERE OGG.OBJECT_ID = GRANTED_AT.OBJECT_ID
AND GRANTED_AT.OBJ_NAME = 'IBC_DIRECTORY_NODE'
AND OGG.GRANT_GROUP_ID = IG.GRANT_GROUP_ID
AND CI.DIRECTORY_NODE_ID = OGG.INSTANCE_PK1_VALUE
AND (OGG.INHERITED_FLAG = 'N' OR IG.CASCADE_FLAG = 'T')
AND IG.ACTION = 'ALLOW'
AND IG.OBJECT_ID = GRANTED_TO.OBJECT_ID
AND GRANTED_TO.OBJ_NAME = 'IBC_CONTENT_ITEM'
AND ((GRANTEE_USER_ID IS NULL
AND GRANTEE_RESOURCE_ID IS NULL) OR (IBC_UTILITIES_PVT.CHECK_CURRENT_USER( GRANTEE_USER_ID
, GRANTEE_RESOURCE_ID
, GRANTEE_RESOURCE_TYPE) = 'TRUE') )
AND NOT EXISTS ( SELECT 'X'
FROM IBC_GRANTS A1
WHERE A1.GRANT_GROUP_ID = IG.GRANT_GROUP_ID
AND A1.OBJECT_ID = IG.OBJECT_ID
AND A1.PERMISSION_CODE = IG.PERMISSION_CODE
AND A1.ACTION = 'RESTRICT'
AND A1.GRANT_LEVEL < IG.GRANT_LEVEL
AND ((GRANTEE_USER_ID IS NULL
AND GRANTEE_RESOURCE_ID IS NULL) OR (IBC_UTILITIES_PVT.CHECK_CURRENT_USER( GRANTEE_USER_ID
, GRANTEE_RESOURCE_ID
, GRANTEE_RESOURCE_TYPE) = 'TRUE') ) ) -- PROFILE SECURITY OPTION (CHECKED ONLY AT SITE LEVEL)
AND ( FND_PROFILE.VALUE_SPECIFIC('IBC_USE_ACCESS_CONTROL'
, NULL
, NULL
, NULL) = 'Y' ) UNION SELECT IBC_OBJECT_PERMISSIONS.OBJECT_ID
, FND_LOOKUP_VALUES.LOOKUP_CODE PERMISSION_CODE
, IBC_CONTENT_ITEMS.*
FROM FND_OBJECTS
, IBC_OBJECT_PERMISSIONS
, FND_LOOKUP_VALUES
, IBC_CONTENT_ITEMS
WHERE FND_OBJECTS.OBJ_NAME = 'IBC_CONTENT_ITEM'
AND FND_OBJECTS.OBJECT_ID = IBC_OBJECT_PERMISSIONS.OBJECT_ID
AND FND_LOOKUP_VALUES.LOOKUP_TYPE = IBC_OBJECT_PERMISSIONS.PERMISSIONS_LOOKUP_TYPE
AND FND_LOOKUP_VALUES.LANGUAGE = 'US'
AND FND_PROFILE.VALUE_SPECIFIC('IBC_USE_ACCESS_CONTROL'
, NULL
, NULL
, NULL) = 'N'

Columns