Find Organizations

SELECT ood.operating_unit,

         hou.NAME,

         ood.organization_id,

         ood.organization_name,

         (SELECT organization_code

            FROM mtl_parameters mp

           WHERE mp.organization_id = ood.organization_id)

            inventory_org_code

    FROM hr_operating_units hou, org_organization_definitions ood

   WHERE hou.organization_id = ood.operating_unit

ORDER BY ood.operating_unit, ood.organization_id;