「電線看板設計」:修訂間差異
| 第11行: | 第11行: | ||
==vF_SFCTA(含實際完工日)== | ==vF_SFCTA(含實際完工日)== | ||
<SQL> | <SQL> | ||
SELECT TA001,TA002,TA006,RIGHT(MAX(WM04),6) WM04,RIGHT(MAX(FWM04),6) FWM04, | SELECT TA001,TA002,TA011,TA006,TA034,TA035,TA015,TA017,RIGHT(MAX(WM04),6) WM04,RIGHT(MAX(FWM04),6) FWM04, | ||
RIGHT(MAX(WM05),6) WM05,RIGHT(MAX(FWM05),6) FWM05,RIGHT(MAX(WM06),6) WM06, | RIGHT(MAX(WM05),6) WM05,RIGHT(MAX(FWM05),6) FWM05,RIGHT(MAX(WM06),6) WM06, | ||
RIGHT(MAX(FWM06),6) FWM06,RIGHT(MAX(WM07),6) WM07,RIGHT(MAX(FWM07),6) FWM07, | RIGHT(MAX(FWM06),6) FWM06,RIGHT(MAX(WM07),6) WM07,RIGHT(MAX(FWM07),6) FWM07, | ||
| 第22行: | 第22行: | ||
FROM | FROM | ||
(SELECT TA001,TA002,TA006,WM04,FWM04,WM05,FWM05,WM06,FWM06,WM07,FWM07,WM08,FWM08,WM09,FWM09,WM10,FWM10, | (SELECT TA001,TA002,TA006,WM04,FWM04,WM05,FWM05,WM06,FWM06,WM07,FWM07,WM08,FWM08,WM09,FWM09,WM10,FWM10, | ||
WM11,FWM11,WM12,FWM12,WM13,FWM13,WM14,FWM14,WM15,FWM15,TA029,TA034,TA035,TA015,TA013 FROM | WM11,FWM11,WM12,FWM12,WM13,FWM13,WM14,FWM14,WM15,FWM15,TA029,TA034,TA035,TA015,TA013,TA017,TA011 FROM | ||
(select SX.TA001,SX.TA002,MX.TA006,SX.TA004,SX.TA009,SX.TA013,MX.TA029,MX.TA034,MX.TA035,MX.TA015,SX.FTA004,SX.TA031 from | (select SX.TA001,SX.TA002,MX.TA006,SX.TA004,SX.TA009,SX.TA013,MX.TA029,MX.TA034,MX.TA035,MX.TA015,MX.TA017,SX.FTA004,SX.TA031,MX.TA011 from | ||
(SELECT *,'F'+TA004 AS FTA004 FROM SFCTA) SX | (SELECT *,'F'+TA004 AS FTA004 FROM SFCTA) SX | ||
JOIN MOCTA MX ON SX.TA001=MX.TA001 AND SX.TA002=MX.TA002 )X | JOIN MOCTA MX ON SX.TA001=MX.TA001 AND SX.TA002=MX.TA002 )X | ||
| 第35行: | 第35行: | ||
) AS PivotTable2 | ) AS PivotTable2 | ||
WHERE TA001='5101')Y | WHERE TA001='5101')Y | ||
GROUP BY TA001,TA002,TA006 | GROUP BY TA001,TA002,TA006,TA029,TA034,TA035,TA015,TA017,TA011 | ||
</SQL> | </SQL> | ||
於 2016年5月6日 (五) 13:12 的最新修訂
vP_SFCTA
<SQL> SELECT TA001,TA002,TA006,WM04,WM05,WM06,WM07,WM08,WM09,WM10,WM11,WM12,WM13,WM14,WM15,TA029,TA034,TA035,TA015 FROM (select SX.TA001,SX.TA002,MX.TA006,SX.TA004,SX.TA009,SX.TA013,MX.TA029,MX.TA034,MX.TA035,MX.TA015 from SFCTA SX JOIN MOCTA MX ON SX.TA001=MX.TA001 AND SX.TA002=MX.TA002 )X PIVOT (
MAX(TA009) FOR TA004 IN (WM04,WM05,WM06,WM07,WM08,WM09,WM10,WM11,WM12,WM13,WM14,WM15)
) AS PivotTable WHERE TA001='5101' </SQL>
vF_SFCTA(含實際完工日)
<SQL> SELECT TA001,TA002,TA011,TA006,TA034,TA035,TA015,TA017,RIGHT(MAX(WM04),6) WM04,RIGHT(MAX(FWM04),6) FWM04, RIGHT(MAX(WM05),6) WM05,RIGHT(MAX(FWM05),6) FWM05,RIGHT(MAX(WM06),6) WM06, RIGHT(MAX(FWM06),6) FWM06,RIGHT(MAX(WM07),6) WM07,RIGHT(MAX(FWM07),6) FWM07, RIGHT(MAX(WM08),6) WM08,RIGHT(MAX(FWM08),6) FWM08,RIGHT(MAX(WM09),6) WM09, RIGHT(MAX(FWM09),6) FWM09,RIGHT(MAX(WM10),6) WM10,RIGHT(MAX(FWM10),6) FWM10, RIGHT(MAX(WM11),6) WM11,RIGHT(MAX(FWM11),6) FWM11,RIGHT(MAX(WM12),6) WM12, RIGHT(MAX(FWM12),6) FWM12,RIGHT(MAX(WM13),6) WM13,RIGHT(MAX(FWM13),6) FWM13, RIGHT(MAX(WM14),6) WM14,RIGHT(MAX(FWM14),6) FWM14,RIGHT(MAX(WM15),6) WM15, RIGHT(MAX(FWM15),6) FWM15 FROM (SELECT TA001,TA002,TA006,WM04,FWM04,WM05,FWM05,WM06,FWM06,WM07,FWM07,WM08,FWM08,WM09,FWM09,WM10,FWM10, WM11,FWM11,WM12,FWM12,WM13,FWM13,WM14,FWM14,WM15,FWM15,TA029,TA034,TA035,TA015,TA013,TA017,TA011 FROM (select SX.TA001,SX.TA002,MX.TA006,SX.TA004,SX.TA009,SX.TA013,MX.TA029,MX.TA034,MX.TA035,MX.TA015,MX.TA017,SX.FTA004,SX.TA031,MX.TA011 from (SELECT *,'F'+TA004 AS FTA004 FROM SFCTA) SX JOIN MOCTA MX ON SX.TA001=MX.TA001 AND SX.TA002=MX.TA002 )X PIVOT (
MAX(TA009) FOR TA004 IN (WM04,WM05,WM06,WM07,WM08,WM09,WM10,WM11,WM12,WM13,WM14,WM15)
) AS PivotTable1 PIVOT (
MAX(TA031) FOR FTA004 IN (FWM04,FWM05,FWM06,FWM07,FWM08,FWM09,FWM10,FWM11,FWM12,FWM13,FWM14,FWM15)
) AS PivotTable2 WHERE TA001='5101')Y GROUP BY TA001,TA002,TA006,TA029,TA034,TA035,TA015,TA017,TA011 </SQL>
製程代號
- WM01 伸線
- WM02 TA線 鍍錫+集合
- WM03 AC線 集合+燒鈍
- WM04 絕緣 絕緣押出
- WM05 打點 打點識別
- WM06 螺旋 螺旋印條
- WM07 對撚
- WM08 1Y 撚線1Y
- WM09 2Y 撚線2Y
- WM10 3Y 撚線3Y
- WM11 4Y 撚線4Y
- WM12 SB 編織隔離
- WM13 SS 纏繞隔離
- WM14 外被 外被押出
- WM15 卷取包裝