Find the Org and Organization mappings

If you are given a new oracle apps project to work, the first thing you need to know is the organization structure. So if you have the DB access just run the below query. You can find out the LE-SOB-OU-INVORG mapping.


SELECT
  ood.organization_code Warehouse_code,
  ood.organization_name Warehouse,
  ood.operating_unit OU_ID,
  hou.name OU_Name,
  hle.name Legal_entity,
  hle.set_of_books_id,
  gsob.name SOB
FROM
  org_organization_definitions ood,
  hr_operating_units hou,
  hr_legal_entities hle,
  gl_sets_of_books gsob
WHERE
  ood.operating_unit = hou.organization_id 
AND hou.legal_entity_id = hle.organization_id
AND gsob.set_of_books_id = hle.set_of_books_id