| service/Warehouse/MesXkyShdManager.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
service/Warehouse/MesXkyShdManager.cs
@@ -68,9 +68,9 @@ D.item_model, A.include_qty, A.po_erp_no, ISNULL(B.OLDQTY,0) AS ysl ISNULL(B.QUANTITY,0) AS ysl FROM TBL_BARCODE_INFORMATION A LEFT JOIN MES_INV_ITEM_BARCODES B ON a.small_barcode = b.ITEM_BARCODE LEFT JOIN MES_XKY_BARCODE_RE B ON a.small_barcode = b.ITEM_BARCODE LEFT JOIN MES_ROH_IN_DATA C ON C.EBELN_K3ID = A.po_line_no LEFT JOIN MES_ITEMS D ON D.item_id = C.item_id WHERE A.delivery_no = @shdh";