WITH 最近三年SO型号
AS
(
SELECT DISTINCT oeb04 FROM oeb_file
LEFT JOIN ima_file ON oeb04=ima01
WHERE oeb15>get_forward_date(-365*3) AND ima08<>'P' AND oeb04 NOT LIKE 'A%'
),
BOM(fg,bmb01,bmb03,bmb06)
AS
(
SELECT bmb01 fg,bmb01,bmb03,bmb06
FROM bmb_file WHERE bmb01 IN (SELECT oeb04 FROM 最近三年SO型号) AND bmb05 IS NULL
UNION ALL
SELECT t1.fg,t2.bmb01,t2.bmb03,t1.bmb06*t2.bmb06 bmb06
FROM BOM t1 INNER JOIN bmb_file t2 ON t1.bmb03=t2.bmb01 AND t2.bmb05 IS NULL
)
SELECT fg,bmb03 mtl,SUM(bmb06) qty FROM BOM
LEFT JOIN ima_file ON bmb03=ima01
WHERE ima08='P' AND fg NOT LIKE 'A%'
GROUP BY fg,bmb03
ORDER BY fg,bmb03
SQL 批量开BOM 算用量
最新推荐文章于 2023-04-22 09:17:12 发布