Find the Org and Organization mappings

 

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