誤用客供料
OKUMA誤用客供料製令
<SQL> SELECT X.*,MA016,MA002 FROM (SELECT TA001,TA002,TA006,TA034,TA035,TB003 ,TC004,TB004 AS 應領用,TB005 AS 已領用,TA011 AS 製令狀態 FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 JOIN v_COPTCD ON TA001='5102' AND TA002=TD054 WHERE TB018='Y' AND TA011<>'y' AND TD021='Y' )X JOIN COPMA ON MA001=TC004 WHERE TC004='197B' AND TB003 LIKE '601970%' </SQL>
全BOM是否有誤用客供料
<SQL> SELECT RTRIM(MD001) AS MD001,MB002,MB003,MD002,MD003,MB2,MB3,SUBSTRING(MB002,1,4)AS TC003,MA002,MV002, SUBSTRING(MD003,2,4) AS GG FROM BOMMD JOIN INVMB ON MB001=MD001 LEFT JOIN COPMA ON MA001=SUBSTRING(MB002,1,4) LEFT JOIN CMSMV ON MV001=MA016 LEFT JOIN (SELECT MB001 AS MB1,MB002 AS MB2,MB003 AS MB3 FROM INVMB)X ON MD003=MB1 WHERE MD003 LIKE '60%' AND MB031= AND SUBSTRING(MB002,1,4)<>SUBSTRING(MD003,2,4) ORDER BY MV002 </SQL>