更新货位的子库存

Posted on 2011-12-05 09:11 奥客阅读(151) 评论(0) 编辑收藏举报

select * from inv.mtl_item_locations
where inventory_location_id=9298
and segment1='张三,'

update inv.mtl_item_locations set subinventory_code='LENDING'
where inventory_location_id=9298
and segment1='张三,'