SELECT hou.organization_id ou_org_id
,hou.name ou_name --ou名称
,ood.organization_id organization_id --库存组织id
,ood.organization_code organization_code --库存组织代码
,msi.secondary_inventory_name sub_code --子库存名称
,msi.description sub_desc --子库存描述
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 organization_id --库存组织id
,ood.organization_code organization_code --库存组织代码
,msi.secondary_inventory_name sub_code --子库存名称
,msi.description sub_desc --子库存描述
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;