| | |
|---|
| | | FROM
|
|---|
| | | (
|
|---|
| | | SELECT
|
|---|
| | | mws.id,
|
|---|
| | | mws.matnr,
|
|---|
| | | mws.order_no,
|
|---|
| | | mws.order_id,
|
|---|
| | | SUM( mws.anfme ) anfme,
|
|---|
| | | mws.wave_no,
|
|---|
| | | SUM( mws.work_qty ) work_qty,
|
|---|
| | | mws.batch,
|
|---|
| | | mws.site_no,
|
|---|
| | | mws.task_detl_id
|
|---|
| | | mws.id,
|
|---|
| | | 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,
|
|---|
| | | mws.batch,
|
|---|
| | | mws.site_no,
|
|---|
| | | mws.task_detl_id
|
|---|
| | | FROM
|
|---|
| | | man_wave_seed mws
|
|---|
| | | 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 != ''">
|
|---|
