로그아웃 합니다.
아이디가 로그아웃 됩니다.

뒤로 전체메뉴
SELECT * FROM (SELECT AA.* , ROWNUM AS RNUM FROM (SELECT DISTINCT A.EVENT_NO , NVL(TO_CHAR(A.VST_BEGIN_DE, 'YYYY.MM.DD'), TO_CHAR(A.EVENT_BEGIN_DE, 'YYYY.MM.DD')) AS EVENT_BEGIN_DE , NVL(TO_CHAR(A.VST_END_DE, 'YYYY.MM.DD'), TO_CHAR(A.EVENT_END_DE, 'YYYY.MM.DD')) AS EVENT_END_DE , A.KOREAN_EVENT_NM , SUBSTR(c.FCLTY_MANAGE_NO,1,1) FCLTY_MANAGE_NO FROM KTEX.TB_EVENT_INFO AS A , KTEX.TB_RENT_CNTRCT_INFO AS B , KTEX.TB_CNTRCT_FCLTY_DTLS C WHERE A.CNTRCT_NO = B.CNTRCT_NO AND C.CNTRCT_NO = B.CNTRCT_NO AND (c.FCLTY_MANAGE_NO LIKE '11%' OR c.FCLTY_MANAGE_NO LIKE '21%') AND A.PROGRS_STTUS_CODE IN ('6', '7', '9') AND A.DEL_AT = 0 AND B.DEL_AT = 0 AND C.DEL_AT = 0 AND ( A.HMPG_AT = 1 OR A.HMPG_AT IS NULL ) AND ( A.EVENT_CL_CODE LIKE '11%' OR A.EVENT_CL_CODE LIKE '12%' ) AND a.EVENT_END_DE >= TO_DATE( TO_CHAR(SYSDATE,'YYYY-MM-DD') ||'00:00:00' ,'YYYY-MM-DD HH24:MI:SS') ) AA ORDER BY EVENT_BEGIN_DE ASC ) WHERE RNUM BETWEEN 1 AND 8