「5101製令未完工」:修訂間差異
新頁面: ==已生產未領料== <SQL> SELECT TA001,TA002,TA006,TA015,TA017,TA013,TA011,TB004,TB005,TB003,MB002 FROM MOCTA JOIN MOCTB ON TB001=TA001 AND TB002=TA002 JOIN INVMB ON TB003=MB001 WH... |
|||
| 第7行: | 第7行: | ||
AND TB005=0 AND TB003 LIKE '20%' | AND TB005=0 AND TB003 LIKE '20%' | ||
ORDER BY TA002 | ORDER BY TA002 | ||
</SQL> | |||
==已生產達10%誤差量未完工製令== | |||
<SQL> | |||
SELECT TA001,RTRIM(TA002) TA002,TA006,TA034,TA011,CAST(TA015 as float ) AS 預計產量, | |||
CAST(TA017 as float) AS 已生產量,CAST((TA017-TA015)*(-1)as float) AS 未生數量, | |||
abs((TA017-TA015))/TA017*100 as 生產差比 | |||
FROM MOCTA | |||
WHERE (TA001='5101') AND TA011<='3' AND TA017>0 AND TA013='Y' AND abs((TA017-TA015))/TA017*100 <10 | |||
</SQL> | |||
==已生產未完工製令== | |||
<SQL> | |||
SELECT TA001,RTRIM(TA002) TA002,TA006,TA034,TA011,CAST(TA015 as float ) AS 預計產量, | |||
CAST(TA017 as float) AS 已生產量,CAST((TA017-TA015)*(-1)as float) AS 未生數量 | |||
FROM MOCTA | |||
WHERE (TA001='5101') AND TA011<='3' AND TA017>0 AND TA013='Y' | |||
</SQL> | </SQL> | ||
於 2018年7月16日 (一) 10:17 的最新修訂
已生產未領料
<SQL> SELECT TA001,TA002,TA006,TA015,TA017,TA013,TA011,TB004,TB005,TB003,MB002 FROM MOCTA JOIN MOCTB ON TB001=TA001 AND TB002=TA002 JOIN INVMB ON TB003=MB001 WHERE TA013='Y' AND TA001='5101' AND TA011<='3' AND TA017>0 AND TB005=0 AND TB003 LIKE '20%' ORDER BY TA002 </SQL>
已生產達10%誤差量未完工製令
<SQL> SELECT TA001,RTRIM(TA002) TA002,TA006,TA034,TA011,CAST(TA015 as float ) AS 預計產量, CAST(TA017 as float) AS 已生產量,CAST((TA017-TA015)*(-1)as float) AS 未生數量, abs((TA017-TA015))/TA017*100 as 生產差比 FROM MOCTA WHERE (TA001='5101') AND TA011<='3' AND TA017>0 AND TA013='Y' AND abs((TA017-TA015))/TA017*100 <10 </SQL>
已生產未完工製令
<SQL> SELECT TA001,RTRIM(TA002) TA002,TA006,TA034,TA011,CAST(TA015 as float ) AS 預計產量, CAST(TA017 as float) AS 已生產量,CAST((TA017-TA015)*(-1)as float) AS 未生數量 FROM MOCTA WHERE (TA001='5101') AND TA011<='3' AND TA017>0 AND TA013='Y' </SQL>