WITH t AS
(
SELECT '2017' yy, 'B4' lv, 'E100' cd1, 'B4E100' cd2, 'EE1012' cd3, 798876890 amt FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF1002',  78156789099 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF1003',   3575925128 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF1004',  -8083873295 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF1005', 112622620651 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF1007',     57062635 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF1008',     38041757 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'FF2018',     38041757 FROM dual
UNION ALL SELECT '2017', 'B4', 'E100', 'B4E100', 'KK4017',   3005298778 FROM dual
)
SELECT *
  FROM t
 PIVOT (SUM(amt) FOR cd3 IN ( 'EE1012' EE1012
                            , 'FF1002' FF1002
                            , 'FF1003' FF1003
                            , 'FF1004' FF1004
                            , 'FF1005' FF1005
                            , 'FF1007' FF1007
                            , 'FF1008' FF1008
                            , 'FF2018' FF2018
                            , 'KK4017' KK4017
                            ) )
;