4高供高计计量点接线方式是单相

4高供高计计量点接线方式是单相 4高供高计计量点接线方式是单相.txt我自横刀向天笑，笑完我就去睡觉。 你的手机比话费 还便宜。路漫漫其修远兮，不如我们打的吧。 -- (2.3)高供高计计量点接线方式是单相. -- 1.4.7高供高计 接线方式不能是单相 -- 修改档案:修改接线方式 4284 SELECT DD.DEPT_ID 编号, DD.DEPT_NAME 电业局, COUNT(DISTINCT C.MP_NO) AS 数据量 FROM C_CONS A, ----用户 C_MP C, ----计量点 SA_DEPT D, SA_DEPT DD WHERE C.CONS_ID = A.CONS_ID(+) AND C.ORG_NO LIKE '51%' AND C.MP_ATTR_CODE = '01' ---结算计量点 AND D.DEPT_ID = C.ORG_NO AND length(a.ORG_NO)<='7' AND SUBSTR(D.DEPT_TREE, 12, 5) = DD.DEPT_ID AND A.STATUS_CODE <> 9 -- 去掉销户 AND C.STATUS_CODE not in('04') -- 去掉撤销计量点 AND C.MEAS_MODE = '1' -- 高供高计 AND C.WIRING_MODE = '1' -- 接线方式 GROUP BY DD.DEPT_ID, DD.DEPT_NAME ORDER BY DD.DEPT_ID, DD.DEPT_NAME; SELECT DISTINCT C.CONS_NO AS 用户编号, A.CONS_NAME AS 用户名称, C.MP_NO AS 计量点编号, C.MP_NAME AS 计量点名称, '高供高计' 计量方式, '单相' 接线方式, C.ORG_NO AS 部门编号, D.DEPT_NAME 供电局, DD.DEPT_NAME 电业局 FROM C_CONS A, ----用户 C_MP C, ----计量点 SA_DEPT D, SA_DEPT DD WHERE C.CONS_ID = A.CONS_ID(+) AND C.ORG_NO LIKE '51%' AND C.MP_ATTR_CODE = '01' ---结算计量点 AND D.DEPT_ID = C.ORG_NO AND length(a.ORG_NO)<='7' AND SUBSTR(D.DEPT_TREE, 12, 5) = DD.DEPT_ID AND A.STATUS_CODE <> 9 -- 去掉销户 AND C.STATUS_CODE not in('04') -- 去掉撤销计量点 AND C.MEAS_MODE = '1' -- 高供高计 AND C.WIRING_MODE = '1' -- 接线方式 AND A.ORG_NO LIKE '51%' AND C.ORG_NO LIKE '51%' AND D.DEPT_ID LIKE '51%' ORDER BY DD.DEPT_NAME 销户 SELECT DD.DEPT_ID 编号, DD.DEPT_NAME 电业局, COUNT(DISTINCT C.MP_NO) AS 数据量 FROM C_CONS A, ----用户 C_MP C, ----计量点 SA_DEPT D, SA_DEPT DD WHERE C.CONS_ID = A.CONS_ID(+) AND C.ORG_NO LIKE '51%' AND C.MP_ATTR_CODE = '01' ---结算计量点 AND D.DEPT_ID = C.ORG_NO AND SUBSTR(D.DEPT_TREE, 12, 5) = DD.DEPT_ID AND a.STATUS_CODE = 9 -- 去掉销户 AND length(a.ORG_NO)<='7' AND TO_CHAR(a.CANCEL_DATE, 'YYYYMMDD') >=200911 AND C.STATUS_CODE not in('04') -- 去掉撤销计量点 AND C.MEAS_MODE = '1' -- 高供高计 AND C.WIRING_MODE = '1' -- 接线方式 GROUP BY DD.DEPT_ID, DD.DEPT_NAME ORDER BY DD.DEPT_ID, DD.DEPT_NAME; SELECT DISTINCT C.CONS_NO AS 用户编号, A.CONS_NAME AS 用户名称, C.MP_NO AS 计量点编号, C.MP_NAME AS 计量点名称, '高供高计' 计量方式, '单相' 接线方式, C.ORG_NO AS 部门编号, D.DEPT_NAME 供电局, DD.DEPT_NAME 电业局 FROM C_CONS A, ----用户 C_MP C, ----计量点 SA_DEPT D, SA_DEPT DD WHERE C.CONS_ID = A.CONS_ID(+) AND C.ORG_NO LIKE '51%' AND C.MP_ATTR_CODE = '01' ---结算计量点 AND D.DEPT_ID = C.ORG_NO AND length(a.ORG_NO)<='7' AND SUBSTR(D.DEPT_TREE, 12, 5) = DD.DEPT_ID AND a.STATUS_CODE = 9 -- 去掉销户 AND TO_CHAR(a.CANCEL_DATE, 'YYYYMMDD') >=200911 AND C.STATUS_CODE not in('04') -- 去掉撤销计量点 AND C.MEAS_MODE = '1' -- 高供高计 AND C.WIRING_MODE = '1' -- 接线方式 AND A.ORG_NO LIKE '51%' AND C.ORG_NO LIKE '51%' AND D.DEPT_ID LIKE '51%' ORDER BY DD.DEPT_NAME