Query to find the Organization structure of a business

Run this script giving inventory org as the parameter

SELECT MP.ORGANIZATION_CODE,
       HAOU.NAME,

      HAOUBG.NAME BUSINESS_GROUP,
      GSOB.NAME SOB_NAME, /*gsob.short_name,*/
      GSOB.CURRENCY_CODE,
      GSOB.PERIOD_SET_NAME,
      (SELECT SEGMENT1 || ‘.’ || SEGMENT2 || ‘.’ ||SEGMENT3 || ‘.’ ||
              SEGMENT4 || ‘.’ || SEGMENT5 || ‘.’ ||SEGMENT6 || ‘.’ ||
              SEGMENT7 || ‘.’ || SEGMENT8 || ‘.’ ||SEGMENT9
         FROM APPS.GL_CODE_COMBINATIONS
        WHERE CODE_COMBINATION_ID =GSOB.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNT,
      HLE.NAME LE_NAME,
      HLE.VAT_REGISTRATION_NUMBER,
      HOU.NAME OU_NAME
—  ,hri.*
 FROM APPS.HR_ALL_ORGANIZATION_UNITS   HAOU,
      APPS.HR_ORGANIZATION_INFORMATION HRI,
      APPS.MTL_PARAMETERS              MP,
      APPS.GL_SETS_OF_BOOKS            GSOB,
      APPS.HR_LEGAL_ENTITIES           HLE,
      APPS.HR_OPERATING_UNITS          HOU,
      APPS.HR_ALL_ORGANIZATION_UNITS   HAOUBG,
      APPS.HR_ORGANIZATION_INFORMATION HRIBG

WHERE HRI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
  AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
  AND MP.ORGANIZATION_CODE IN (‘V1’)
  AND HRI.ORG_INFORMATION_CONTEXT = ‘Accounting Information’
  AND GSOB.SET_OF_BOOKS_ID = HRI.ORG_INFORMATION1
  AND HLE.ORGANIZATION_ID = HRI.ORG_INFORMATION2
  AND HOU.ORGANIZATION_ID = HRI.ORG_INFORMATION3
  AND HAOUBG.ORGANIZATION_ID = HLE.BUSINESS_GROUP_ID
  AND HRIBG.ORG_INFORMATION_CONTEXT = ‘Business Group Information’
  AND HRIBG.ORGANIZATION_ID =HAOUBG.ORGANIZATION_ID;