「誤用客供料」:修訂間差異
| (未顯示同一使用者於中間所作的 1 次修訂) | |||
| 第2行: | 第2行: | ||
<SQL> | <SQL> | ||
SELECT X.*,MA016,MA002 FROM (SELECT TA001,TA002,TA006,TA034,TA035,TB003 ,TC004,TB004 AS 應領用,TB005 AS 已領用,TA011 AS 製令狀態 FROM MOCTB | 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> | </SQL> | ||
==全BOM是否有誤用客供料== | ==全BOM是否有誤用客供料== | ||
<SQL> | <SQL> | ||
SELECT MD001,MB002,MB003,MD002,MD003,SUBSTRING(MB002,1,4)AS TC003,MA002,MV002,SUBSTRING(MD003,2,4) AS GG FROM BOMMD JOIN INVMB ON MB001=MD001 | 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 COPMA ON MA001=SUBSTRING(MB002,1,4) | ||
LEFT JOIN CMSMV ON MV001=MA016 | 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) | WHERE MD003 LIKE '60%' AND MB031='' AND SUBSTRING(MB002,1,4)<>SUBSTRING(MD003,2,4) | ||
ORDER BY MV002 | ORDER BY MV002 | ||
</SQL> | </SQL> | ||
於 2017年3月10日 (五) 15:42 的最新修訂
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>