SELECT DISTINCT hrl.country,
hroutl_bg.name bg,
hroutl_bg.organization_id,
lep.legal_entity_id,
lep.name legal_entity,
hroutl_ou.name ou_name,
hroutl_ou.organization_id org_id,
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,
hr_organization_units gloperatingunitseo,
apps.gl_legal_entities_bsvs glev
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 gloperatingunitseo.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 hro.date_to IS NULL
hroutl_bg.name bg,
hroutl_bg.organization_id,
lep.legal_entity_id,
lep.name legal_entity,
hroutl_ou.name ou_name,
hroutl_ou.organization_id org_id,
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,
hr_organization_units gloperatingunitseo,
apps.gl_legal_entities_bsvs glev
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 gloperatingunitseo.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 hro.date_to IS NULL
Comments
Post a Comment