集货时缺少库存

集货发现库存没有，是拣选时，库存发现在SFWL里面

SELECT A.STANDUNITNUM, A.*,A.rowid FROM STOCKGOODSTBL A WHERE  A.Goodsareaid='BUFFERAREA' 
AND A.OWNERID='SFWL'
AND A.GOODSID LIKE '1%'
AND A.COMPANYID  = '-' 
AND (A.BIGUNITNUM>0 OR A.STANDUNITNUM >0 )  ; --异常库存


SELECT A.STANDUNITNUM, A.*,A.rowid FROM STOCKGOODSTBL A WHERE  
A.Goodsareaid='BUFFERAREA' 
AND (A.BIGUNITNUM>0 OR A.STANDUNITNUM >0 )
AND A.GOODSID IN (
'1110408721',
'1110714579',
'1110566516'
)
ORDER BY A.GOODSID ASC,A.OWNERID DESC; 


 SELECT A.A.GOODSID FROM STOCKGOODSTBL A WHERE  A.GOODSID IN (
'1110408721',
'1110770065'
) AND (A.BIGUNITNUM=0 AND  A.STANDUNITNUM =0 )  ;