/* 사용자 관리 KAMI 사용자 정보 송신 */ SELECT USER_ID, USER_PWD, AMMS_HDQR_CL_CD, AMMS_BIZP_CL_CD, AMMS_BLON_CL_CD, CO_REG_NO, USER_MPHN_NO, AMMS_MBL_USER_AUTH_CD, USE_YN , LST_CHG_DT, LST_CHGR_EMPNO, FRST_REG_DT, FRST_REGR_EMPNO FROM ( SELECT USER_ID, USER_PWD, AMMS_HDQR_CL_CD, AMMS_BIZP_CL_CD, AMMS_BLON_CL_CD, CO_REG_NO, USER_MPHN_NO, AMMS_MBL_USER_AUTH_CD, USE_YN, TO_CHAR(LST_CHG_DT, 'YYYYMMDDHH24MISS') AS LST_CHG_DT, LST_CHGR_EMPNO, TO_CHAR(FRST_REG_DT, 'YYYYMMDDHH24MISS') AS FRST_REG_DT, FRST_REGR_EMPNO , ROW_NUMBER() OVER (ORDER BY USER_ID) AS R_NUM FROM T_KAMI_USER WHERE 1 = 1 AND AWMS_SEND_YN = 'N' ) WHERE 1 = 1 AND R_NUM BETWEEN 1 AND 1000
/* 사용자 관리 KAMI 사용자 정보 송신 상태 변경 */ UPDATE T_KAMI_USER SET AWMS_SEND_YN = 'Y' , AWMS_SEND_DATE = SYSDATE WHERE 1 = 1 AND USER_ID IN ( SELECT USER_ID FROM ( SELECT USER_ID, USER_PWD, AMMS_HDQR_CL_CD, AMMS_BIZP_CL_CD, AMMS_BLON_CL_CD, CO_REG_NO, USER_MPHN_NO, AMMS_MBL_USER_AUTH_CD, USE_YN, TO_CHAR(LST_CHG_DT, 'YYYYMMDDHH24MISS') AS LST_CHG_DT, LST_CHGR_EMPNO, TO_CHAR(FRST_REG_DT, 'YYYYMMDDHH24MISS') AS FRST_REG_DT, FRST_REGR_EMPNO , ROW_NUMBER() OVER (ORDER BY USER_ID) AS R_NUM FROM T_KAMI_USER WHERE 1 = 1 AND AWMS_SEND_YN = 'N' ) WHERE 1 = 1 AND R_NUM BETWEEN 1 AND 1000 )
/* 사용자 관리 AD_USER 정보 송신 */ SELECT SEQ, ID, PWD, "NAME", USE_YN, AUTH_CODE, EMAIL, TEL, HP, KDN_DEPT1, KDN_DEPT2, RANK1, RANK2, ATCH_FILE_ID, ATCH_FILE_ID2, LAST_DATE, PUSH_YN, CHARGE_YN, AUTO_YN, AUTH_NUM, DEL_YN , REG_ID, REG_DATE, MOD_ID, MOD_DATE FROM ( SELECT SEQ, ID, PWD, "NAME", USE_YN, AUTH_CODE, EMAIL, TEL, HP, KDN_DEPT1, KDN_DEPT2, RANK1, RANK2, ATCH_FILE_ID, ATCH_FILE_ID2, LAST_DATE, PUSH_YN, CHARGE_YN, AUTO_YN, AUTH_NUM, DEL_YN , REG_ID, TO_CHAR(REG_DATE, 'YYYYMMDDHH24MISS') AS REG_DATE, MOD_ID, TO_CHAR(MOD_DATE, 'YYYYMMDDHH24MISS') AS MOD_DATE , ROW_NUMBER() OVER (ORDER BY SEQ) AS R_NUM FROM T_AD_USER WHERE 1 = 1 AND AWMS_SEND_YN = 'N' AND USE_YN = 'Y' ) WHERE 1 = 1 AND R_NUM BETWEEN 1 AND 1000
/* 사용자 관리 AD_USER 정보 송신 상태 변경 */ UPDATE T_AD_USER SET AWMS_SEND_YN = 'Y' , AWMS_SEND_DATE = SYSDATE WHERE 1 = 1 AND SEQ IN ( SELECT SEQ FROM ( SELECT SEQ, ID, PWD, "NAME", USE_YN, AUTH_CODE, EMAIL, TEL, HP, KDN_DEPT1, KDN_DEPT2, RANK1, RANK2, ATCH_FILE_ID, ATCH_FILE_ID2, LAST_DATE, PUSH_YN, CHARGE_YN, AUTO_YN, AUTH_NUM, DEL_YN , REG_ID, TO_CHAR(REG_DATE, 'YYYYMMDDHH24MISS') AS REG_DATE, MOD_ID, TO_CHAR(MOD_DATE, 'YYYYMMDDHH24MISS') AS MOD_DATE , ROW_NUMBER() OVER (ORDER BY SEQ) AS R_NUM FROM T_AD_USER WHERE 1 = 1 AND AWMS_SEND_YN = 'N' ) WHERE 1 = 1 AND R_NUM BETWEEN 1 AND 1000 )
/* 사용자 관리 ETC_USER 정보 송신 */ SELECT SEQ, ID, "NAME", COMP_NM, KDN_DEPT1, KDN_DEPT2, RANK1, RANK2, HP, DEL_YN, USE_YN, BLON_CO_CL_CD, SBCN_CO, WORK_DIV , REG_ID, REG_DATE, MOD_ID, MOD_DATE FROM ( SELECT SEQ, ID, "NAME", COMP_NM, KDN_DEPT1, KDN_DEPT2, RANK1, RANK2, HP, DEL_YN, USE_YN, BLON_CO_CL_CD, SBCN_CO, WORK_DIV , REG_ID, TO_CHAR(REG_DATE, 'YYYYMMDDHH24MISS') AS REG_DATE, MOD_ID, TO_CHAR(MOD_DATE, 'YYYYMMDDHH24MISS') AS MOD_DATE , ROW_NUMBER() OVER (ORDER BY SEQ) AS R_NUM FROM T_ETC_USER WHERE 1 = 1 AND AWMS_SEND_YN = 'N' AND USE_YN = 'Y' ) WHERE 1 = 1 AND R_NUM BETWEEN 1 AND 1000
/* 사용자 관리 ETC_USER 정보 송신 상태 변경 */ UPDATE T_ETC_USER SET AWMS_SEND_YN = 'Y' , AWMS_SEND_DATE = SYSDATE WHERE 1 = 1 AND SEQ IN ( SELECT SEQ FROM ( SELECT SEQ, ID, "NAME", COMP_NM, KDN_DEPT1, KDN_DEPT2, RANK1, RANK2, HP, DEL_YN, USE_YN, BLON_CO_CL_CD, SBCN_CO, WORK_DIV , REG_ID, TO_CHAR(REG_DATE, 'YYYYMMDDHH24MISS') AS REG_DATE, MOD_ID, TO_CHAR(MOD_DATE, 'YYYYMMDDHH24MISS') AS MOD_DATE , ROW_NUMBER() OVER (ORDER BY SEQ) AS R_NUM FROM T_ETC_USER WHERE 1 = 1 AND AWMS_SEND_YN = 'N' ) WHERE 1 = 1 AND R_NUM BETWEEN 1 AND 1000 )