View: CE_LE_BG_OU_VS_V

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

View Text

SELECT 'LEGAL_ENTITY' ORGANIZATION_TYPE
, NULL
, LE.LEGAL_ENTITY_ID
, LE.NAME NAME
, 'L'||LE.LEGAL_ENTITY_ID
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 INSTANCE_PK1_VALUE = TO_CHAR(LE.LEGAL_ENTITY_ID) UNION SELECT 'LEGAL_ENTITY' ORGANIZATION_TYPE
, NULL
, LE.LEGAL_ENTITY_ID
, LE.NAME NAME
, 'L'||LE.LEGAL_ENTITY_ID
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'
, NULL
, XTR.LEGAL_ENTITY_ID
, XLE.NAME NAME
, 'L'||XTR.LEGAL_ENTITY_ID
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'))
, NULL
, FND_ACCESS_CONTROL_UTIL.GET_ORG_NAME(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')) NAME
, 'O'||TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
FROM DUAL
WHERE FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') IS NOT NULL UNION ALL SELECT 'OPERATING_UNIT'
, ORGANIZATION_ID
, NULL
, NAME NAME
, 'O'||ORGANIZATION_ID
FROM HR_OPERATING_UNITS
WHERE MO_GLOBAL.CHECK_ACCESS(ORGANIZATION_ID) = 'Y' ORDER BY NAME

Columns