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
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