檢視 電線使用明細 的原始碼
←
電線使用明細
跳至導覽
跳至搜尋
由於以下原因,您無權編輯此頁面:
您請求的操作只有這個群組的使用者能使用:
使用者
您可以檢視並複製此頁面的原始碼。
==查詢程式碼== <sql> SELECT * FROM ( SELECT XX.*,ROUND((A1+A2+A3+A13+A14+A15)/6,0) AS SAVG,SMC007,X.UDF06 AS PRESA,ROUND(UNUSE,0)AS UNUSE,ROUND((SMC007-X.UDF06-UNUSE),0) AS PREALL,QTA, ROUND((SMC007-X.UDF06-UNUSE-(SELECT CASE WHEN QTA<0 THEN QTA ELSE 0 END)),0) AS FAMOUNT, XX.MB001 AS TA006 FROM ( SELECT MB001, ROUND([202012],0) AS A15,ROUND([202101],0) AS A14,ROUND([202102],0) AS A13,[202103] AS A3,[202104] AS A2,[202105] AS A1,[202106] AS A0 FROM ( SELECT RTRIM(MB001) MB001,THEOUT,THEMONTH FROM CABLEINOUT WHERE (THEMONTH BETWEEN '202103' AND '202106' OR THEMONTH BETWEEN '202012' AND '202102' ) AND MB001<>'TSS-089-3C大同' ) AS p PIVOT ( SUM(THEOUT) FOR THEMONTH IN ([202012],[202101],[202102],[202103], [202104],[202105],[202106]) ) AS pt1 ) XX LEFT JOIN v_INVMC01 ON MC001=MB001 JOIN INVMB X ON X.MB001=XX.MB001 LEFT JOIN (SELECT TA006,(SUM(TA017)-SUM(TA015))AS QTA FROM MOCTA WHERE TA011<>'Y' AND TA011<>'y' AND TA013<>'V' GROUP BY TA006)Z ON XX.MB001=TA006 LEFT JOIN (SELECT TB003,SUM(TB004-TB005)AS UNUSE FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 WHERE TB018='Y' AND TA011<>'Y' AND TA011<>'y' GROUP BY TB003)ZZ ON XX.MB001=TB003 )YY </sql>
返回到「
電線使用明細
」。
導覽選單
個人工具
建立帳號
登入
命名空間
頁面
討論
臺灣正體
視圖
閱讀
檢視原始碼
檢視歷史
更多
搜尋
導覽
首頁
近期變更
隨機頁面
MediaWiki說明
工具
連結至此的頁面
相關變更
特殊頁面
頁面資訊