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'