| | |
|---|
| | | on c.order_id = d.order_id |
|---|
| | | # left join mm.finished_goods_inventory as f |
|---|
| | | # on c.order_id = f.order_id and f.order_number = c.order_number |
|---|
| | | left join sd.delivery_detail as dd on dd.order_id = a.order_id and dd.order_number = a.order_number |
|---|
| | | left join (select dd1.order_id,dd1.order_number,sum(dd1.quantity) as quantity from sd.delivery_detail as dd1 |
|---|
| | | where dd1.order_id = #{orderId} |
|---|
| | | group by dd1.order_id,dd1.order_number |
|---|
| | | ) as dd on dd.order_id = a.order_id and dd.order_number = a.order_number |
|---|
| | | left join (SELECT process_id, |
|---|
| | | order_number, |
|---|
| | | technology_number, |
|---|
