View: CE_SECURITY_PROFILES_V

Product:	CE - Cash Management
Description:	This view stores organization security access information.
Implementation/DBA Data:	APPS.CE_SECURITY_PROFILES_V

View Text

SELECT 'LEGAL_ENTITY' ORGANIZATION_TYPE
, LE.LEGAL_ENTITY_ID
, LE.NAME
FROM FND_GRANTS GRT
, FND_OBJECTS OBJ
, WF_USER_ROLES ROL
, XLE_ENTITY_PROFILES LE
WHERE GRT.OBJECT_ID = OBJ.OBJECT_ID
AND OBJ.OBJ_NAME = 'CEBAA'
AND GRANTEE_TYPE = 'GROUP'
AND GRANTEE_KEY = ROL.ROLE_NAME
AND ROL.USER_NAME IN ((SELECT FND_GLOBAL.USER_NAME
FROM DUAL) UNION ALL (SELECT INCRNS.NAME
FROM WF_LOCAL_ROLES INCRNS
, FND_USER F
WHERE 'HZ_PARTY' = INCRNS.ORIG_SYSTEM
AND F.USER_NAME = FND_GLOBAL.USER_NAME
AND F.PERSON_PARTY_ID = INCRNS.ORIG_SYSTEM_ID
AND INCRNS.PARTITION_ID = 9))
AND INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT 'LEGAL_ENTITY' ORGANIZATION_TYPE
, LE.LEGAL_ENTITY_ID
, LE.NAME
FROM FND_GRANTS GRT
, FND_OBJECTS OBJ
, XLE_ENTITY_PROFILES LE
WHERE GRT.OBJECT_ID = OBJ.OBJECT_ID
AND OBJ.OBJ_NAME = 'CEBAA'
AND GRANTEE_TYPE = 'USER'
AND GRANTEE_KEY = FND_GLOBAL.USER_NAME
AND INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT 'LEGAL_ENTITY'
, XTR.LEGAL_ENTITY_ID
, XLE.NAME
FROM XTR_PARTIES_V XTR
, GL_SETS_OF_BOOKS SOB
, XLE_ENTITY_PROFILES XLE
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
WHERE PARTY_TYPE = 'C'
AND XTR.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID (+)
AND XTR.SET_OF_BOOKS_ID IS NOT NULL
AND XTR.LEGAL_ENTITY_ID = XLE.LEGAL_ENTITY_ID
AND XCA.PARTY_CODE (+) = XTR.PARTY_CODE
AND XCA.DEALER_CODE = XDC.DEALER_CODE
AND XDC.USER_ID = FND_GLOBAL.USER_ID UNION ALL SELECT 'BUSINESS_GROUP'
, TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
, FND_ACCESS_CONTROL_UTIL.GET_ORG_NAME(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
FROM DUAL UNION ALL SELECT 'OPERATING_UNIT'
, HO.ORGANIZATION_ID
, HO.NAME
FROM HR_OPERATING_UNITS HO
WHERE MO_GLOBAL.CHECK_ACCESS(HO.ORGANIZATION_ID) = 'Y'

Columns