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;