更新货位的子库存

 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='张三,'