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; 

ERP Enterprise Structure in Oracle Application

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.

ERP Enterprise Structure in Oracle Application

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.