Oracle行转列，并同时递归向上汇总

SELECT 
ACCOUNTCODEID, PARENTCODEID, COMPANYID, BUDGETYEAR, PLANMAINID, PLANMAINCODE, 
SUM(THISADJUSTMENT1) AS THISADJUSTMENT1,SUM(THISADJUSTMENT2) AS THISADJUSTMENT2,SUM(THISADJUSTMENT3) AS THISADJUSTMENT3,SUM(THISADJUSTMENT4) AS THISADJUSTMENT4,SUM(THISADJUSTMENT5) AS THISADJUSTMENT5,SUM(THISADJUSTMENT6) AS THISADJUSTMENT6,
SUM(THISADJUSTMENT7) AS THISADJUSTMENT7,SUM(THISADJUSTMENT8) AS THISADJUSTMENT8,SUM(THISADJUSTMENT9) AS THISADJUSTMENT9,SUM(THISADJUSTMENT10) AS THISADJUSTMENT10,SUM(THISADJUSTMENT11) AS THISADJUSTMENT11,SUM(THISADJUSTMENT12) AS THISADJUSTMENT12,
SUM(THISADJUSTMENTALL) AS THISADJUSTMENTALL FROM (
SELECT CONNECT_BY_ROOT ACCOUNTCODEID ACCOUNTCODEID,CONNECT_BY_ROOT PARENTCODEID PARENTCODEID,
CONNECT_BY_ROOT COMPANYID COMPANYID,CONNECT_BY_ROOT BUDGETYEAR BUDGETYEAR,
CONNECT_BY_ROOT PLANMAINID PLANMAINID,
CONNECT_BY_ROOT PLANMAINCODE PLANMAINCODE,
THISADJUSTMENT1,THISADJUSTMENT2,THISADJUSTMENT3,THISADJUSTMENT4,THISADJUSTMENT5,THISADJUSTMENT6,
THISADJUSTMENT7,THISADJUSTMENT8,THISADJUSTMENT9,THISADJUSTMENT10,THISADJUSTMENT11,THISADJUSTMENT12,
THISADJUSTMENTALL
FROM (
SELECT DISTINCT ACC.ACCOUNTCODEID, ACC.PARENTCODEID, OCC.COMPANYID, OCC.BUDGETYEAR, OCC.PLANMAINID,OCC.PLANMAINCODE, 
OCC.THISADJUSTMENT1,OCC.THISADJUSTMENT2,OCC.THISADJUSTMENT3,OCC.THISADJUSTMENT4,OCC.THISADJUSTMENT5,OCC.THISADJUSTMENT6,
OCC.THISADJUSTMENT7,OCC.THISADJUSTMENT8,OCC.THISADJUSTMENT9,OCC.THISADJUSTMENT10,OCC.THISADJUSTMENT11,OCC.THISADJUSTMENT12,
OCC.THISADJUSTMENTALL FROM FM_ACCOUNTCODE ACC 
LEFT JOIN (
SELECT COMPANYID, BUDGETYEAR, ACCOUNTCODEID, ACCOUNTCODE, PLANMAINID, PLANMAINCODE,
THISADJUSTMENT1,THISADJUSTMENT2,THISADJUSTMENT3,THISADJUSTMENT4,THISADJUSTMENT5,THISADJUSTMENT6,
THISADJUSTMENT7,THISADJUSTMENT8,THISADJUSTMENT9,THISADJUSTMENT10,THISADJUSTMENT11,THISADJUSTMENT12,
nvl(THISADJUSTMENT1,0)+nvl(THISADJUSTMENT2,0)+nvl(THISADJUSTMENT3,0)+nvl(THISADJUSTMENT4,0)+nvl(THISADJUSTMENT5,0)+nvl(THISADJUSTMENT6,0)
+nvl(THISADJUSTMENT7,0)+nvl(THISADJUSTMENT8,0)+nvl(THISADJUSTMENT9,0)+nvl(THISADJUSTMENT10,0)+nvl(THISADJUSTMENT11,0)+nvl(THISADJUSTMENT12,0) AS THISADJUSTMENTALL
 FROM (
SELECT COMPANYID, DEPTCODE, BUDGETYEAR, ACCOUNTCODEID, ACCOUNTCODE, PLANMAINID, PLANMAINCODE
,sum(case when OCCUPYMONTH = '1'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT1 
,sum(case when OCCUPYMONTH = '2'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT2
,sum(case when OCCUPYMONTH = '3'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT3 
,sum(case when OCCUPYMONTH = '4'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT4 
,sum(case when OCCUPYMONTH = '5'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT5 
,sum(case when OCCUPYMONTH = '6'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT6 
,sum(case when OCCUPYMONTH = '7'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT7 
,sum(case when OCCUPYMONTH = '8'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT8 
,sum(case when OCCUPYMONTH = '9'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT9 
,sum(case when OCCUPYMONTH = '10'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT10 
,sum(case when OCCUPYMONTH = '11'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT11 
,sum(case when OCCUPYMONTH = '12'  then nvl(NOCCUPYBUDGET,0) else 0 end) THISADJUSTMENT12 
 FROM FM_BUDGETOCCUPY WHERE COMPANYID=6209 AND BUDGETYEAR=2020 AND RECORDSTATUS<>'INACTIVE'
 GROUP BY COMPANYID, BUDGETYEAR, ACCOUNTCODEID, ACCOUNTCODE, PLANMAINID, PLANMAINCODE
 )
) OCC ON OCC.ACCOUNTCODEID = ACC.ACCOUNTCODEID
START WITH ACC.ACCOUNTCODEID = OCC.ACCOUNTCODEID
CONNECT BY PRIOR  ACC.PARENTCODEID = ACC.ACCOUNTCODEID
ORDER BY ACC.FIRSTORDER, ACC.SECONDORDER
) A
CONNECT BY PRIOR ACCOUNTCODEID = PARENTCODEID
) GROUP BY ACCOUNTCODEID, PARENTCODEID, COMPANYID, BUDGETYEAR, PLANMAINID, PLANMAINCODE