SELECT xep.legal_entity_id "Legal Entity ID", xep.name "Legal Entity", hr_outl.name "Organization Name", hr_outl.organization_id "Organization ID", hr_loc.location_id "Location ID", hr_loc.country "Country Code", hr_loc.location_code "Location Code", glev.flex_segment_value "Company Code" FROM xle_entity_profiles xep, xle_registrations reg, -- hr_operating_units hou, -- hr_all_organization_units hr_ou, hr_all_organization_units_tl hr_outl, hr_locations_all hr_loc, -- gl_legal_entities_bsvs glev WHERE 1=1 AND xep.transacting_entity_flag = 'Y' AND xep.legal_entity_id = reg.source_id AND reg.source_table = 'XLE_ENTITY_PROFILES' AND reg.identifying_flag = 'Y' AND xep.legal_entity_id = hou.default_legal_context_id AND reg.location_id = hr_loc.location_id AND xep.legal_entity_id = glev.legal_entity_id -- -- AND hr_ou.organization_id = hou.business_group_id AND hr_outl.organization_id = hou.organization_id ORDER BY hr_outl.name
Comments
Tags: DBA Oracle, Oracle, Oracle Application, Oracle DBA, Oracle EBS, Oracle Query, Query To Find Legal Entity, Query To Find Legal Entity Organization Company Code, Query To Find Legal Organization Company Code Organization Company Code