「誤用客供料」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==OKUMA誤用客供料製令== <SQL> SELECT X.*,MA016,MA002 FROM (SELECT TA001,TA002,TA006,TA034,TA035,TB003 ,TC004,TB004 AS 應領用,TB005 AS 已領用,TA011 AS 製令狀態 FROM MOC...
 
Root​(留言 | 貢獻)
 
(未顯示同一使用者於中間所作的 2 次修訂)
第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 MOCTA ON TA001=TB001 AND TA002=TB002
JOIN v_COPTCD ON TA001='5102' AND TA002=TD054
JOIN v_COPTCD ON TA001='5102' AND TA002=TD054
WHERE TB018='Y'  AND TA011<>'y' AND TD021='Y'
WHERE TB018='Y'  AND TA011<>'y' AND TD021='Y'
)X
)X
JOIN COPMA ON MA001=TC004 WHERE TC004='197B' AND TB003 LIKE '601970%'
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>
</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>