SELECT DISTINCT
--HRL.COUNTRY,
HROUTL_BG.ORGANIZATION_ID BG_ID,
HROUTL_BG.NAME BG,
HRO.SET_OF_BOOKS_ID LEDGER_ID,
GSOB.NAME LEDGER_NAME,
LEP.LEGAL_ENTITY_ID,
LEP.NAME LEGAL_ENTITY,
HROUTL_OU.ORGANIZATION_ID ORG_ID,
HROUTL_OU.NAME OU_NAME,
HRL.LOCATION_ID,
HRL.LOCATION_CODE,
GLEV.FLEX_SEGMENT_VALUE
FROM APPS.XLE_ENTITY_PROFILES LEP,
APPS.XLE_REGISTRATIONS REG,
APPS.HR_LOCATIONS_ALL HRL,
APPS.HZ_PARTIES HZP,
APPS.FND_TERRITORIES_VL TER,
APPS.HR_OPERATING_UNITS HRO,
APPS.HR_ALL_ORGANIZATION_UNITS_TL HROUTL_BG,
APPS.HR_ALL_ORGANIZATION_UNITS_TL HROUTL_OU,
APPS.HR_ORGANIZATION_UNITS HOU,
APPS.GL_LEGAL_ENTITIES_BSVS GLEV,
APPS.GL_SETS_OF_BOOKS GSOB
WHERE LEP.TRANSACTING_ENTITY_FLAG = 'Y'
AND LEP.PARTY_ID = HZP.PARTY_ID
AND LEP.LEGAL_ENTITY_ID = REG.SOURCE_ID
AND REG.SOURCE_TABLE = 'XLE_ENTITY_PROFILES'
AND HRL.LOCATION_ID = REG.LOCATION_ID
AND REG.IDENTIFYING_FLAG = 'Y'
AND TER.TERRITORY_CODE = HRL.COUNTRY
AND LEP.LEGAL_ENTITY_ID = HRO.DEFAULT_LEGAL_CONTEXT_ID
AND HOU.ORGANIZATION_ID = HRO.ORGANIZATION_ID
AND HROUTL_BG.ORGANIZATION_ID = HRO.BUSINESS_GROUP_ID
AND HROUTL_OU.ORGANIZATION_ID = HRO.ORGANIZATION_ID
AND GLEV.LEGAL_ENTITY_ID = LEP.LEGAL_ENTITY_ID
AND GSOB.SET_OF_BOOKS_ID = HRO.SET_OF_BOOKS_ID
--and hroutl_ou.NAME =
--HRL.COUNTRY,
HROUTL_BG.ORGANIZATION_ID BG_ID,
HROUTL_BG.NAME BG,
HRO.SET_OF_BOOKS_ID LEDGER_ID,
GSOB.NAME LEDGER_NAME,
LEP.LEGAL_ENTITY_ID,
LEP.NAME LEGAL_ENTITY,
HROUTL_OU.ORGANIZATION_ID ORG_ID,
HROUTL_OU.NAME OU_NAME,
HRL.LOCATION_ID,
HRL.LOCATION_CODE,
GLEV.FLEX_SEGMENT_VALUE
FROM APPS.XLE_ENTITY_PROFILES LEP,
APPS.XLE_REGISTRATIONS REG,
APPS.HR_LOCATIONS_ALL HRL,
APPS.HZ_PARTIES HZP,
APPS.FND_TERRITORIES_VL TER,
APPS.HR_OPERATING_UNITS HRO,
APPS.HR_ALL_ORGANIZATION_UNITS_TL HROUTL_BG,
APPS.HR_ALL_ORGANIZATION_UNITS_TL HROUTL_OU,
APPS.HR_ORGANIZATION_UNITS HOU,
APPS.GL_LEGAL_ENTITIES_BSVS GLEV,
APPS.GL_SETS_OF_BOOKS GSOB
WHERE LEP.TRANSACTING_ENTITY_FLAG = 'Y'
AND LEP.PARTY_ID = HZP.PARTY_ID
AND LEP.LEGAL_ENTITY_ID = REG.SOURCE_ID
AND REG.SOURCE_TABLE = 'XLE_ENTITY_PROFILES'
AND HRL.LOCATION_ID = REG.LOCATION_ID
AND REG.IDENTIFYING_FLAG = 'Y'
AND TER.TERRITORY_CODE = HRL.COUNTRY
AND LEP.LEGAL_ENTITY_ID = HRO.DEFAULT_LEGAL_CONTEXT_ID
AND HOU.ORGANIZATION_ID = HRO.ORGANIZATION_ID
AND HROUTL_BG.ORGANIZATION_ID = HRO.BUSINESS_GROUP_ID
AND HROUTL_OU.ORGANIZATION_ID = HRO.ORGANIZATION_ID
AND GLEV.LEGAL_ENTITY_ID = LEP.LEGAL_ENTITY_ID
AND GSOB.SET_OF_BOOKS_ID = HRO.SET_OF_BOOKS_ID
--and hroutl_ou.NAME =
No comments:
Post a Comment