ITPub博客

首页 > Linux操作系统 > Linux操作系统 > update locator

update locator

原创 Linux操作系统 作者:susie0409 时间:2011-01-27 20:23:09 0 删除 编辑

Sometimes, the user found some items have onhand qty, but without locator.

The user provide us the locator, we will do the following update:


--------1 row will be updated------------
update apps.mtl_material_transactions
   set locator_id = 1
    where transaction_id = 12;
       
--------1 row will be updated------------
update apps.rcv_transactions
   set locator_id = 1
where transaction_id = 12;

--------1 row will be updated------------
update apps.mtl_onhand_quantities_detail
   set locator_id = 1
where inventory_item_id = 123
and organization_id = 90;

commit;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15225049/viewspace-686414/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 社交网络(ZT)
请登录后发表评论 登录
全部评论

注册时间:2009-09-30

  • 博文量
    115
  • 访问量
    271171