提示 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