| zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
zy-asrs-wms/src/main/resources/mapper/asrs/TaskMapper.xml
@@ -30,6 +30,7 @@ mws.matnr, mws.order_no, mws.order_id, od.anfme AS rev_qty, SUM( mws.anfme ) anfme, mws.wave_no, SUM( mws.work_qty ) work_qty, @@ -38,6 +39,7 @@ mws.task_detl_id FROM man_wave_seed mws INNER JOIN man_order_detl od ON mws.order_detl_id = od.id WHERE task_detl_id IN ( SELECT mtd.id FROM man_task mt INNER JOIN man_task_detl mtd ON mt.id = mtd.task_id <if test="taskNo != null and taskNo != ''">
