| | |
|---|
| | | production_product_main ppm |
|---|
| | | left join production_product_output ppo on ppo.product_main_id = ppm.id |
|---|
| | | left join product_order po on po.id = ppm.product_order_id |
|---|
| | | left join product_order_plan pop on po.id = pop.product_order_id |
|---|
| | | left join production_plan pp on pop.production_plan_id = pp.id |
|---|
| | | left join product_material_sku pms on pp.product_material_sku_id = pms.id |
|---|
| | | left join product_material_sku pms on po.product_material_sku_id = pms.id |
|---|
| | | left join product_material pm on pm.id = pms.product_id |
|---|
| | | <where> |
|---|
| | | <if test="c.npsNo != null and c.npsNo != ''"> |
|---|
