SELECT hou.organization_id ou_org_id, --org_id
hou.name ou_name,
--ou名称
ood.organization_id org_org_id,
--库存组织id
ood.organization_code org_org_code,
--库存组织代码
msi.secondary_inventory_name,
--子库存名称
msi.description
--子库存描述
FROM
hr_organization_information hoi,
--组织分类表
hr_operating_units hou,
--ou视图
org_organization_definitions ood,
--库存组织定义视图
mtl_secondary_inventories msi
--子库存信息表
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