• Multi Org Concept In Oracle Apps
  ------------------------------------
  Oracle's Multi Org Structure has the following top-to-bottom hierarchy
  Business Groups
  Legal Entity
  Operating Unit
  Inventory Org
  
  The concept can be understood with the below example
  
• Lets think of a Global Service company ABC having offices in India and China.
• ABC has implemented Oracle Apps in a single instance (which means one database for both India and China operations).
• Lets say the company has the following requirement
• All the Service Requests created in India should not be visible for an agent who is in China office and the Service Requests created in China should not be visible for an agent who is in India.Basically there is one table(cs_incidents_all_b) which holds the Service requests created in both china and India.
  
  Lets say that there are two SRs resords in the table
• SR 1- India
• SR 2- China
• Also there are say two responsibilities
  India Resp - Users in India are assigned this responsibility
  China resp - Users in China are assigned this responsibility
• To the Indian users, In the Servcie Request screen they should be able to see only Service Requests created for India
• This could very well be establised without any hard coding in the screen
  Define two organizations
  "India Operations"
  and "China Operations"
• Then map the responsibility

"India Resp" to "India Operations"and

"China resp" to "China Operations"

• Set profile option MO : Operating unit to "India Operations" for "India Resp"
  while creating a SR ,system will do the following
  Insert into cs_incidents_all_b (.........,fnd_profile.value('org_id'))
  So in a Multi Org Environment each muti_or table ends with _all and has a coumn called org_idFor each _all table , Oracle provides a correspondong view without _all.
  
  To summarise think of these as below:-
  1. Inventory:- Each of your physical warehouse
  2. Operating Unit :- Think of this units within different taxation rules, accounting rules etc
  3. Business Group :- Think of it, Mittal Steel and Arcelor have merged. If you were to integrate their systems,
  you will have two different business groups.
  4. Mittal Steel UK and Arcelor steel UK
  will both belong to same Legal Entity
  
  Some Queries
  --------------------
  To get the Complete list of classifications run below SQL
  -------------------------------------------------------------------------------
  
  SELECT hl.meaning,hl.lookup_code
  FROM hr_lookups hl
  WHERE hl.lookup_type = 'ORG_CLASS'
  AND hl.enabled_flag = 'Y'
  AND trunc(SYSDATE) BETWEEN nvl(hl.start_date_active,trunc(SYSDATE))
  AND nvl(hl.end_date_active,trunc(SYSDATE))
  ORDER BY meaning

Stmt to get all the inv orgs attached to a ou
-----------------------------------------------------------
select organization_code,operating_unit from org_organization_definitions

Stmt to get all the operating units
---------------------------------------------
select organization_id, namefrom hr_operating_units order by organization_id;