행열 바꾸기 1,2,3등으로 구분되어진 항목을 열로 변환하기

SELECT
    *
FROM
(
    SELECT
         A.HEAT_NO
        ,B.SEQ
        ,DECODE(B.SEQ,1,A.HMTL_LDL_NO1,2,A.HMTL_LDL_NO2,3,A.HMTL_LDL_NO3) AS HMTL_LDL_NO
        ,DECODE(B.SEQ,1,A.BF_NO1,2,A.BF_NO2,3,A.BF_NO3) AS BF_NO
        ,DECODE(B.SEQ,1,A.BF_IRTAP_TAP_NO1,2,A.BF_IRTAP_TAP_NO2,3,A.BF_IRTAP_TAP_NO3) AS BF_IRTAP_TAP_NO
        ,DECODE(B.SEQ,1,A.TLCSLAG_INCL_HMTL_IRTAP_WT1,2,A.TLCSLAG_INCL_HMTL_IRTAP_WT2,3,A.TLCSLAG_INCL_HMTL_IRTAP_WT3) AS TLCSLAG_INCL_HMTL_IRTAP_WT
    FROM TB_HM_HMTLWR A
        ,(SELECT 1 AS SEQ FROM DUAL UNION ALL
          SELECT 2 AS SEQ FROM DUAL UNION ALL
          SELECT 3 AS SEQ FROM DUAL
         ) B
)
WHERE HMTL_LDL_NO IS NOT NULL
ORDER BY HEAT_NO, SEQ;