Below Script will help you to get the Inventory Org to Business Group details with Legal Entity, Operating Unit, Ledger, Period details, Inventory Validation org and Purchase Validation org for the Operating unit

This script is in the context of Oracle R12

-------------------
select mp.organization_code org_code,
       org.organization_id org_id,
       org.name org_name,
       hl.location_id,
       hl.location_code,
       hl.address_line_1,
       hl.address_line_2,
       hl.address_line_3,
       hl.town_or_city,
       hl.country,
       hl.postal_code,
       ou.organization_id ou_id,
       ou.name OU,
       le.legal_entity_id le_id,
       le.name LE,
       gl.ledger_id,
       gl.name primary_ledger,
       gl.currency_code,
       bg.name bg,
       (select organization_code
          from apps.mtl_parameters
         where organization_id =
               (select parameter_value
                  from apps.OE_SYS_PARAMETERS_ALL
                 where parameter_code = 'MASTER_ORGANIZATION_ID'
                   and org_id = ou.organization_id)) IVO,
       (select organization_code
          from apps.mtl_parameters
         where organization_id =
               (select inventory_organization_id
                  from AP.FINANCIALS_SYSTEM_PARAMS_ALL#
                 where org_id = ou.organization_id)) PVO,
       (select period_name || ' : ' || open_flag
          from apps.ORG_ACCT_PERIODS
         where period_start_date <= trunc(sysdate)
           and schedule_close_date >= trunc(sysdate)
           and organization_id = mp.organization_id) inv_period,
       (select period_name || ' : ' || show_status
          from apps.GL_PERIOD_STATUSES_V
         where start_date <= trunc(sysdate)
           and end_date >= trunc(sysdate)
           and ledger_id = gl.ledger_id
           and application_id = 101) gl_ledger_period,
       (select period_name || ' : ' || show_status
          from apps.GL_PERIOD_STATUSES_V
         where start_date <= trunc(sysdate)
           and end_date >= trunc(sysdate)
           and ledger_id = gl.ledger_id
           and application_id = 200) AP_period,
       (select period_name || ' : ' || show_status
          from apps.GL_PERIOD_STATUSES_V
         where start_date <= trunc(sysdate)
           and end_date >= trunc(sysdate)
           and ledger_id = gl.ledger_id
           and application_id = 222) AR_period,
       (select period_name || ' : ' || show_status
          from apps.GL_PERIOD_STATUSES_V
         where start_date <= trunc(sysdate)
           and end_date >= trunc(sysdate)
           and ledger_id = gl.ledger_id
           and application_id = 201) PO_period

  from apps.XLE_ENTITY_PROFILES         le,
       apps.HR_ALL_ORGANIZATION_UNITS   ou,
       apps.HR_ALL_ORGANIZATION_UNITS   org,
       apps.HR_ALL_ORGANIZATION_UNITS   bg,
       apps.mtl_parameters              mp,
       apps.GL_LEDGERS                  gl,
       apps.HR_ORGANIZATION_INFORMATION ouinfo,
       apps.HR_ORGANIZATION_INFORMATION orginfo,
       apps.hr_locations                hl
 where mp.organization_id = org.organization_id
   and org.organization_id = orginfo.organization_id
   and org.location_id = hl.location_id
   and orginfo.org_information_context = 'Accounting Information'
   and orginfo.org_information3 = ou.organization_id
   and orginfo.org_information1 = gl.ledger_id
   and orginfo.org_information2 = le.legal_entity_id
   and ou.organization_id = ouinfo.organization_id
   and ouinfo.org_information_context = 'Operating Unit Information'
   and ouinfo.org_information2 = le.legal_entity_id
   and ouinfo.org_information3 = gl.ledger_id
   and bg.organization_id = ou.business_group_id
   and mp.organization_code in ('V1');

-------------------------

Read More

Run this script giving inventory org as the parameter

SELECT mp.organization_id,

       MP.ORGANIZATION_CODE,

       hl.address_line_1,

       hl.address_line_2,

       hl.address_line_3,

       hl.town_or_city,

       hl.country,

       hl.postal_code,

       HAOU.NAME,

       HAOUBG.NAME BUSINESS_GROUP,

       GSOB.SET_OF_BOOKS_ID,

       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

  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,

       apps.hr_locations                hl

 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

   and haou.location_id = hl.location_id

;

Read More

Enterprise Structure

Enterprise Structure defines how a company is structured from an operating, legal and reporting perspective. Oracle Application considers the following in defining enterprise structure from an Inventory perspective:

·         Set of Books

·         Legal Entity

·         Operating Unit

·         Inventory Organization

·         Locations

Set of Books (SoB)

This is a financial reporting entity having unique Chart of Account, Calendar and currency. A corporation may have more than one Set of Books. Each Set of Book has the following :

·         Calendar: This is the accounting calendar; this might be different from the workday calendar.

·         Currency: Each SoB has unique functional currency. Transactions can be enetered in multiple currencies which can be converted later.

·         Chart of Accounts: Each SoB has unique chart of Account which represent the set of accounts that related to the Inventory, Purchasing and Account Payables.

Legal Entity

This can be defined as the legal company for which fiscal or tax report can be prepared. A SoB can have multiple tax entities.

Operating Unit

This is a division. A corporation can be divided considering its operation. For example, a computer manufacturer may have separate divisions for Laptop, personal computers and Servers. The Laptop can be represented by one operating unit, which is having its centralized purchasing and ordering function.  The physical part, which is Inventory may have received in separate inventory organization but the purchase orders are maintained centrally in an operating unit to optimize the supply chain. Operating units affects transactions involving in order management, purchasing, payables and receivables.

Inventory Organization

This can be manufacturing facilities, warehouse or any facilities where a company stocks and transacts inventory.

Sub-Inventories

In Oracle Application, these are the physical locations within a manufacturing or warehouse facilities where goods are stocked and transaction takes place from here. These are created inside Inventory Organizations.

Locations

This represents a physical address of a facility, office, warehouse or any place else used in the entity. Inventory Organization uses locations to represent the address of the following:

·         Ship To

·         Bill To

·         Office Site

·         Internal Site

·         Receiving Site

Each Inventory Organization must have at least one location.

Read More