VIEW: APPS.CE_LE_BG_OU_VS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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