lmis库存预占修改

在lmis.jc_spzl里查找spid

修改

select * from lmis.jc_spzl  t where t.shangp_no in(‘B201363‘,‘A103211‘)

select t.rowid,t.* from kc_spphhw t   WHERE shangp_id in (‘SPH00061803‘,‘SPH00063737‘)

select t.rowid,t.* from kc_spkbkc t   WHERE shangp_id in (‘SPH00061803‘,‘SPH00063737‘)

select t.rowid,t.* from kc_spzkc t   WHERE shangp_id in (‘SPH00061803‘,‘SPH00063737‘)

中rukyz_num的数量换到num中即可

lmis库存预占修改

原文：http://bks2015.blog.51cto.com/9847303/1699582