moqd.subinventory_code
from inv.mtl_onhand_quantities_detail moqd,inv.mtl_system_items_b msi
where msi.inventory_item_id=moqd.inventory_item_id
and msi.segment1='在此处输入你要查的物料代码'
moqd.subinventory_code
from inv.mtl_onhand_quantities_detail moqd,inv.mtl_system_items_b msi
where msi.inventory_item_id=moqd.inventory_item_id
and msi.segment1='在此处输入你要查的物料代码'
----------------------------------------------------------------------------------------------------------
MSN:[email protected] [/B]
這個好象查不出來吧,查庫存量也須要 sum 吧。