加工製程改善計劃
製程停滯製令金額
<SQL> SELECT TA002,UDF06,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527 ,(SELECT CASE WHEN UDF06=1 THEN CONVERT(VARCHAR,GETDATE(),111) WHEN UDF06=2 AND CHARINDEX('外發', TA510)>0 THEN
WHEN UDF06=2 AND TA521= THEN CONVERT(VARCHAR,GETDATE(),111)
WHEN UDF06=2 AND TA521<> THEN TA521
WHEN UDF06=3 AND TA523= THEN TA521
WHEN UDF06=3 AND TA523<> THEN TA523
WHEN UDF06=4 AND TA025= THEN TA523
WHEN UDF06=4 AND TA025<> THEN TA525
END)ST, (SELECT CASE WHEN UDF06=1 AND TA520 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111)
WHEN UDF06=1 THEN TA520
WHEN UDF06=2 AND CHARINDEX('外發', TA510)>0 THEN
WHEN UDF06=2 AND TA522 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111)
WHEN UDF06=2 THEN TA522
WHEN UDF06=3 AND TA524 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111)
WHEN UDF06=3 THEN TA524
WHEN UDF06=4 AND TA526 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111)
WHEN UDF06=4 AND TA026<> THEN TA525
END)ED
FROM MOCTA WHERE TA013='Y' AND TA011<>'Y' AND TA011<>'y' AND TA001='5102' AND UDF06 BETWEEN 1 AND 4 </SQL>