Ou, inventory organization and sub-Inventory

Select Hou. organization_id ou_org_id, -- Org_id
Hou. Name ou_name, -- Ou name
Ood. organization_id org_org_id, -- Inventory organization ID
Ood. organization_code org_org_code, -- Inventory OrganizationCode
MSI. secondary_inventory_name, -- Sub-stock name
MSI. Description -- Sub-inventory description
From Hr_organization_information Hoi, -- Organization Category Table
Hr_operating_units Hou, -- Ou View
Org_organization_definitions Ood, -- Inventory Organization definition View
Mtl_secondary_inventories MSI -- Sub-inventory info table
  Where Hoi.org _ information1 =   ' Operating_unit '
And Hoi. organization_id = Hou. organization_id
And Ood. operating_unit = Hoi. organization_id
And Ood. organization_id = MSI. organization_id