VlabON 홈으로 가기

OPRTN_ELMT_SEQ
           , CASE WHEN COFCS_YN IN ('C', 'W') THEN 'Y' ELSE 'N' END AS CNCLT_ABLE_YN        /* 수강 취소 가능 여부 */
           , CONCAT(CT.MBR_SEQ, ':', CT.CRS_OPRTN_SEQ , '/') AS ORDER_PATH
        FROM CRS_TKGLECT CT
             JOIN CRS_OPRTN CO 
                  ON CO.CRS_MAST_SEQ = CT.CRS_MAST_SEQ
                  AND CO.CRS_OPRTN_SEQ = CT.CRS_OPRTN_SEQ
             JOIN CRS_MAST CM 
                  ON CM.CRS_MAST_SEQ = CO.CRS_MAST_SEQ
             LEFT JOIN CRS_OPRTN_ELMT COE
                  ON COE.CRS_OPRTN_SEQ = CO.CRS_OPRTN_SEQ 
                  AND COE.REF_TP_CD = '05' AND COE.USE_YN = 'Y' AND COE.DEL_YN = 'N'
             LEFT JOIN CRS_TKGLECT_ELMT CTE
                  ON CTE.CRS_OP