주말 잘보내고 계시는지 모르겠습니다..

전 역량부족으로 주말에도 열일하고있는데요.. 너무 어렵습니다.. 도움 부탁 드리겠습니다!

여쭤볼 내용은 구분값에 따라 한열에 쭉 보이고 싶게 하는건데요 잘안되네요...

구분 값은 FLAG 로 각각 PF,PC,DF,DC로 나뉘며 이구분값에 따라 

열구성이 

PF /PF_CNT/_ PF_AMT/ PC/ PC_CNT / PC_AMT / DF/ DF_CNT /DF_AMT/ DC/ DC_CNT/ DC_AMT 순으로 쭉 나와야됩니다..

쿼리는 아래와 같습니다..

SELECT DECODE(FLAG,'PF',A.PRNT_NM) PF
                           , COUNT(DECODE(FLAG,'PF',1)) PF_CNT
                           , SUM(DECODE(FLAG,'PF',B.PAY_ITEM_AMT)) PF_AMT
                           , DECODE(FLAG,'PC',A.PRNT_NM) PC
                           , COUNT(DECODE(FLAG,'PC',1)) PC_CNT
                           , SUM(DECODE(FLAG,'PC',B.PAY_ITEM_AMT)) PC_AMT
                           , DECODE(FLAG,'DF',A.PRNT_NM) DF
                           , COUNT(DECODE(FLAG,'DF',1)) DF_CNT
                           , SUM(DECODE(FLAG,'DF',B.PAY_ITEM_AMT)) DF_AMT
                           , DECODE(FLAG,'DC',A.PRNT_NM) DC
                           , COUNT(DECODE(FLAG,'DC',1)) DC_CNT
                           , SUM(DECODE(FLAG,'DC',B.PAY_ITEM_AMT)) DC_AMT
                           , FLAG
                        FROM (SELECT PAY_ITEM_CD 
                                   , PRNT_NM
                                   , CASE WHEN PAY_ITEM_CD <= 1160 THEN 'PF'
                                          WHEN PAY_ITEM_CD > 1160 AND PAY_ITEM_CD <= 1330 THEN 'PC'
                                          WHEN PAY_ITEM_CD > 1330 AND PAY_ITEM_CD <= 2180 THEN 'DF'
                                          WHEN PAY_ITEM_CD > 2180 AND PAY_ITEM_CD <= 2381 THEN 'DC' END AS FLAG
                                FROM MPB_PAYITEM) A
                           , MPP_PAYITEMPYDTL B
                       WHERE A.PAY_ITEM_CD = B.PAY_ITEM_CD(+)
                         AND PY_YM(+) BETWEEN '201610' AND '201610'
                       GROUP BY
                             A.PAY_ITEM_CD
                           , A.PRNT_NM
                    

결과값은 예상 가시겠지만

PF /PF_CNT/_ PF_AMT/ PC/ PC_CNT / PC_AMT / DF/ DF_CNT /DF_AMT/ DC/ DC_CNT/ DC_AMT

DATA1/DATA1/DATA1/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL

DATA1/DATA1/DATA1/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL

DATA1/DATA1/DATA1/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL

/NULL/NULL/NULL/DATA2/DATA2/DATA2/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL

/NULL/NULL/NULL/DATA2/DATA2/DATA2/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL

/NULL/NULL/NULL/DATA2/DATA2/DATA2/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/DATA3/DATA3/DATA3/NULL/NULL/NULL//NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/DATA3/DATA3/DATA3/NULL/NULL/NULL//NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/DATA3/DATA3/DATA3/NULL/NULL/NULL//NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/DATA4/DATA4/DATA4/NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/DATA4/DATA4/DATA4/NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/DATA4/DATA4/DATA4/NULL/NULL/NULL

/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/DATA5/DATA5/DATA5

/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/DATA5/DATA5/DATA5

/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/NULL/DATA5/DATA5/DATA5

이런식으로 출력됩니다...원하는 결과 셋은

DATA1/DATA1/DATA1/DATA2/DATA2/DATA2/DATA3/DATA3/DATA3/DATA4/DATA4/DATA4/DATA5/DATA5/DATA5/

DATA1/DATA1/DATA1/DATA2/DATA2/DATA2/DATA3/DATA3/DATA3/DATA4/DATA4/DATA4/DATA5/DATA5/DATA5/

DATA1/DATA1/DATA1/DATA2/DATA2/DATA2/DATA3/DATA3/DATA3/DATA4/DATA4/DATA4/DATA5/DATA5/DATA5/

DATA1/DATA1/DATA1/DATA2/DATA2/DATA2/DATA3/DATA3/DATA3/DATA4/DATA4/DATA4/DATA5/DATA5/DATA5/                             .

위와 같은 식으로 나오길 원합니다 ... 감사합니다

아래는 현제 결과값입니다