SQL Script/Query to get the Business Group Structure in R12, 11i

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 =