「電線看板設計」:修訂間差異
| 第9行: | 第9行: | ||
WHERE TA001='5101' | WHERE TA001='5101' | ||
</SQL> | </SQL> | ||
==vF_SFCTA== | |||
<SQL> | |||
SELECT TA001,TA002,TA006,MAX(WM04)AS WM04,MAX(FWM04) FWM04,MAX(WM05) WM05,MAX(FWM05) FWM05,MAX(WM06) WM06, | |||
MAX(FWM06) FWM06,MAX(WM07) WM07,MAX(FWM07) FWM07,MAX(WM08) WM08,MAX(FWM08) FWM08,MAX(WM09) WM09,MAX(FWM09) FWM09,MAX(WM10) WM10,MAX(FWM10) FWM10, | |||
MAX(WM11) WM11,MAX(FWM11) FWM11,MAX(WM12) WM12,MAX(FWM12) FWM12,MAX(WM13) WM13,MAX(FWM13) FWM13,MAX(WM14) WM14,MAX(FWM14) FWM14,MAX(WM15) WM15,MAX(FWM15) 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 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 *,'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 | |||
</SQL> | |||
==製程代號== | ==製程代號== | ||
*WM01 伸線 | *WM01 伸線 | ||
於 2016年5月6日 (五) 11:06 的修訂
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,TA006,MAX(WM04)AS WM04,MAX(FWM04) FWM04,MAX(WM05) WM05,MAX(FWM05) FWM05,MAX(WM06) WM06, MAX(FWM06) FWM06,MAX(WM07) WM07,MAX(FWM07) FWM07,MAX(WM08) WM08,MAX(FWM08) FWM08,MAX(WM09) WM09,MAX(FWM09) FWM09,MAX(WM10) WM10,MAX(FWM10) FWM10, MAX(WM11) WM11,MAX(FWM11) FWM11,MAX(WM12) WM12,MAX(FWM12) FWM12,MAX(WM13) WM13,MAX(FWM13) FWM13,MAX(WM14) WM14,MAX(FWM14) FWM14,MAX(WM15) WM15,MAX(FWM15) 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 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 *,'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 </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 外被 外被押出