Enterprise Structure Query in Oracle Fusion Cloud

SELECT   DISTINCT

        hroutl_bg.NAME enterprise,

        hroutl_bg.organization_id bu_id,

       lep.legal_entity_id,

       lep.NAME legal_entity,

       hroutl_ou.NAME bu_name,

       hroutl_ou.organization_id org_id,

      glev.FLEX_SEGMENT_VALUE

  FROM xle_entity_profiles lep,

       xle_registrations reg,

      hz_parties hzp,

       hr_operating_units hro,

       hr_all_organization_units_tl hroutl_bg,

       hr_all_organization_units_tl hroutl_ou,

       hr_organization_units gloperatingunitseo,

      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 reg.identifying_flag = 'Y'

   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_bg.language ='US'

   AND hroutl_ou.organization_id = hro.organization_id

   AND glev.legal_entity_id = lep.legal_entity_id;