WITH tab AS
(
SELECT '2012-01-01' dt, '고객파급' cusnm, 1 cnt1, 50 tim, 128 cap, 25 usercnt FROM dual
UNION ALL SELECT '2012-06-02', '기타'      , 1, 12, 80,  5 FROM dual
UNION ALL SELECT '2012-06-15', '기타'      , 1, 10,  6,  2 FROM dual
UNION ALL SELECT '2012-09-02', '일반인과실', 1,  5, 18, 16 FROM dual
)
, aaaa AS
(
SELECT 1 cuscd, '기자재' cusnm FROM dual
UNION ALL SELECT 2, '기상악화'   FROM dual
UNION ALL SELECT 3, '외물접촉'   FROM dual
UNION ALL SELECT 4, '일반인과실' FROM dual
UNION ALL SELECT 5, '고객파급'   FROM dual
UNION ALL SELECT 6, '기타'       FROM dual
)
SELECT cusnm
     , DECODE(lv, 1, '건수', 2, '시간합', 3, '전력합', 4, '사용자합') gubun
     , NVL(SUM(DECODE(mm, '01', v)), 0) m01
     , NVL(SUM(DECODE(mm, '02', v)), 0) m02
     , NVL(SUM(DECODE(mm, '03', v)), 0) m03
     , NVL(SUM(DECODE(mm, '04', v)), 0) m04
     , NVL(SUM(DECODE(mm, '05', v)), 0) m05
     , NVL(SUM(DECODE(mm, '06', v)), 0) m06
     , NVL(SUM(DECODE(mm, '07', v)), 0) m07
     , NVL(SUM(DECODE(mm, '08', v)), 0) m08
     , NVL(SUM(DECODE(mm, '09', v)), 0) m09
     , NVL(SUM(DECODE(mm, '10', v)), 0) m10
     , NVL(SUM(DECODE(mm, '11', v)), 0) m11
     , NVL(SUM(DECODE(mm, '12', v)), 0) m12
  FROM (SELECT cuscd, cusnm, lv
             , SUBSTR(dt, 6, 2) mm
             , DECODE(lv, 1, cnt1, 2, tim, 3, cap, 4, usercnt) v
          FROM (SELECT a.cuscd, a.cusnm
                     , b.dt, b.cnt1, b.tim, b.cap, b.usercnt
                  FROM aaaa a
                     , tab b
                 WHERE a.cusnm = b.cusnm(+)
                   AND b.dt(+) LIKE '2012%'
                )
             , (SELECT LEVEL lv FROM dual CONNECT BY LEVEL <= 4)
        )
 GROUP BY cuscd, cusnm, lv
 ORDER BY cuscd, lv
;