提示 UDI码对不上,需要查询系统中的UDI
select A.GOODSQTY,A.SAAVAILABLEQTY,A.GOODSID,A.BATCHNO,A.LOTNO,C.UDI,a.goodsstatusid
from cqyyprod.bms_st_qty_lst_V a,
cqyyprod.bms_lot_def b,
cqyyprod.bms_batch_def c,
cqyyprod.bms_st_def d,
cqyyprod.pub_storer e,
cqyyprod.pub_entry f
where a.lotid = b.lotid
and a.batchid = c.batchid
and a.storageid = d.storageid
and d.phystoreid = e.storerid
and d.entryid = f.entryid
-- and e.storerno in ('FB') --仓库编码 万州 FC U
I
-- and f.mdmcode = 'R3' --分公司编码
-- and e.storerno in ('FC') --仓库编码
-- and f.mdmcode = 'UI' --分公司编码*\
and e.storerno in ('MD') --仓库编码
and f.mdmcode = 'UM' --分公司编码
AND a.goodsid='1110390486'
AND b.lotno ='230973'
;
文档更新时间: 2025-04-02 17:06 作者:admin