OU、庫存組織與子庫存

   這三者應該是EBS中經常會造成混亂的吧，可以通過一句SQL來理清其之間的關係：
   SELECT hou.organization_id ou_org_id,
       hou.NAME ou_name,
       ood.organization_id org_org_id,
       ood.organization_code org_org_code,
       msi.secondary_inventory_name,
       msi.description
  FROM hr_organization_information  hoi,
       hr_organization_units        hou,
       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