2014-11-11 10:45:43 yIPz 172.26.35.231 y INFOz SELECT TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[0]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[1]END_DATETIME*/ ,TO_CHAR(CALENDAR_DATE, 'YYYY/MM/DD') /*[2]CALENDAR_DATE*/ ,TIME_ZONE_FLG /*[3]TIME_ZONE_FLG*/ FROM CALENDAR_ER WHERE (CALENDAR_DATE = :CALENDAR_DATE1 OR CALENDAR_DATE = :CALENDAR_DATE2) ORDER BY CALENDAR_DATE ,TIME_ZONE_FLG 2014-11-11 10:45:43 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE1]:2014/11/11 2014-11-11 10:45:43 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE2]:2014/11/10 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz SELECT TO_CHAR(NVL(KE.RAIIN_DATETIME, UT.UKETSUKE_DATETIME), 'YYYY/MM/DD HH24:MI:SS') RAIIN_DATETIME /*[0]RAIIN_DATETIME @*/ ,UT.KANJA_ID KANJA_ID /*[1]KANJA_ID ID*/ ,KJ.NAME KANJA_NAME /*[2]KANJA_NAME Ҏ*/ ,FUNC_GET_KANJA_AGE(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.SEX /*[4]SEX */ ,KE.RAIIN_SECTION_NAME /*[5]SECTION_NAME fÉȖ*/ ,KE.RAIIN_CODE /*[6]RAIIN_CODE @*/ ,KE.RAIIN_NAME /*[7]RAIIN_NAME @ʖ*/ ,KE.TENKI_CODE /*[8]TENKI_CODE ]A*/ ,KE.TENKI_NAME /*[9]TENKI_NAME ]Aʖ*/ ,KE.TENKI_STR /*[10]TENKI_STR ]A*/ ,KE.POINTER_NO /*[11]POINTER_NO |C^ԍ*/ ,KE.CONDITION_FLG /*[12]CONDITION_FLG RfBVtO*/ ,TO_CHAR(UT.UKETSUKE_DATETIME,'YYYY/MM/DD HH24:MI:SS') UKETSUKE_DATETIME /*[13]UKETSUKE_DATETIME t*/ ,TO_CHAR(UT.HANTEI_DATE, 'YYYY/MM/DD') HANTEI_DATE /*[14]HANTEI_DATE */ ,DECODE(KE.CONDITION_FLG, 2, 'ݒ', NVL2(KE.STR_03, KE.STR_03, 'ݒ') || NVL2(KE.TEXT_03, '(' || KE.TEXT_03 || ')', '')) HOKEN_STR /*[15]HOKEN_STR ی*/ ,KE.STR_04 JIKANGAI_KASAN_STR /*[16]JIKANGAI_KASAN_STR ԊOZ*/ ,DECODE(NVL2(KE.DATE_01, TO_CHAR(KE.DATE_01, 'YYYY/MM/DD'), '0001/01/01'), '0001/01/01', '', TO_CHAR(KE.DATE_01, 'HH24:MI')) END_TIME /*[17]END_TIME I*/ ,KE.STR_02 KYUKYUTAI /*[18]KYUKYUTAI ~}*/ ,KE.STR_10 BYOTO_NAME /*[19]BYOTO_NAME a*/ ,KE.SHOKAI_MOTO_BYOIN_NAME SHOKAI_MOTO /*[20]SHOKAI_MOTO Љa@*/ ,KE.SHOKAI_MOTO_DOCTOR_UNAME SHOKAI_MOTO_DOC /*[21]SHOKAI_MOTO_DOC Љt*/ ,KE.STR_01 SHOKAI_SAKI /*[22]SHOKAI_SAKI Љa@*/ ,KE.TEXT_01 SHOKAI_SAKI_DOC /*[23]SHOKAI_SAKI_DOC Љt*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[24]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[25]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[26]JUSHO_02 Z2*/ ,KE.TEXT_08 JUSHO_KITEN_STR /*[27]JUSHO_KITEN_STR 󏝋@]*/ ,KE.BIKO_TEXT BIKO_STR /*[28]BIKO_STR l2*/ ,KE.TEXT_09 JUSHO_KITEN_STR2 /*[29]JUSHO_KITEN_STR2 󏝋@]*/ ,KE.TEXT_07 BYOMEI_ALL_STR /*[30]BYOMEI_ALL_STR aS*/ ,KE.SHOSHIN_FLG /*[31]SHOSHIN_FLG f*/ ,KE.STR_10 /*[32]BYOTO_NAME a*/ ,KE.SHOKAI_FLG /*[33]SHOKAI_FLG ЉtO*/ ,KE.SHOCHI_FLGTBL /*[34]SHOCHI_FLGTBL utOe[u*/ ,KE.STR_08 JUSHO_KITEN_FLGTBL /*[35]JUSHO_KITEN_FLGTBL dNj@]tOe[u*/ ,KE.CODE_03 HOKEN_CODE /*[36]HOKEN_CODE یR[h*/ ,DECODE(KE.FLG_05, 1, 0, 1) TOKEI_FLG /*[37]TOKEI_FLG vtO*/ ,TO_CHAR(KJ.BIRTH_DATE, 'yyyy/mm/dd') AS BIRTH_DATE /*[38]BIRTH_DATE a*/ ,KE.TEXT_02 /*[39]KENSA_SHOCHI u*/ ,KE.DOCTOR_UNAME /*[40]DOCTOR_UNAME t*/ ,KE.TEXT_05 /*[41]DOCTOR_All_UNAME tS*/ ,KE.TEXT_06 /*[42]SECCTION_ALL_NAME fÉȖS*/ FROM KANJA_ER KE ,KANJA KJ ,UKETSUKE UT WHERE UT.HANTEI_DATE BETWEEN :UKETSUKE_START_DATE AND :UKETSUKE_END_DATE AND UT.CONDITION_FLG = 0 AND UT.KANJA_ID = KJ.KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND UT.POINTER_NO = KE.CODE_DBL_01(+) AND UT.KANJA_ID = KE.KANJA_ID(+) AND UT.YOYAKU_SECTION_CODE = :KYUKYU_GAIRAI_SECTION_CODE ORDER BY RAIIN_DATETIME ,KANJA_ID 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:UKETSUKE_START_DATE]:2014/11/11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:UKETSUKE_END_DATE]:2014/11/11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:KYUKYU_GAIRAI_SECTION_CODE]:78 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:45:44 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:46 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:48 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ FROM COMMON WHERE MASTER_CODE_STR = '00010014' AND CODE > 1 AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2014-11-11 10:45:48 yIPz 172.26.35.231 y INFOz SELECT USER_ID ,NAME FROM STAFF WHERE CONDITION_FLG = 0 AND LAST_FLG = 1 AND TAISHOKU_FLG = 0 AND KIND = :KIND ORDER BY DISP_ORDER ,KANA_NAME ,USER_ID 2014-11-11 10:45:48 yIPz 172.26.35.231 y INFOz [:KIND]:1 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz SELECT ER_KIND ,COUNT(*) FROM TANTO_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CONDITION_FLG = 0 GROUP BY ER_KIND 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz UPDATE CALENDAR_ER SET COMMENT_TEXT = :TOKKI_JIKOU ,WEATHER_CODE = :WEATHER_CODE ,WEATHER_STR = :WEATHER_NAME ,NAIKA_TOBAN_FLG = :NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG = :GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG = :SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR = :NAIKA_TOBAN_STR ,GEKA_TOBAN_STR = :GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR = :SHONIKA_TOBAN_STR WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:WEATHER_CODE]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:WEATHER_NAME]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:TOKKI_JIKOU]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:NAIKA_TOBAN_FLG]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:GEKA_TOBAN_FLG]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:SHONIKA_TOBAN_FLG]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:NAIKA_TOBAN_STR]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:GEKA_TOBAN_STR]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz [:SHONIKA_TOBAN_STR]: 2014-11-11 10:45:56 yIPz 172.26.35.231 y INFOz Commit 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz SELECT TO_CHAR(NVL(KE.RAIIN_DATETIME, UT.UKETSUKE_DATETIME), 'YYYY/MM/DD HH24:MI:SS') RAIIN_DATETIME /*[0]RAIIN_DATETIME @*/ ,UT.KANJA_ID KANJA_ID /*[1]KANJA_ID ID*/ ,KJ.NAME KANJA_NAME /*[2]KANJA_NAME Ҏ*/ ,FUNC_GET_KANJA_AGE(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.SEX /*[4]SEX */ ,KE.RAIIN_SECTION_NAME /*[5]SECTION_NAME fÉȖ*/ ,KE.RAIIN_CODE /*[6]RAIIN_CODE @*/ ,KE.RAIIN_NAME /*[7]RAIIN_NAME @ʖ*/ ,KE.TENKI_CODE /*[8]TENKI_CODE ]A*/ ,KE.TENKI_NAME /*[9]TENKI_NAME ]Aʖ*/ ,KE.TENKI_STR /*[10]TENKI_STR ]A*/ ,KE.POINTER_NO /*[11]POINTER_NO |C^ԍ*/ ,KE.CONDITION_FLG /*[12]CONDITION_FLG RfBVtO*/ ,TO_CHAR(UT.UKETSUKE_DATETIME,'YYYY/MM/DD HH24:MI:SS') UKETSUKE_DATETIME /*[13]UKETSUKE_DATETIME t*/ ,TO_CHAR(UT.HANTEI_DATE, 'YYYY/MM/DD') HANTEI_DATE /*[14]HANTEI_DATE */ ,DECODE(KE.CONDITION_FLG, 2, 'ݒ', NVL2(KE.STR_03, KE.STR_03, 'ݒ') || NVL2(KE.TEXT_03, '(' || KE.TEXT_03 || ')', '')) HOKEN_STR /*[15]HOKEN_STR ی*/ ,KE.STR_04 JIKANGAI_KASAN_STR /*[16]JIKANGAI_KASAN_STR ԊOZ*/ ,DECODE(NVL2(KE.DATE_01, TO_CHAR(KE.DATE_01, 'YYYY/MM/DD'), '0001/01/01'), '0001/01/01', '', TO_CHAR(KE.DATE_01, 'HH24:MI')) END_TIME /*[17]END_TIME I*/ ,KE.STR_02 KYUKYUTAI /*[18]KYUKYUTAI ~}*/ ,KE.STR_10 BYOTO_NAME /*[19]BYOTO_NAME a*/ ,KE.SHOKAI_MOTO_BYOIN_NAME SHOKAI_MOTO /*[20]SHOKAI_MOTO Љa@*/ ,KE.SHOKAI_MOTO_DOCTOR_UNAME SHOKAI_MOTO_DOC /*[21]SHOKAI_MOTO_DOC Љt*/ ,KE.STR_01 SHOKAI_SAKI /*[22]SHOKAI_SAKI Љa@*/ ,KE.TEXT_01 SHOKAI_SAKI_DOC /*[23]SHOKAI_SAKI_DOC Љt*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[24]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[25]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[26]JUSHO_02 Z2*/ ,KE.TEXT_08 JUSHO_KITEN_STR /*[27]JUSHO_KITEN_STR 󏝋@]*/ ,KE.BIKO_TEXT BIKO_STR /*[28]BIKO_STR l2*/ ,KE.TEXT_09 JUSHO_KITEN_STR2 /*[29]JUSHO_KITEN_STR2 󏝋@]*/ ,KE.TEXT_07 BYOMEI_ALL_STR /*[30]BYOMEI_ALL_STR aS*/ ,KE.SHOSHIN_FLG /*[31]SHOSHIN_FLG f*/ ,KE.STR_10 /*[32]BYOTO_NAME a*/ ,KE.SHOKAI_FLG /*[33]SHOKAI_FLG ЉtO*/ ,KE.SHOCHI_FLGTBL /*[34]SHOCHI_FLGTBL utOe[u*/ ,KE.STR_08 JUSHO_KITEN_FLGTBL /*[35]JUSHO_KITEN_FLGTBL dNj@]tOe[u*/ ,KE.CODE_03 HOKEN_CODE /*[36]HOKEN_CODE یR[h*/ ,DECODE(KE.FLG_05, 1, 0, 1) TOKEI_FLG /*[37]TOKEI_FLG vtO*/ ,TO_CHAR(KJ.BIRTH_DATE, 'yyyy/mm/dd') AS BIRTH_DATE /*[38]BIRTH_DATE a*/ ,KE.TEXT_02 /*[39]KENSA_SHOCHI u*/ ,KE.DOCTOR_UNAME /*[40]DOCTOR_UNAME t*/ ,KE.TEXT_05 /*[41]DOCTOR_All_UNAME tS*/ ,KE.TEXT_06 /*[42]SECCTION_ALL_NAME fÉȖS*/ FROM KANJA_ER KE ,KANJA KJ ,UKETSUKE UT WHERE UT.HANTEI_DATE BETWEEN :UKETSUKE_START_DATE AND :UKETSUKE_END_DATE AND UT.CONDITION_FLG = 0 AND UT.KANJA_ID = KJ.KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND UT.POINTER_NO = KE.CODE_DBL_01(+) AND UT.KANJA_ID = KE.KANJA_ID(+) AND UT.YOYAKU_SECTION_CODE = :KYUKYU_GAIRAI_SECTION_CODE ORDER BY RAIIN_DATETIME ,KANJA_ID 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:UKETSUKE_START_DATE]:2014/11/11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:UKETSUKE_END_DATE]:2014/11/11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:KYUKYU_GAIRAI_SECTION_CODE]:78 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:45:59 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:03 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:46:04 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:04 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:04 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:04 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz SELECT ER_KIND ,COUNT(*) FROM TANTO_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CONDITION_FLG = 0 GROUP BY ER_KIND 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz UPDATE CALENDAR_ER SET COMMENT_TEXT = :TOKKI_JIKOU ,WEATHER_CODE = :WEATHER_CODE ,WEATHER_STR = :WEATHER_NAME ,NAIKA_TOBAN_FLG = :NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG = :GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG = :SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR = :NAIKA_TOBAN_STR ,GEKA_TOBAN_STR = :GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR = :SHONIKA_TOBAN_STR WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:WEATHER_CODE]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:WEATHER_NAME]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:TOKKI_JIKOU]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:NAIKA_TOBAN_FLG]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:GEKA_TOBAN_FLG]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:SHONIKA_TOBAN_FLG]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:NAIKA_TOBAN_STR]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:GEKA_TOBAN_STR]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz [:SHONIKA_TOBAN_STR]: 2014-11-11 10:46:07 yIPz 172.26.35.231 y INFOz Commit 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz SELECT TO_CHAR(NVL(KE.RAIIN_DATETIME, UT.UKETSUKE_DATETIME), 'YYYY/MM/DD HH24:MI:SS') RAIIN_DATETIME /*[0]RAIIN_DATETIME @*/ ,UT.KANJA_ID KANJA_ID /*[1]KANJA_ID ID*/ ,KJ.NAME KANJA_NAME /*[2]KANJA_NAME Ҏ*/ ,FUNC_GET_KANJA_AGE(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.SEX /*[4]SEX */ ,KE.RAIIN_SECTION_NAME /*[5]SECTION_NAME fÉȖ*/ ,KE.RAIIN_CODE /*[6]RAIIN_CODE @*/ ,KE.RAIIN_NAME /*[7]RAIIN_NAME @ʖ*/ ,KE.TENKI_CODE /*[8]TENKI_CODE ]A*/ ,KE.TENKI_NAME /*[9]TENKI_NAME ]Aʖ*/ ,KE.TENKI_STR /*[10]TENKI_STR ]A*/ ,KE.POINTER_NO /*[11]POINTER_NO |C^ԍ*/ ,KE.CONDITION_FLG /*[12]CONDITION_FLG RfBVtO*/ ,TO_CHAR(UT.UKETSUKE_DATETIME,'YYYY/MM/DD HH24:MI:SS') UKETSUKE_DATETIME /*[13]UKETSUKE_DATETIME t*/ ,TO_CHAR(UT.HANTEI_DATE, 'YYYY/MM/DD') HANTEI_DATE /*[14]HANTEI_DATE */ ,DECODE(KE.CONDITION_FLG, 2, 'ݒ', NVL2(KE.STR_03, KE.STR_03, 'ݒ') || NVL2(KE.TEXT_03, '(' || KE.TEXT_03 || ')', '')) HOKEN_STR /*[15]HOKEN_STR ی*/ ,KE.STR_04 JIKANGAI_KASAN_STR /*[16]JIKANGAI_KASAN_STR ԊOZ*/ ,DECODE(NVL2(KE.DATE_01, TO_CHAR(KE.DATE_01, 'YYYY/MM/DD'), '0001/01/01'), '0001/01/01', '', TO_CHAR(KE.DATE_01, 'HH24:MI')) END_TIME /*[17]END_TIME I*/ ,KE.STR_02 KYUKYUTAI /*[18]KYUKYUTAI ~}*/ ,KE.STR_10 BYOTO_NAME /*[19]BYOTO_NAME a*/ ,KE.SHOKAI_MOTO_BYOIN_NAME SHOKAI_MOTO /*[20]SHOKAI_MOTO Љa@*/ ,KE.SHOKAI_MOTO_DOCTOR_UNAME SHOKAI_MOTO_DOC /*[21]SHOKAI_MOTO_DOC Љt*/ ,KE.STR_01 SHOKAI_SAKI /*[22]SHOKAI_SAKI Љa@*/ ,KE.TEXT_01 SHOKAI_SAKI_DOC /*[23]SHOKAI_SAKI_DOC Љt*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[24]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[25]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[26]JUSHO_02 Z2*/ ,KE.TEXT_08 JUSHO_KITEN_STR /*[27]JUSHO_KITEN_STR 󏝋@]*/ ,KE.BIKO_TEXT BIKO_STR /*[28]BIKO_STR l2*/ ,KE.TEXT_09 JUSHO_KITEN_STR2 /*[29]JUSHO_KITEN_STR2 󏝋@]*/ ,KE.TEXT_07 BYOMEI_ALL_STR /*[30]BYOMEI_ALL_STR aS*/ ,KE.SHOSHIN_FLG /*[31]SHOSHIN_FLG f*/ ,KE.STR_10 /*[32]BYOTO_NAME a*/ ,KE.SHOKAI_FLG /*[33]SHOKAI_FLG ЉtO*/ ,KE.SHOCHI_FLGTBL /*[34]SHOCHI_FLGTBL utOe[u*/ ,KE.STR_08 JUSHO_KITEN_FLGTBL /*[35]JUSHO_KITEN_FLGTBL dNj@]tOe[u*/ ,KE.CODE_03 HOKEN_CODE /*[36]HOKEN_CODE یR[h*/ ,DECODE(KE.FLG_05, 1, 0, 1) TOKEI_FLG /*[37]TOKEI_FLG vtO*/ ,TO_CHAR(KJ.BIRTH_DATE, 'yyyy/mm/dd') AS BIRTH_DATE /*[38]BIRTH_DATE a*/ ,KE.TEXT_02 /*[39]KENSA_SHOCHI u*/ ,KE.DOCTOR_UNAME /*[40]DOCTOR_UNAME t*/ ,KE.TEXT_05 /*[41]DOCTOR_All_UNAME tS*/ ,KE.TEXT_06 /*[42]SECCTION_ALL_NAME fÉȖS*/ FROM KANJA_ER KE ,KANJA KJ ,UKETSUKE UT WHERE UT.HANTEI_DATE BETWEEN :UKETSUKE_START_DATE AND :UKETSUKE_END_DATE AND UT.CONDITION_FLG = 0 AND UT.KANJA_ID = KJ.KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND UT.POINTER_NO = KE.CODE_DBL_01(+) AND UT.KANJA_ID = KE.KANJA_ID(+) AND UT.YOYAKU_SECTION_CODE = :KYUKYU_GAIRAI_SECTION_CODE ORDER BY RAIIN_DATETIME ,KANJA_ID 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:UKETSUKE_START_DATE]:2014/11/11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:UKETSUKE_END_DATE]:2014/11/11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:KYUKYU_GAIRAI_SECTION_CODE]:78 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:46:09 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz SELECT TO_CHAR(NVL(KE.RAIIN_DATETIME, UT.UKETSUKE_DATETIME), 'YYYY/MM/DD HH24:MI:SS') RAIIN_DATETIME /*[0]RAIIN_DATETIME @*/ ,UT.KANJA_ID KANJA_ID /*[1]KANJA_ID ID*/ ,KJ.NAME KANJA_NAME /*[2]KANJA_NAME Ҏ*/ ,FUNC_GET_KANJA_AGE(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.SEX /*[4]SEX */ ,KE.RAIIN_SECTION_NAME /*[5]SECTION_NAME fÉȖ*/ ,KE.RAIIN_CODE /*[6]RAIIN_CODE @*/ ,KE.RAIIN_NAME /*[7]RAIIN_NAME @ʖ*/ ,KE.TENKI_CODE /*[8]TENKI_CODE ]A*/ ,KE.TENKI_NAME /*[9]TENKI_NAME ]Aʖ*/ ,KE.TENKI_STR /*[10]TENKI_STR ]A*/ ,KE.POINTER_NO /*[11]POINTER_NO |C^ԍ*/ ,KE.CONDITION_FLG /*[12]CONDITION_FLG RfBVtO*/ ,TO_CHAR(UT.UKETSUKE_DATETIME,'YYYY/MM/DD HH24:MI:SS') UKETSUKE_DATETIME /*[13]UKETSUKE_DATETIME t*/ ,TO_CHAR(UT.HANTEI_DATE, 'YYYY/MM/DD') HANTEI_DATE /*[14]HANTEI_DATE */ ,DECODE(KE.CONDITION_FLG, 2, 'ݒ', NVL2(KE.STR_03, KE.STR_03, 'ݒ') || NVL2(KE.TEXT_03, '(' || KE.TEXT_03 || ')', '')) HOKEN_STR /*[15]HOKEN_STR ی*/ ,KE.STR_04 JIKANGAI_KASAN_STR /*[16]JIKANGAI_KASAN_STR ԊOZ*/ ,DECODE(NVL2(KE.DATE_01, TO_CHAR(KE.DATE_01, 'YYYY/MM/DD'), '0001/01/01'), '0001/01/01', '', TO_CHAR(KE.DATE_01, 'HH24:MI')) END_TIME /*[17]END_TIME I*/ ,KE.STR_02 KYUKYUTAI /*[18]KYUKYUTAI ~}*/ ,KE.STR_10 BYOTO_NAME /*[19]BYOTO_NAME a*/ ,KE.SHOKAI_MOTO_BYOIN_NAME SHOKAI_MOTO /*[20]SHOKAI_MOTO Љa@*/ ,KE.SHOKAI_MOTO_DOCTOR_UNAME SHOKAI_MOTO_DOC /*[21]SHOKAI_MOTO_DOC Љt*/ ,KE.STR_01 SHOKAI_SAKI /*[22]SHOKAI_SAKI Љa@*/ ,KE.TEXT_01 SHOKAI_SAKI_DOC /*[23]SHOKAI_SAKI_DOC Љt*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[24]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[25]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[26]JUSHO_02 Z2*/ ,KE.TEXT_08 JUSHO_KITEN_STR /*[27]JUSHO_KITEN_STR 󏝋@]*/ ,KE.BIKO_TEXT BIKO_STR /*[28]BIKO_STR l2*/ ,KE.TEXT_09 JUSHO_KITEN_STR2 /*[29]JUSHO_KITEN_STR2 󏝋@]*/ ,KE.TEXT_07 BYOMEI_ALL_STR /*[30]BYOMEI_ALL_STR aS*/ ,KE.SHOSHIN_FLG /*[31]SHOSHIN_FLG f*/ ,KE.STR_10 /*[32]BYOTO_NAME a*/ ,KE.SHOKAI_FLG /*[33]SHOKAI_FLG ЉtO*/ ,KE.SHOCHI_FLGTBL /*[34]SHOCHI_FLGTBL utOe[u*/ ,KE.STR_08 JUSHO_KITEN_FLGTBL /*[35]JUSHO_KITEN_FLGTBL dNj@]tOe[u*/ ,KE.CODE_03 HOKEN_CODE /*[36]HOKEN_CODE یR[h*/ ,DECODE(KE.FLG_05, 1, 0, 1) TOKEI_FLG /*[37]TOKEI_FLG vtO*/ ,TO_CHAR(KJ.BIRTH_DATE, 'yyyy/mm/dd') AS BIRTH_DATE /*[38]BIRTH_DATE a*/ ,KE.TEXT_02 /*[39]KENSA_SHOCHI u*/ ,KE.DOCTOR_UNAME /*[40]DOCTOR_UNAME t*/ ,KE.TEXT_05 /*[41]DOCTOR_All_UNAME tS*/ ,KE.TEXT_06 /*[42]SECCTION_ALL_NAME fÉȖS*/ FROM KANJA_ER KE ,KANJA KJ ,UKETSUKE UT WHERE UT.HANTEI_DATE BETWEEN :UKETSUKE_START_DATE AND :UKETSUKE_END_DATE AND UT.CONDITION_FLG = 0 AND UT.KANJA_ID = KJ.KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND UT.POINTER_NO = KE.CODE_DBL_01(+) AND UT.KANJA_ID = KE.KANJA_ID(+) AND UT.YOYAKU_SECTION_CODE = :KYUKYU_GAIRAI_SECTION_CODE ORDER BY RAIIN_DATETIME ,KANJA_ID 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:UKETSUKE_START_DATE]:2014/11/11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:UKETSUKE_END_DATE]:2014/11/11 2014-11-11 10:46:13 yIPz 172.26.35.231 y INFOz [:KYUKYU_GAIRAI_SECTION_CODE]:78 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:47:32 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz SELECT TO_CHAR(NVL(KE.RAIIN_DATETIME, UT.UKETSUKE_DATETIME), 'YYYY/MM/DD HH24:MI:SS') RAIIN_DATETIME /*[0]RAIIN_DATETIME @*/ ,UT.KANJA_ID KANJA_ID /*[1]KANJA_ID ID*/ ,KJ.NAME KANJA_NAME /*[2]KANJA_NAME Ҏ*/ ,FUNC_GET_KANJA_AGE(KJ.BIRTH_DATE,SYSDATE) AGE /*[3]AGE N*/ ,KJ.SEX /*[4]SEX */ ,KE.RAIIN_SECTION_NAME /*[5]SECTION_NAME fÉȖ*/ ,KE.RAIIN_CODE /*[6]RAIIN_CODE @*/ ,KE.RAIIN_NAME /*[7]RAIIN_NAME @ʖ*/ ,KE.TENKI_CODE /*[8]TENKI_CODE ]A*/ ,KE.TENKI_NAME /*[9]TENKI_NAME ]Aʖ*/ ,KE.TENKI_STR /*[10]TENKI_STR ]A*/ ,KE.POINTER_NO /*[11]POINTER_NO |C^ԍ*/ ,KE.CONDITION_FLG /*[12]CONDITION_FLG RfBVtO*/ ,TO_CHAR(UT.UKETSUKE_DATETIME,'YYYY/MM/DD HH24:MI:SS') UKETSUKE_DATETIME /*[13]UKETSUKE_DATETIME t*/ ,TO_CHAR(UT.HANTEI_DATE, 'YYYY/MM/DD') HANTEI_DATE /*[14]HANTEI_DATE */ ,DECODE(KE.CONDITION_FLG, 2, 'ݒ', NVL2(KE.STR_03, KE.STR_03, 'ݒ') || NVL2(KE.TEXT_03, '(' || KE.TEXT_03 || ')', '')) HOKEN_STR /*[15]HOKEN_STR ی*/ ,KE.STR_04 JIKANGAI_KASAN_STR /*[16]JIKANGAI_KASAN_STR ԊOZ*/ ,DECODE(NVL2(KE.DATE_01, TO_CHAR(KE.DATE_01, 'YYYY/MM/DD'), '0001/01/01'), '0001/01/01', '', TO_CHAR(KE.DATE_01, 'HH24:MI')) END_TIME /*[17]END_TIME I*/ ,KE.STR_02 KYUKYUTAI /*[18]KYUKYUTAI ~}*/ ,KE.STR_10 BYOTO_NAME /*[19]BYOTO_NAME a*/ ,KE.SHOKAI_MOTO_BYOIN_NAME SHOKAI_MOTO /*[20]SHOKAI_MOTO Љa@*/ ,KE.SHOKAI_MOTO_DOCTOR_UNAME SHOKAI_MOTO_DOC /*[21]SHOKAI_MOTO_DOC Љt*/ ,KE.STR_01 SHOKAI_SAKI /*[22]SHOKAI_SAKI Љa@*/ ,KE.TEXT_01 SHOKAI_SAKI_DOC /*[23]SHOKAI_SAKI_DOC Љt*/ ,KJ.JITAKU_JUSHO_01 || KJ.JITAKU_JUSHO_02 JUSHO /*[24]JUSHO Z*/ ,KJ.JITAKU_JUSHO_01 JUSHO_01 /*[25]JUSHO_01 Z1*/ ,KJ.JITAKU_JUSHO_02 JUSHO_02 /*[26]JUSHO_02 Z2*/ ,KE.TEXT_08 JUSHO_KITEN_STR /*[27]JUSHO_KITEN_STR 󏝋@]*/ ,KE.BIKO_TEXT BIKO_STR /*[28]BIKO_STR l2*/ ,KE.TEXT_09 JUSHO_KITEN_STR2 /*[29]JUSHO_KITEN_STR2 󏝋@]*/ ,KE.TEXT_07 BYOMEI_ALL_STR /*[30]BYOMEI_ALL_STR aS*/ ,KE.SHOSHIN_FLG /*[31]SHOSHIN_FLG f*/ ,KE.STR_10 /*[32]BYOTO_NAME a*/ ,KE.SHOKAI_FLG /*[33]SHOKAI_FLG ЉtO*/ ,KE.SHOCHI_FLGTBL /*[34]SHOCHI_FLGTBL utOe[u*/ ,KE.STR_08 JUSHO_KITEN_FLGTBL /*[35]JUSHO_KITEN_FLGTBL dNj@]tOe[u*/ ,KE.CODE_03 HOKEN_CODE /*[36]HOKEN_CODE یR[h*/ ,DECODE(KE.FLG_05, 1, 0, 1) TOKEI_FLG /*[37]TOKEI_FLG vtO*/ ,TO_CHAR(KJ.BIRTH_DATE, 'yyyy/mm/dd') AS BIRTH_DATE /*[38]BIRTH_DATE a*/ ,KE.TEXT_02 /*[39]KENSA_SHOCHI u*/ ,KE.DOCTOR_UNAME /*[40]DOCTOR_UNAME t*/ ,KE.TEXT_05 /*[41]DOCTOR_All_UNAME tS*/ ,KE.TEXT_06 /*[42]SECCTION_ALL_NAME fÉȖS*/ FROM KANJA_ER KE ,KANJA KJ ,UKETSUKE UT WHERE UT.HANTEI_DATE BETWEEN :UKETSUKE_START_DATE AND :UKETSUKE_END_DATE AND UT.CONDITION_FLG = 0 AND UT.KANJA_ID = KJ.KANJA_ID AND KJ.CONDITION_FLG = 0 AND KJ.LAST_FLG = 1 AND UT.POINTER_NO = KE.CODE_DBL_01(+) AND UT.KANJA_ID = KE.KANJA_ID(+) AND UT.YOYAKU_SECTION_CODE = :KYUKYU_GAIRAI_SECTION_CODE ORDER BY RAIIN_DATETIME ,KANJA_ID 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:UKETSUKE_START_DATE]:2014/11/11 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:UKETSUKE_END_DATE]:2014/11/11 2014-11-11 10:47:34 yIPz 172.26.35.231 y INFOz [:KYUKYU_GAIRAI_SECTION_CODE]:78 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz SELECT YYYY /*[0]YYYY*/ ,MM /*[1]MM*/ ,DD /*[2]DD*/ ,WEEK_FLG /*[3]WEEK_FLG*/ ,WEEK_STR /*[4]WEEK_STR*/ ,COMMENT_STR /*[5]COMMENT_STR*/ ,HOLIDAY_FLG /*[6]HOLIDAY_FLG*/ ,TIME_ZONE_FLG /*[7]TIME_ZONE_FLG*/ ,TO_CHAR(START_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[8]START_DATETIME*/ ,TO_CHAR(END_DATETIME, 'YYYY/MM/DD HH24:MI:SS') /*[9]END_DATETIME*/ ,COMMENT_TEXT /*[10]COMMENT_TEXT*/ ,WEATHER_CODE /*[11]WEATHER_CODE*/ ,WEATHER_STR /*[12]WEATHER_STR*/ FROM CALENDAR_ER WHERE CALENDAR_DATE = :CALENDAR_DATE AND TIME_ZONE_FLG = :JIKANTAI_KIND 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz [:CALENDAR_DATE]:2014/11/11 2014-11-11 10:47:35 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ ,CODE_01 /*[2]CODE_01*/ ,FLG_01 /*[3]FLG_01*/ ,FLG_02 /*[4]FLG_02*/ ,FLG_03 /*[5]FLG_03*/ ,FLG_04 /*[6]FLG_04*/ FROM COMMON WHERE MASTER_CODE_STR = '00010047' AND CONDITION_FLG = 0 AND LAST_FLG = 1 AND KIND = 0 ORDER BY DISP_ORDER ,CODE 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz SELECT TE.POINTER_NO ,TE.ER_KIND ,TE.ER_KIND_NAME ,TE.ROW_NO ,TE.TANTO_UID ,TE.TANTO_UNAME ,CM.FLG_04 FROM TANTO_ER TE ,COMMON CM WHERE TE.YYYY = :YYYY AND TE.MM = :MM AND TE.DD = :DD AND TE.TIME_ZONE_FLG = :JIKANTAI_KIND AND TE.CONDITION_FLG = 0 AND TE.ER_KIND = CM.CODE AND CM.MASTER_CODE_STR = '00010047' ORDER BY ER_KIND, ROW_NO 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz SELECT COMMENT_TEXT ,WEATHER_CODE ,WEATHER_STR ,NAIKA_TOBAN_FLG ,GEKA_TOBAN_FLG ,SHONIKA_TOBAN_FLG ,NAIKA_TOBAN_STR ,GEKA_TOBAN_STR ,SHONIKA_TOBAN_STR FROM CALENDAR_ER WHERE YYYY = :YYYY AND MM = :MM AND DD = :DD AND TIME_ZONE_FLG = :JIKANTAI_KIND AND CTRL_FLG = 0 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:YYYY]:2014 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:MM]:11 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:DD]:11 2014-11-11 10:48:00 yIPz 172.26.35.231 y INFOz [:JIKANTAI_KIND]:1 2014-11-11 10:48:06 yIPz 172.26.35.231 y INFOz SELECT CODE /*[0]CODE*/ ,NAME /*[1]NAME*/ FROM COMMON WHERE MASTER_CODE_STR = '00010014' AND CODE > 1 AND CONDITION_FLG = 0 AND LAST_FLG = 1 ORDER BY DISP_ORDER 2014-11-11 10:48:06 yIPz 172.26.35.231 y INFOz SELECT USER_ID ,NAME FROM STAFF WHERE CONDITION_FLG = 0 AND LAST_FLG = 1 AND TAISHOKU_FLG = 0 AND KIND = :KIND ORDER BY DISP_ORDER ,KANA_NAME ,USER_ID 2014-11-11 10:48:06 yIPz 172.26.35.231 y INFOz [:KIND]:1