OU 库存组织和子库存关系
SELECT http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id ou_org_id, --org_id
http://www.doczj.com/doc/ef3cef3501f69e314332947a.html ou_name, --ou名称
http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id org_org_id, --库存组织id
http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_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 http://www.doczj.com/doc/ef3cef3501f69e314332947a.html_information1 = 'OPERATING_UNIT'
AND http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id = http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id
AND ood.operating_unit = http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id
AND http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id = http://www.doczj.com/doc/ef3cef3501f69e314332947a.htmlanization_id