/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名：eo顧客基幹システム * モジュール名：JSYejbEKK1151A010TPDA * ソースファイル名：JSYejbEKK1151A010TPDA.java * 作成者：EK912022 * 日付：2013年02月14日 *＜機能概要＞ * 加入御礼書発行一意照会テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン修正日修正者修正内容 * ｖ1.00.00 * ｖ5.00.00 2013/02/07 FJ)坂本 ANK-1421-00-00 * ｖ5.00.01 2013/02/14 FJ)坂本 IT1-2013-0000275 * ｖ9.00.00 2013/04/17 FJ)中野 ANK-2057-00-00 * ********************************************************************************/ package eo.ejb.cbs.sqlf; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.fujitsu.futurity.model.base.CAANJDBCUtil; import com.fujitsu.futurity.model.base.CAANMsg; import com.fujitsu.futurity.model.base.CAANRuntimeException; import com.fujitsu.futurity.model.base.CAANSQLFacility; import com.fujitsu.futurity.model.ejb.common.JSYejbConnection; import com.fujitsu.futurity.model.ejb.common.JSYejbLog; import com.fujitsu.futurity.model.ejb.common.StatusCodes; import com.fujitsu.futurity.model.ejb.common.fw.AgentDispatchContext; import com.fujitsu.futurity.model.ejb.common.fw.TemplateDBAccessHandler; import eo.ejb.cbm.entity.KK1151ETMsg; import eo.ejb.cbs.cbsmsg.EKK1151A010CBSMsg; import eo.ejb.cbs.cbsmsg.EKK1151A010CBSMsg1List; import eo.ejb.common.JKKModelCommon; /** * * テンプレートDBアクセス部品　EKK1151A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/ public class JSYejbEKK1151A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{ /** * コンストラクタ */ public JSYejbEKK1151A010TPDA() { } /** * EKK1151A010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void */ public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){ // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt = null; // リザルトセット ResultSet rsltQuery = null; /******************** * SQL文の作成 ********************/ try{ //コネクション取得 con1 = JSYejbConnection.getConnection(KK1151ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" KK1151.KANUORESO_HAKKO_NO ") .append(" , KK1151.KANUORE_DATA_SBT_CD ") .append(" , (SELECT ZM0171_01.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_01 ") .append(" WHERE ZM0171_01.CD_SBT_CD = 'CD00585' ") .append(" AND ZM0171_01.CD_DIV = KK1151.KANUORE_DATA_SBT_CD ") .append(" AND ZM0171_01.MK_FLG = '0') AS KANUORE_DATA_SBT_CD_NM ") .append(" , KK1151.DATA_CHSHT_DTM ") .append(" , KK1151.SEND_JGI_FLG ") .append(" , (SELECT ZM0171_02.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_02 ") .append(" WHERE ZM0171_02.CD_SBT_CD = 'CD00586' ") .append(" AND ZM0171_02.CD_DIV = KK1151.SEND_JGI_FLG ") .append(" AND ZM0171_02.MK_FLG = '0') AS SEND_JGI_FLG_NM ") .append(" , KK1151.SEND_DTM ") .append(" , KK1151.SYSID ") .append(" , KK1151.SAME_KAISEN_GRP_SKBT_NO ") .append(" , KK1151.SVC_KEI_NO ") .append(" , KK1151.NEW_ADD_SKBT_FLG ") .append(" , (SELECT ZM0171_03.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_03 ") .append(" WHERE ZM0171_03.CD_SBT_CD = 'CD00587' ") .append(" AND ZM0171_03.CD_DIV = KK1151.NEW_ADD_SKBT_FLG ") .append(" AND ZM0171_03.MK_FLG = '0') AS NEW_ADD_SKBT_FLG_NM ") .append(" , KK1151.SKEKKA_CD ") .append(" , (SELECT ZM0171_04.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_04 ") .append(" WHERE ZM0171_04.CD_SBT_CD = 'CD00281' ") .append(" AND ZM0171_04.CD_DIV = KK1151.SKEKKA_CD ") .append(" AND ZM0171_04.MK_FLG = '0') AS SKEKKA_CD_NM ") .append(" , KK1151.LETTER_SBT_CD ") .append(" , (SELECT ZM0171_05.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_05 ") .append(" WHERE ZM0171_05.CD_SBT_CD = 'CD00588' ") .append(" AND ZM0171_05.CD_DIV = KK1151.LETTER_SBT_CD ") .append(" AND ZM0171_05.MK_FLG = '0') AS LETTER_SBT_CD_NM ") .append(" , KK1151.SEND_YO_SVC_NM ") .append(" , KK1151.SEND_YO_PRC_COURSE_NM ") .append(" , KK1151.DTAIL_SVC_NM ") .append(" , KK1151.SVC_CD ") .append(" , KK1151.PCRS_CD ") .append(" , KK1151.SOKU_WARI_UM ") .append(" , KK1151.SVC_STAYMD ") .append(" , KK1151.SVC_CHRG_STAYMD ") .append(" , KK1151.SVC_KEI_STAT ") .append(" , KK1151.MSKMSHO_NO ") .append(" , KK1151.ID_TCHISHO_SYK_NO ") .append(" , KK1151.CUST_NM ") .append(" , KK1151.KEISHA_PCD ") .append(" , KK1151.KEISHA_STATE_NM ") .append(" , KK1151.KEISHA_CITY_NM ") .append(" , KK1151.KEISHA_OAZTSU_NM ") .append(" , KK1151.KEISHA_AZCHO_NM ") .append(" , KK1151.KEISHA_BNCHIGO ") .append(" , KK1151.KEISHA_ADRTTM ") .append(" , KK1151.KEISHA_ADRRM ") .append(" , KK1151.KEISHA_TYPE_CD ") .append(" , (SELECT ZM0171_06.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_06 ") .append(" WHERE ZM0171_06.CD_SBT_CD = 'CD00036' ") .append(" AND ZM0171_06.CD_DIV = KK1151.KEISHA_TYPE_CD ") .append(" AND ZM0171_06.MK_FLG = '0') AS KEISHA_TYPE_CD_NM ") .append(" , KK1151.KEISHA_TELNO ") .append(" , KK1151.LETTER_HASSO_SHIWAKE_DIV ") .append(" , (SELECT ZM0171_07.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_07 ") .append(" WHERE ZM0171_07.CD_SBT_CD = 'CD00344' ") .append(" AND ZM0171_07.CD_DIV = KK1151.LETTER_HASSO_SHIWAKE_DIV ") .append(" AND ZM0171_07.MK_FLG = '0') AS LETTER_HASSO_SHIWAKE_DIV_NM ") .append(" , KK1151.MSKM_UK_YMD ") .append(" , KK1151.MSKM_FORM_CD ") .append(" , (SELECT ZM0171_08.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_08 ") .append(" WHERE ZM0171_08.CD_SBT_CD = 'CD00591' ") .append(" AND ZM0171_08.CD_DIV = KK1151.MSKM_FORM_CD ") .append(" AND ZM0171_08.MK_FLG = '0') AS MSKM_FORM_CD_NM ") .append(" , KK1151.OLD_SVC_KEI_NO ") .append(" , KK1151.KEPCO_CUSTINFO_JUJU_DOI_UM ") .append(" , (SELECT ZM0171_09.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_09 ") .append(" WHERE ZM0171_09.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_09.CD_DIV = KK1151.KEPCO_CUSTINFO_JUJU_DOI_UM ") .append(" AND ZM0171_09.MK_FLG = '0') AS KEPCO_CUSTINFO_JUJU_DOI_UM_NM ") .append(" , KK1151.PAYWAY_KEIZOKU_FLG ") .append(" , (SELECT ZM0171_10.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_10 ") .append(" WHERE ZM0171_10.CD_SBT_CD = 'CD00046' ") .append(" AND ZM0171_10.CD_DIV = KK1151.PAYWAY_KEIZOKU_FLG ") .append(" AND ZM0171_10.MK_FLG = '0') AS PAYWAY_KEIZOKU_FLG_NM ") .append(" , KK1151.TA_SVC_ML_HKTGI_UM ") .append(" , (SELECT ZM0171_11.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_11 ") .append(" WHERE ZM0171_11.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_11.CD_DIV = KK1151.TA_SVC_ML_HKTGI_UM ") .append(" AND ZM0171_11.MK_FLG = '0') AS TA_SVC_ML_HKTGI_UM_NM ") .append(" , KK1151.PC_SETUP_UM ") .append(" , (SELECT ZM0171_12.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_12 ") .append(" WHERE ZM0171_12.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_12.CD_DIV = KK1151.PC_SETUP_UM ") .append(" AND ZM0171_12.MK_FLG = '0') AS PC_SETUP_UM_NM ") .append(" , KK1151.OMKSANSN_SET_MSKM_UM ") .append(" , (SELECT ZM0171_13.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_13 ") .append(" WHERE ZM0171_13.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_13.CD_DIV = KK1151.OMKSANSN_SET_MSKM_UM ") .append(" AND ZM0171_13.MK_FLG = '0') AS OMKSANSN_SET_MSKM_UM_NM ") .append(" , KK1151.EO_SPRT_PLUS_KANYU_UM ") .append(" , (SELECT ZM0171_14.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_14 ") .append(" WHERE ZM0171_14.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_14.CD_DIV = KK1151.EO_SPRT_PLUS_KANYU_UM ") .append(" AND ZM0171_14.MK_FLG = '0') AS EO_SPRT_PLUS_KANYU_UM_NM ") .append(" , KK1151.FAMIPA_KEI_UM ") .append(" , (SELECT ZM0171_15.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_15 ") .append(" WHERE ZM0171_15.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_15.CD_DIV = KK1151.FAMIPA_KEI_UM ") .append(" AND ZM0171_15.MK_FLG = '0') AS FAMIPA_KEI_UM_NM ") .append(" , KK1151.SEIKY_KEI_NO ") .append(" , KK1151.PAY_MSKMSHO_SOHU_YH ") .append(" , (SELECT ZM0171_16.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_16 ") .append(" WHERE ZM0171_16.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_16.CD_DIV = KK1151.PAY_MSKMSHO_SOHU_YH ") .append(" AND ZM0171_16.MK_FLG = '0') AS PAY_MSKMSHO_SOHU_YH_NM ") .append(" , KK1151.MANS_VDSLS_FLG ") .append(" , (SELECT ZM0171_17.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_17 ") .append(" WHERE ZM0171_17.CD_SBT_CD = 'CD00589' ") .append(" AND ZM0171_17.CD_DIV = KK1151.MANS_VDSLS_FLG ") .append(" AND ZM0171_17.MK_FLG = '0') AS MANS_VDSLS_FLG_NM ") .append(" , KK1151.MANS_TK_HOSHIKI_CD_1 ") .append(" , (SELECT ZM0171_18.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_18 ") .append(" WHERE ZM0171_18.CD_SBT_CD = 'CD01213' ") .append(" AND ZM0171_18.CD_DIV = KK1151.MANS_TK_HOSHIKI_CD_1 ") .append(" AND ZM0171_18.MK_FLG = '0') AS MANS_TK_HOSHIKI_CD_1_NM ") .append(" , KK1151.MANS_TK_HOSHIKI_CD_2 ") .append(" , (SELECT ZM0171_19.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_19 ") .append(" WHERE ZM0171_19.CD_SBT_CD = 'CD01213' ") .append(" AND ZM0171_19.CD_DIV = KK1151.MANS_TK_HOSHIKI_CD_2 ") .append(" AND ZM0171_19.MK_FLG = '0') AS MANS_TK_HOSHIKI_CD_2_NM ") .append(" , KK1151.KAISEN_PLACE_PCD ") .append(" , KK1151.KAISEN_PLACE_STATE_NM ") .append(" , KK1151.KAISEN_PLACE_CITY_NM ") .append(" , KK1151.KAISEN_PLACE_OAZTSU_NM ") .append(" , KK1151.KAISEN_PLACE_AZCHO_NM ") .append(" , KK1151.KAISEN_PLACE_BNCHIGO ") .append(" , KK1151.KAISEN_PLACE_ADRTTM ") .append(" , KK1151.KAISEN_PLACE_ADRRM ") .append(" , KK1151.KAISEN_PLACE_TELNO ") .append(" , KK1151.KISN_PLC_AD_MI_FIX_FLG ") .append(" , (SELECT ZM0171_20.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_20 ") .append(" WHERE ZM0171_20.CD_SBT_CD = 'CD00467' ") .append(" AND ZM0171_20.CD_DIV = KK1151.KISN_PLC_AD_MI_FIX_FLG ") .append(" AND ZM0171_20.MK_FLG = '0') AS KISN_PLC_AD_MI_FIX_FLG_NM ") .append(" , KK1151.TEL_MSKM_CNT ") .append(" , KK1151.KOPT_TELNO_1 ") .append(" , KK1151.BMP_UM_1 ") .append(" , (SELECT ZM0171_21.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_21 ") .append(" WHERE ZM0171_21.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_21.CD_DIV = KK1151.BMP_UM_1 ") .append(" AND ZM0171_21.MK_FLG = '0') AS BMP_UM_1_NM ") .append(" , KK1151.NTT_TELNO_1 ") .append(" , KK1151.HTB_TCHI_YH_1 ") .append(" , (SELECT ZM0171_22.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_22 ") .append(" WHERE ZM0171_22.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_22.CD_DIV = KK1151.HTB_TCHI_YH_1 ") .append(" AND ZM0171_22.MK_FLG = '0') AS HTB_TCHI_YH_1_NM ") .append(" , KK1151.N_104_YH_1 ") .append(" , (SELECT ZM0171_23.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_23 ") .append(" WHERE ZM0171_23.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_23.CD_DIV = KK1151.N_104_YH_1 ") .append(" AND ZM0171_23.MK_FLG = '0') AS N_104_YH_1_NM ") .append(" , KK1151.HELLOTOWN_KEISAI_YH_1 ") .append(" , (SELECT ZM0171_24.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_24 ") .append(" WHERE ZM0171_24.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_24.CD_DIV = KK1151.HELLOTOWN_KEISAI_YH_1 ") .append(" AND ZM0171_24.MK_FLG = '0') AS HELLOTOWN_KEISAI_YH_1_NM ") .append(" , KK1151.WARKMI_TEL_UM_1 ") .append(" , (SELECT ZM0171_25.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_25 ") .append(" WHERE ZM0171_25.CD_SBT_CD = 'CD01634' ") .append(" AND ZM0171_25.CD_DIV = KK1151.WARKMI_TEL_UM_1 ") .append(" AND ZM0171_25.MK_FLG = '0') AS WARKMI_TEL_UM_1_NM ") .append(" , KK1151.TENSO_TEL_UM_1 ") .append(" , (SELECT ZM0171_26.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_26 ") .append(" WHERE ZM0171_26.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_26.CD_DIV = KK1151.TENSO_TEL_UM_1 ") .append(" AND ZM0171_26.MK_FLG = '0') AS TENSO_TEL_UM_1_NM ") .append(" , KK1151.TENSO_TEL_CHOICE_UM_1 ") .append(" , (SELECT ZM0171_27.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_27 ") .append(" WHERE ZM0171_27.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_27.CD_DIV = KK1151.TENSO_TEL_CHOICE_UM_1 ") .append(" AND ZM0171_27.MK_FLG = '0') AS TENSO_TEL_CHOICE_UM_1_NM ") .append(" , KK1151.HITCHI_INCMHI_UM_1 ") .append(" , (SELECT ZM0171_28.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_28 ") .append(" WHERE ZM0171_28.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_28.CD_DIV = KK1151.HITCHI_INCMHI_UM_1 ") .append(" AND ZM0171_28.MK_FLG = '0') AS HITCHI_INCMHI_UM_1_NM ") .append(" , KK1151.MWKTEL_KYOHI_UM_1 ") .append(" , (SELECT ZM0171_29.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_29 ") .append(" WHERE ZM0171_29.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_29.CD_DIV = KK1151.MWKTEL_KYOHI_UM_1 ") .append(" AND ZM0171_29.MK_FLG = '0') AS MWKTEL_KYOHI_UM_1_NM ") .append(" , KK1151.STINO_INCOMING_CHOICE_UM_1 ") .append(" , (SELECT ZM0171_30.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_30 ") .append(" WHERE ZM0171_30.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_30.CD_DIV = KK1151.STINO_INCOMING_CHOICE_UM_1 ") .append(" AND ZM0171_30.MK_FLG = '0') AS STINO_INCOMING_CHOICE_UM_1_NM ") .append(" , KK1151.PCALL_DTL_SOHU_UM_1 ") .append(" , (SELECT ZM0171_31.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_31 ") .append(" WHERE ZM0171_31.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_31.CD_DIV = KK1151.PCALL_DTL_SOHU_UM_1 ") .append(" AND ZM0171_31.MK_FLG = '0') AS PCALL_DTL_SOHU_UM_1_NM ") .append(" , KK1151.N_050_NO_UM_1 ") .append(" , (SELECT ZM0171_32.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_32 ") .append(" WHERE ZM0171_32.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_32.CD_DIV = KK1151.N_050_NO_UM_1 ") .append(" AND ZM0171_32.MK_FLG = '0') AS N_050_NO_UM_1_NM ") .append(" , KK1151.HASINSHA_NO_TCH_UM_1 ") .append(" , (SELECT ZM0171_33.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_33 ") .append(" WHERE ZM0171_33.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_33.CD_DIV = KK1151.HASINSHA_NO_TCH_UM_1 ") .append(" AND ZM0171_33.MK_FLG = '0') AS HASINSHA_NO_TCH_UM_1_NM ") .append(" , KK1151.NTT_KEISHA_NM_1 ") .append(" , KK1151.NTT_KSH_KANA_1 ") .append(" , KK1151.NTT_KEISHA_PCD_1 ") .append(" , KK1151.NTT_KEISHA_STATE_NM_1 ") .append(" , KK1151.NTT_KEISHA_CITY_NM_1 ") .append(" , KK1151.NTT_KEISHA_OAZTSU_NM_1 ") .append(" , KK1151.NTT_KEISHA_AZCHO_NM_1 ") .append(" , KK1151.NTT_KEISHA_BNCHIGO_1 ") .append(" , KK1151.NTT_KEISHA_ADRTTM_1 ") .append(" , KK1151.NTT_KEISHA_ADRRM_1 ") .append(" , KK1151.TSJGS_CD_1 ") .append(" , KK1151.KOPT_TELNO_2 ") .append(" , KK1151.BMP_UM_2 ") .append(" , (SELECT ZM0171_34.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_34 ") .append(" WHERE ZM0171_34.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_34.CD_DIV = KK1151.BMP_UM_2 ") .append(" AND ZM0171_34.MK_FLG = '0') AS BMP_UM_2_NM ") .append(" , KK1151.NTT_TELNO_2 ") .append(" , KK1151.HTB_TCHI_YH_2 ") .append(" , (SELECT ZM0171_35.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_35 ") .append(" WHERE ZM0171_35.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_35.CD_DIV = KK1151.HTB_TCHI_YH_2 ") .append(" AND ZM0171_35.MK_FLG = '0') AS HTB_TCHI_YH_2_NM ") .append(" , KK1151.N_104_YH_2 ") .append(" , (SELECT ZM0171_36.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_36 ") .append(" WHERE ZM0171_36.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_36.CD_DIV = KK1151.N_104_YH_2 ") .append(" AND ZM0171_36.MK_FLG = '0') AS N_104_YH_2_NM ") .append(" , KK1151.HELLOTOWN_KEISAI_YH_2 ") .append(" , (SELECT ZM0171_37.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_37 ") .append(" WHERE ZM0171_37.CD_SBT_CD = 'CD00001' ") .append(" AND ZM0171_37.CD_DIV = KK1151.HELLOTOWN_KEISAI_YH_2 ") .append(" AND ZM0171_37.MK_FLG = '0') AS HELLOTOWN_KEISAI_YH_2_NM ") .append(" , KK1151.WARKMI_TEL_UM_2 ") .append(" , (SELECT ZM0171_38.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_38 ") .append(" WHERE ZM0171_38.CD_SBT_CD = 'CD01634' ") .append(" AND ZM0171_38.CD_DIV = KK1151.WARKMI_TEL_UM_2 ") .append(" AND ZM0171_38.MK_FLG = '0') AS WARKMI_TEL_UM_2_NM ") .append(" , KK1151.TENSO_TEL_UM_2 ") .append(" , (SELECT ZM0171_39.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_39 ") .append(" WHERE ZM0171_39.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_39.CD_DIV = KK1151.TENSO_TEL_UM_2 ") .append(" AND ZM0171_39.MK_FLG = '0') AS TENSO_TEL_UM_2_NM ") .append(" , KK1151.TENSO_TEL_CHOICE_UM_2 ") .append(" , (SELECT ZM0171_40.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_40 ") .append(" WHERE ZM0171_40.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_40.CD_DIV = KK1151.TENSO_TEL_CHOICE_UM_2 ") .append(" AND ZM0171_40.MK_FLG = '0') AS TENSO_TEL_CHOICE_UM_2_NM ") .append(" , KK1151.HITCHI_INCMHI_UM_2 ") .append(" , (SELECT ZM0171_41.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_41 ") .append(" WHERE ZM0171_41.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_41.CD_DIV = KK1151.HITCHI_INCMHI_UM_2 ") .append(" AND ZM0171_41.MK_FLG = '0') AS HITCHI_INCMHI_UM_2_NM ") .append(" , KK1151.MWKTEL_KYOHI_UM_2 ") .append(" , (SELECT ZM0171_42.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_42 ") .append(" WHERE ZM0171_42.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_42.CD_DIV = KK1151.MWKTEL_KYOHI_UM_2 ") .append(" AND ZM0171_42.MK_FLG = '0') AS MWKTEL_KYOHI_UM_2_NM ") .append(" , KK1151.STINO_INCOMING_CHOICE_UM_2 ") .append(" , (SELECT ZM0171_43.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_43 ") .append(" WHERE ZM0171_43.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_43.CD_DIV = KK1151.STINO_INCOMING_CHOICE_UM_2 ") .append(" AND ZM0171_43.MK_FLG = '0') AS STINO_INCOMING_CHOICE_UM_2_NM ") .append(" , KK1151.PCALL_DTL_SOHU_UM_2 ") .append(" , (SELECT ZM0171_44.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_44 ") .append(" WHERE ZM0171_44.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_44.CD_DIV = KK1151.PCALL_DTL_SOHU_UM_2 ") .append(" AND ZM0171_44.MK_FLG = '0') AS PCALL_DTL_SOHU_UM_2_NM ") .append(" , KK1151.N_050_NO_UM_2 ") .append(" , (SELECT ZM0171_45.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_45 ") .append(" WHERE ZM0171_45.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_45.CD_DIV = KK1151.N_050_NO_UM_2 ") .append(" AND ZM0171_45.MK_FLG = '0') AS N_050_NO_UM_2_NM ") .append(" , KK1151.HASINSHA_NO_TCH_UM_2 ") .append(" , (SELECT ZM0171_46.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_46 ") .append(" WHERE ZM0171_46.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_46.CD_DIV = KK1151.HASINSHA_NO_TCH_UM_2 ") .append(" AND ZM0171_46.MK_FLG = '0') AS HASINSHA_NO_TCH_UM_2_NM ") .append(" , KK1151.NTT_KEISHA_NM_2 ") .append(" , KK1151.NTT_KSH_KANA_2 ") .append(" , KK1151.NTT_KEISHA_PCD_2 ") .append(" , KK1151.NTT_KEISHA_STATE_NM_2 ") .append(" , KK1151.NTT_KEISHA_CITY_NM_2 ") .append(" , KK1151.NTT_KEISHA_OAZTSU_NM_2 ") .append(" , KK1151.NTT_KEISHA_AZCHO_NM_2 ") .append(" , KK1151.NTT_KEISHA_BNCHIGO_2 ") .append(" , KK1151.NTT_KEISHA_ADRTTM_2 ") .append(" , KK1151.NTT_KEISHA_ADRRM_2 ") .append(" , KK1151.TSJGS_CD_2 ") .append(" , KK1151.EO_BBR_TAKNKIKI_MODEL_CD ") .append(" , KK1151.EO_BBR_TK_SBT_CD ") .append(" , (SELECT ZM0171_47.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_47 ") .append(" WHERE ZM0171_47.CD_SBT_CD = 'CD00212' ") .append(" AND ZM0171_47.CD_DIV = KK1151.EO_BBR_TK_SBT_CD ") .append(" AND ZM0171_47.MK_FLG = '0') AS EO_BBR_TK_SBT_CD_NM ") .append(" , KK1151.EO_BBR_TK_WAY_CD ") .append(" , KK1151.PLC_TAKNKIKI_MODEL_CD_1 ") .append(" , KK1151.PLC_TK_SBT_CD_1 ") .append(" , (SELECT ZM0171_48.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_48 ") .append(" WHERE ZM0171_48.CD_SBT_CD = 'CD00212' ") .append(" AND ZM0171_48.CD_DIV = KK1151.PLC_TK_SBT_CD_1 ") .append(" AND ZM0171_48.MK_FLG = '0') AS PLC_TK_SBT_CD_1_NM ") .append(" , KK1151.PLC_CNT_1 ") .append(" , KK1151.PLC_TAKNKIKI_MODEL_CD_2 ") .append(" , KK1151.PLC_TK_SBT_CD_2 ") .append(" , (SELECT ZM0171_49.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_49 ") .append(" WHERE ZM0171_49.CD_SBT_CD = 'CD00212' ") .append(" AND ZM0171_49.CD_DIV = KK1151.PLC_TK_SBT_CD_2 ") .append(" AND ZM0171_49.MK_FLG = '0') AS PLC_TK_SBT_CD_2_NM ") .append(" , KK1151.PLC_CNT_2 ") .append(" , KK1151.PLC_TAKNKIKI_MODEL_CD_3 ") .append(" , KK1151.PLC_TK_SBT_CD_3 ") .append(" , (SELECT ZM0171_50.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_50 ") .append(" WHERE ZM0171_50.CD_SBT_CD = 'CD00212' ") .append(" AND ZM0171_50.CD_DIV = KK1151.PLC_TK_SBT_CD_3 ") .append(" AND ZM0171_50.MK_FLG = '0') AS PLC_TK_SBT_CD_3_NM ") .append(" , KK1151.PLC_CNT_3 ") .append(" , KK1151.PLC_TAKNKIKI_MODEL_CD_4 ") .append(" , KK1151.PLC_TK_SBT_CD_4 ") .append(" , (SELECT ZM0171_51.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_51 ") .append(" WHERE ZM0171_51.CD_SBT_CD = 'CD00212' ") .append(" AND ZM0171_51.CD_DIV = KK1151.PLC_TK_SBT_CD_4 ") .append(" AND ZM0171_51.MK_FLG = '0') AS PLC_TK_SBT_CD_4_NM ") .append(" , KK1151.PLC_CNT_4 ") .append(" , KK1151.PLC_TAKNKIKI_MODEL_CD_5 ") .append(" , KK1151.PLC_TK_SBT_CD_5 ") .append(" , (SELECT ZM0171_52.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_52 ") .append(" WHERE ZM0171_52.CD_SBT_CD = 'CD00212' ") .append(" AND ZM0171_52.CD_DIV = KK1151.PLC_TK_SBT_CD_5 ") .append(" AND ZM0171_52.MK_FLG = '0') AS PLC_TK_SBT_CD_5_NM ") .append(" , KK1151.PLC_CNT_5 ") .append(" , KK1151.STB_ADD_CNT ") .append(" , KK1151.STB_SBT_NM_1 ") .append(" , KK1151.TV_COURSE_NM_1 ") .append(" , KK1151.STB_SBT_CNT_1 ") .append(" , KK1151.STB_SBT_NM_2 ") .append(" , KK1151.TV_COURSE_NM_2 ") .append(" , KK1151.STB_SBT_CNT_2 ") .append(" , KK1151.STB_SBT_NM_3 ") .append(" , KK1151.TV_COURSE_NM_3 ") .append(" , KK1151.STB_SBT_CNT_3 ") .append(" , KK1151.STB_SBT_NM_4 ") .append(" , KK1151.TV_COURSE_NM_4 ") .append(" , KK1151.STB_SBT_CNT_4 ") .append(" , KK1151.STB_SBT_NM_5 ") .append(" , KK1151.TV_COURSE_NM_5 ") .append(" , KK1151.STB_SBT_CNT_5 ") .append(" , KK1151.CABLE_GUIDE_MSKM_CNT ") .append(" , KK1151.DMPS_ANKEN_NO ") .append(" , KK1151.STB_NON_MENU_FLG ") .append(" , (SELECT ZM0171_53.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_53 ") .append(" WHERE ZM0171_53.CD_SBT_CD = 'CD00015' ") .append(" AND ZM0171_53.CD_DIV = KK1151.STB_NON_MENU_FLG ") .append(" AND ZM0171_53.MK_FLG = '0') AS STB_NON_MENU_FLG_NM ") .append(" , KK1151.CMP_CD_1 ") .append(" , KK1151.CMP_CD_2 ") .append(" , KK1151.CMP_CD_3 ") .append(" , KK1151.CMP_CD_4 ") .append(" , KK1151.CMP_CD_5 ") .append(" , KK1151.KIKI_SOHUS_PCD ") .append(" , KK1151.KIKI_SOHUS_STATE_NM ") .append(" , KK1151.KIKI_SOHUS_CITY_NM ") .append(" , KK1151.KIKI_SOHUS_OAZTSU_NM ") .append(" , KK1151.KIKI_SOHUS_AZCHO_NM ") .append(" , KK1151.KIKI_SOHUS_BNCHIGO ") .append(" , KK1151.KIKI_SOHUS_ADRTTM ") .append(" , KK1151.KIKI_SOHUS_ADRRM ") .append(" , KK1151.KIKI_SOHUS_NM ") .append(" , KK1151.IDO_DIV ") .append(" , KK1151.ADD_DTM ") .append(" , KK1151.ADD_OPEACNT ") .append(" , KK1151.UPD_DTM ") .append(" , KK1151.UPD_OPEACNT ") .append(" , KK1151.DEL_DTM ") .append(" , KK1151.DEL_OPEACNT ") .append(" , KK1151.MK_FLG ") .append(" , (SELECT ZM0171_54.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_54 ") .append(" WHERE ZM0171_54.CD_SBT_CD = 'CD00016' ") .append(" AND ZM0171_54.CD_DIV = KK1151.MK_FLG ") .append(" AND ZM0171_54.MK_FLG = '0') AS MK_FLG_NM ") .append(" , KK1151.KEISHA_AD_CD ") .append(" , KK1151.KEISHA_AD_MAN_INPUT_FLG ") .append(" , (SELECT ZM0171_55.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_55 ") .append(" WHERE ZM0171_55.CD_SBT_CD = 'CD01239' ") .append(" AND ZM0171_55.CD_DIV = KK1151.KEISHA_AD_MAN_INPUT_FLG ") .append(" AND ZM0171_55.MK_FLG = '0') AS KEISHA_AD_MAN_INPUT_FLG_NM ") .append(" , KK1151.KAISEN_PLACE_AD_CD ") .append(" , KK1151.NTT_KEISHA_AD_CD_1 ") .append(" , KK1151.NKYS_AD_MAN_INPUT_FLG_1 ") .append(" , (SELECT ZM0171_56.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_56 ") .append(" WHERE ZM0171_56.CD_SBT_CD = 'CD01239' ") .append(" AND ZM0171_56.CD_DIV = KK1151.NKYS_AD_MAN_INPUT_FLG_1 ") .append(" AND ZM0171_56.MK_FLG = '0') AS NKYS_AD_MAN_INPUT_FLG_1_NM ") .append(" , KK1151.NTT_KEISHA_AD_CD_2 ") .append(" , KK1151.NKYS_AD_MAN_INPUT_FLG_2 ") .append(" , (SELECT ZM0171_57.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_57 ") .append(" WHERE ZM0171_57.CD_SBT_CD = 'CD01239' ") .append(" AND ZM0171_57.CD_DIV = KK1151.NKYS_AD_MAN_INPUT_FLG_2 ") .append(" AND ZM0171_57.MK_FLG = '0') AS NKYS_AD_MAN_INPUT_FLG_2_NM ") .append(" , KK1151.KIKI_SOHUS_AD_CD ") .append(" , KK1151.KIKI_SHS_AD_MAN_INPUT_FLG ") .append(" , (SELECT ZM0171_58.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_58 ") .append(" WHERE ZM0171_58.CD_SBT_CD = 'CD01239' ") .append(" AND ZM0171_58.CD_DIV = KK1151.KIKI_SHS_AD_MAN_INPUT_FLG ") .append(" AND ZM0171_58.MK_FLG = '0') AS KIKI_SHS_AD_MAN_INPUT_FLG_NM ") .append(" , KK1151.MOBILE_MODEL_CD ") .append(" , (SELECT ZM0171_59.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_59 ") .append(" WHERE ZM0171_59.CD_SBT_CD = 'CD01297' ") .append(" AND ZM0171_59.CD_DIV = KK1151.MOBILE_MODEL_CD ") .append(" AND ZM0171_59.MK_FLG = '0') AS MOBILE_MODEL_CD_NM ") .append(" , KK1151.PRC_GRP_CD ") .append(" , (SELECT KK0781.PRC_GRP_NM ") .append(" FROM KK_M_PRC_GRP KK0781 ") .append(" WHERE KK0781.PRC_GRP_CD = KK1151.PRC_GRP_CD ") .append(" AND (KK0781.PRC_GRP_CD, KK0781.RSV_APLY_YMD || KK0781.GENE_ADD_DTM) = ") .append(" (SELECT KK0781_GENE.PRC_GRP_CD, MAX(KK0781_GENE.RSV_APLY_YMD || KK0781_GENE.GENE_ADD_DTM) AS KK0781_MAX ") .append(" FROM KK_M_PRC_GRP KK0781_GENE ") .append(" WHERE KK0781_GENE.PRC_GRP_CD = KK0781.PRC_GRP_CD ") .append(" AND KK0781_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0781_GENE.MK_FLG= '0' ") .append(" GROUP BY KK0781_GENE.PRC_GRP_CD)) AS PRC_GRP_CD_NM ") .append(" , KK1151.PPLAN_CD ") .append(" , (SELECT KK0591.PPLAN_NM ") .append(" FROM KK_M_PPLAN KK0591 ") .append(" WHERE KK0591.PCRS_CD = KK1151.PCRS_CD ") .append(" AND KK0591.PPLAN_CD = KK1151.PPLAN_CD ") .append(" AND KK0591.MK_FLG= '0') AS PPLAN_CD_NM ") .append(" , KK1151.MANSION_BUKKEN_CD ") .append(" , (SELECT ZM0171_60.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_60 ") .append(" WHERE ZM0171_60.CD_SBT_CD = 'CD01228' ") .append(" AND ZM0171_60.CD_DIV = KK1151.MANSION_BUKKEN_CD ") .append(" AND ZM0171_60.MK_FLG = '0') AS MANSION_BUKKEN_CD_NM ") .append(" , (SELECT KK0751.SVC_NM ") .append(" FROM KK_M_SVC KK0751 ") .append(" WHERE KK0751.SVC_CD = KK1151.SVC_CD ") .append(" AND (KK0751.SVC_CD, KK0751.RSV_APLY_YMD || KK0751.GENE_ADD_DTM) = ") .append(" (SELECT KK0751_GENE.SVC_CD, MAX(KK0751_GENE.RSV_APLY_YMD || KK0751_GENE.GENE_ADD_DTM) AS KK0751_MAX ") .append(" FROM KK_M_SVC KK0751_GENE ") .append(" WHERE KK0751_GENE.SVC_CD = KK0751.SVC_CD ") .append(" AND KK0751_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0751_GENE.MK_FLG= '0' ") .append(" GROUP BY KK0751_GENE.SVC_CD)) AS SVC_CD_NM ") .append(" , (SELECT KK0791.PCRS_NM ") .append(" FROM KK_M_PCRS KK0791 ") .append(" WHERE KK0791.PCRS_CD = KK1151.PCRS_CD ") .append(" AND (KK0791.PCRS_CD, KK0791.RSV_APLY_YMD || KK0791.GENE_ADD_DTM) = ") .append(" (SELECT KK0791_GENE.PCRS_CD, MAX(KK0791_GENE.RSV_APLY_YMD || KK0791_GENE.GENE_ADD_DTM) AS KK0791_MAX ") .append(" FROM KK_M_PCRS KK0791_GENE ") .append(" WHERE KK0791_GENE.PCRS_CD = KK0791.PCRS_CD ") .append(" AND KK0791_GENE.RSV_APLY_YMD <= ? ") .append(" AND KK0791_GENE.MK_FLG= '0' ") .append(" GROUP BY KK0791_GENE.PCRS_CD)) AS PCRS_CD_NM ") .append(" , KK1151.CHOKZUWRI_MSKM_UM ") .append(" , (SELECT ZM0171_61.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_61 ") .append(" WHERE ZM0171_61.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_61.CD_DIV = KK1151.CHOKZUWRI_MSKM_UM ") .append(" AND ZM0171_61.MK_FLG = '0') AS CHOKZUWRI_MSKM_UM_NM ") .append(" , KK1151.CHOKZUWRI_AT_KEIZK_MSKM_UM ") .append(" , (SELECT ZM0171_62.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_62 ") .append(" WHERE ZM0171_62.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_62.CD_DIV = KK1151.CHOKZUWRI_AT_KEIZK_MSKM_UM ") .append(" AND ZM0171_62.MK_FLG = '0') AS CHOKZUWRI_AT_KEIZK_MSKM_UM_NM ") .append(" , KK1151.TEL_ADD_SBT_CD_1 ") .append(" , (SELECT ZM0171_63.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_63 ") .append(" WHERE ZM0171_63.CD_SBT_CD = 'CD01503' ") .append(" AND ZM0171_63.CD_DIV = KK1151.TEL_ADD_SBT_CD_1 ") .append(" AND ZM0171_63.MK_FLG = '0') AS TEL_ADD_SBT_CD_1_NM ") .append(" , KK1151.TEL_ADD_SBT_CD_2 ") .append(" , (SELECT ZM0171_64.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_64 ") .append(" WHERE ZM0171_64.CD_SBT_CD = 'CD01503' ") .append(" AND ZM0171_64.CD_DIV = KK1151.TEL_ADD_SBT_CD_2 ") .append(" AND ZM0171_64.MK_FLG = '0') AS TEL_ADD_SBT_CD_2_NM ") .append(" , KK1151.CUST_KANA ") .append(" , KK1151.TEL_SVKEIUW_SHOSA_ZM_FLG_1 ") .append(" , (SELECT ZM0171_65.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_65 ") .append(" WHERE ZM0171_65.CD_SBT_CD = 'CD00581' ") .append(" AND ZM0171_65.CD_DIV = KK1151.TEL_SVKEIUW_SHOSA_ZM_FLG_1 ") .append(" AND ZM0171_65.MK_FLG = '0') AS TEL_SVKEIUW_SHOSA_ZM_FLG_1_NM ") .append(" , KK1151.TEL_SVKEIUW_SHOSA_ZM_FLG_2 ") .append(" , (SELECT ZM0171_66.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_66 ") .append(" WHERE ZM0171_66.CD_SBT_CD = 'CD00581' ") .append(" AND ZM0171_66.CD_DIV = KK1151.TEL_SVKEIUW_SHOSA_ZM_FLG_2 ") .append(" AND ZM0171_66.MK_FLG = '0') AS TEL_SVKEIUW_SHOSA_ZM_FLG_2_NM ") .append(" , KK1151.PREMIUM_OP_MKM_UM ") .append(" , (SELECT ZM0171_67.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_67 ") .append(" WHERE ZM0171_67.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_67.CD_DIV = KK1151.PREMIUM_OP_MKM_UM ") .append(" AND ZM0171_67.MK_FLG = '0') AS PREMIUM_OP_MKM_UM_NM ") .append(" , KK1151.TABLET_TAKNKIKI_MODEL_CD ") .append(" , KK1151.TABLET_CRADLE_TKKKMDL_CD ") .append(" , KK1151.KAP_HAMBAI_FORM_CD ") .append(" , (SELECT ZM0171_68.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_68 ") .append(" WHERE ZM0171_68.CD_SBT_CD = 'CD01467' ") .append(" AND ZM0171_68.CD_DIV = KK1151.KAP_HAMBAI_FORM_CD ") .append(" AND ZM0171_68.MK_FLG = '0') AS KAP_HAMBAI_FORM_CD_NM ") .append(" , KK1151.KAP_PAY_CNT ") .append(" , KK1151.IPSTB_RENT_MSKM_UM ") .append(" , (SELECT ZM0171_69.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_69 ") .append(" WHERE ZM0171_69.CD_SBT_CD = 'CD00002' ") .append(" AND ZM0171_69.CD_DIV = KK1151.IPSTB_RENT_MSKM_UM ") .append(" AND ZM0171_69.MK_FLG = '0') AS IPSTB_RENT_MSKM_UM_NM ") .append(" , KK1151.TEL_OP_PACK_SKCD_1 ") .append(" , (SELECT ZM0171_70.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_70 ") .append(" WHERE ZM0171_70.CD_SBT_CD = 'CD01635' ") .append(" AND ZM0171_70.CD_DIV = KK1151.TEL_OP_PACK_SKCD_1 ") .append(" AND ZM0171_70.MK_FLG = '0') AS TEL_OP_PACK_SKCD_1_NM ") .append(" , KK1151.TEL_OP_PACK_SKCD_2 ") .append(" , (SELECT ZM0171_71.CD_DIV_NM ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_71 ") .append(" WHERE ZM0171_71.CD_SBT_CD = 'CD01635' ") .append(" AND ZM0171_71.CD_DIV = KK1151.TEL_OP_PACK_SKCD_2 ") .append(" AND ZM0171_71.MK_FLG = '0') AS TEL_OP_PACK_SKCD_2_NM ") .append(" FROM ") .append(" KK_T_KANUORESO_HAKKO KK1151 "); // SQL文_個別部1 if ( "1".equals( inMsg.getObject(EKK1151A010CBSMsg.FUNC_CODE).toString() ) ) { sql_Buff.append(" WHERE ") .append(" KK1151.KANUORESO_HAKKO_NO = ? ") .append(" AND KK1151.MK_FLG = '0' "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに指定された値を設定 if ( "1".equals( inMsg.getString(EKK1151A010CBSMsg.FUNC_CODE) ) ) { // パラメータの設定(運用年月日を指定) CAANJDBCUtil.setParam(pstmt, 1, JKKModelCommon.getOpeDate(inMsg)); // パラメータの設定(運用年月日を指定) CAANJDBCUtil.setParam(pstmt, 2, JKKModelCommon.getOpeDate(inMsg)); // パラメータの設定(運用年月日を指定) CAANJDBCUtil.setParam(pstmt, 3, JKKModelCommon.getOpeDate(inMsg)); // パラメータの設定(ＫＥＹ＿加入御礼書発行番号を指定) CAANJDBCUtil.setParam(pstmt, 4, inMsg.getObject(EKK1151A010CBSMsg.KEY_KANUORESO_HAKKO_NO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // EKK1151A010CBSMsgの明細にセットする項目 String[] msgKeyList1 = { EKK1151A010CBSMsg1List.KANUORESO_HAKKO_NO , EKK1151A010CBSMsg1List.KANUORE_DATA_SBT_CD , EKK1151A010CBSMsg1List.KANUORE_DATA_SBT_CD_NM , EKK1151A010CBSMsg1List.DATA_CHSHT_DTM , EKK1151A010CBSMsg1List.SEND_JGI_FLG , EKK1151A010CBSMsg1List.SEND_JGI_FLG_NM , EKK1151A010CBSMsg1List.SEND_DTM , EKK1151A010CBSMsg1List.SYSID , EKK1151A010CBSMsg1List.SAME_KAISEN_GRP_SKBT_NO , EKK1151A010CBSMsg1List.SVC_KEI_NO , EKK1151A010CBSMsg1List.NEW_ADD_SKBT_FLG , EKK1151A010CBSMsg1List.NEW_ADD_SKBT_FLG_NM , EKK1151A010CBSMsg1List.SKEKKA_CD , EKK1151A010CBSMsg1List.SKEKKA_CD_NM , EKK1151A010CBSMsg1List.LETTER_SBT_CD , EKK1151A010CBSMsg1List.LETTER_SBT_CD_NM , EKK1151A010CBSMsg1List.SEND_YO_SVC_NM , EKK1151A010CBSMsg1List.SEND_YO_PRC_COURSE_NM , EKK1151A010CBSMsg1List.DTAIL_SVC_NM , EKK1151A010CBSMsg1List.SVC_CD , EKK1151A010CBSMsg1List.PCRS_CD , EKK1151A010CBSMsg1List.SOKU_WARI_UM , EKK1151A010CBSMsg1List.SVC_STAYMD , EKK1151A010CBSMsg1List.SVC_CHRG_STAYMD , EKK1151A010CBSMsg1List.SVC_KEI_STAT , EKK1151A010CBSMsg1List.MSKMSHO_NO , EKK1151A010CBSMsg1List.ID_TCHISHO_SYK_NO , EKK1151A010CBSMsg1List.CUST_NM , EKK1151A010CBSMsg1List.KEISHA_PCD , EKK1151A010CBSMsg1List.KEISHA_STATE_NM , EKK1151A010CBSMsg1List.KEISHA_CITY_NM , EKK1151A010CBSMsg1List.KEISHA_OAZTSU_NM , EKK1151A010CBSMsg1List.KEISHA_AZCHO_NM , EKK1151A010CBSMsg1List.KEISHA_BNCHIGO , EKK1151A010CBSMsg1List.KEISHA_ADRTTM , EKK1151A010CBSMsg1List.KEISHA_ADRRM , EKK1151A010CBSMsg1List.KEISHA_TYPE_CD , EKK1151A010CBSMsg1List.KEISHA_TYPE_CD_NM , EKK1151A010CBSMsg1List.KEISHA_TELNO , EKK1151A010CBSMsg1List.LETTER_HASSO_SHIWAKE_DIV , EKK1151A010CBSMsg1List.LETTER_HASSO_SHIWAKE_DIV_NM , EKK1151A010CBSMsg1List.MSKM_UK_YMD , EKK1151A010CBSMsg1List.MSKM_FORM_CD , EKK1151A010CBSMsg1List.MSKM_FORM_CD_NM , EKK1151A010CBSMsg1List.OLD_SVC_KEI_NO , EKK1151A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM , EKK1151A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM_NM , EKK1151A010CBSMsg1List.PAYWAY_KEIZOKU_FLG , EKK1151A010CBSMsg1List.PAYWAY_KEIZOKU_FLG_NM , EKK1151A010CBSMsg1List.TA_SVC_ML_HKTGI_UM , EKK1151A010CBSMsg1List.TA_SVC_ML_HKTGI_UM_NM , EKK1151A010CBSMsg1List.PC_SETUP_UM , EKK1151A010CBSMsg1List.PC_SETUP_UM_NM , EKK1151A010CBSMsg1List.OMKSANSN_SET_MSKM_UM , EKK1151A010CBSMsg1List.OMKSANSN_SET_MSKM_UM_NM , EKK1151A010CBSMsg1List.EO_SPRT_PLUS_KANYU_UM , EKK1151A010CBSMsg1List.EO_SPRT_PLUS_KANYU_UM_NM , EKK1151A010CBSMsg1List.FAMIPA_KEI_UM , EKK1151A010CBSMsg1List.FAMIPA_KEI_UM_NM , EKK1151A010CBSMsg1List.SEIKY_KEI_NO , EKK1151A010CBSMsg1List.PAY_MSKMSHO_SOHU_YH , EKK1151A010CBSMsg1List.PAY_MSKMSHO_SOHU_YH_NM , EKK1151A010CBSMsg1List.MANS_VDSLS_FLG , EKK1151A010CBSMsg1List.MANS_VDSLS_FLG_NM , EKK1151A010CBSMsg1List.MANS_TK_HOSHIKI_CD_1 , EKK1151A010CBSMsg1List.MANS_TK_HOSHIKI_CD_1_NM , EKK1151A010CBSMsg1List.MANS_TK_HOSHIKI_CD_2 , EKK1151A010CBSMsg1List.MANS_TK_HOSHIKI_CD_2_NM , EKK1151A010CBSMsg1List.KAISEN_PLACE_PCD , EKK1151A010CBSMsg1List.KAISEN_PLACE_STATE_NM , EKK1151A010CBSMsg1List.KAISEN_PLACE_CITY_NM , EKK1151A010CBSMsg1List.KAISEN_PLACE_OAZTSU_NM , EKK1151A010CBSMsg1List.KAISEN_PLACE_AZCHO_NM , EKK1151A010CBSMsg1List.KAISEN_PLACE_BNCHIGO , EKK1151A010CBSMsg1List.KAISEN_PLACE_ADRTTM , EKK1151A010CBSMsg1List.KAISEN_PLACE_ADRRM , EKK1151A010CBSMsg1List.KAISEN_PLACE_TELNO , EKK1151A010CBSMsg1List.KISN_PLC_AD_MI_FIX_FLG , EKK1151A010CBSMsg1List.KISN_PLC_AD_MI_FIX_FLG_NM , EKK1151A010CBSMsg1List.TEL_MSKM_CNT , EKK1151A010CBSMsg1List.KOPT_TELNO_1 , EKK1151A010CBSMsg1List.BMP_UM_1 , EKK1151A010CBSMsg1List.BMP_UM_1_NM , EKK1151A010CBSMsg1List.NTT_TELNO_1 , EKK1151A010CBSMsg1List.HTB_TCHI_YH_1 , EKK1151A010CBSMsg1List.HTB_TCHI_YH_1_NM , EKK1151A010CBSMsg1List.N_104_YH_1 , EKK1151A010CBSMsg1List.N_104_YH_1_NM , EKK1151A010CBSMsg1List.HELLOTOWN_KEISAI_YH_1 , EKK1151A010CBSMsg1List.HELLOTOWN_KEISAI_YH_1_NM , EKK1151A010CBSMsg1List.WARKMI_TEL_UM_1 , EKK1151A010CBSMsg1List.WARKMI_TEL_UM_1_NM , EKK1151A010CBSMsg1List.TENSO_TEL_UM_1 , EKK1151A010CBSMsg1List.TENSO_TEL_UM_1_NM , EKK1151A010CBSMsg1List.TENSO_TEL_CHOICE_UM_1 , EKK1151A010CBSMsg1List.TENSO_TEL_CHOICE_UM_1_NM , EKK1151A010CBSMsg1List.HITCHI_INCMHI_UM_1 , EKK1151A010CBSMsg1List.HITCHI_INCMHI_UM_1_NM , EKK1151A010CBSMsg1List.MWKTEL_KYOHI_UM_1 , EKK1151A010CBSMsg1List.MWKTEL_KYOHI_UM_1_NM , EKK1151A010CBSMsg1List.STINO_INCOMING_CHOICE_UM_1 , EKK1151A010CBSMsg1List.STINO_INCOMING_CHOICE_UM_1_NM , EKK1151A010CBSMsg1List.PCALL_DTL_SOHU_UM_1 , EKK1151A010CBSMsg1List.PCALL_DTL_SOHU_UM_1_NM , EKK1151A010CBSMsg1List.N_050_NO_UM_1 , EKK1151A010CBSMsg1List.N_050_NO_UM_1_NM , EKK1151A010CBSMsg1List.HASINSHA_NO_TCH_UM_1 , EKK1151A010CBSMsg1List.HASINSHA_NO_TCH_UM_1_NM , EKK1151A010CBSMsg1List.NTT_KEISHA_NM_1 , EKK1151A010CBSMsg1List.NTT_KSH_KANA_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_PCD_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_STATE_NM_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_CITY_NM_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_OAZTSU_NM_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_AZCHO_NM_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_BNCHIGO_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_ADRTTM_1 , EKK1151A010CBSMsg1List.NTT_KEISHA_ADRRM_1 , EKK1151A010CBSMsg1List.TSJGS_CD_1 , EKK1151A010CBSMsg1List.KOPT_TELNO_2 , EKK1151A010CBSMsg1List.BMP_UM_2 , EKK1151A010CBSMsg1List.BMP_UM_2_NM , EKK1151A010CBSMsg1List.NTT_TELNO_2 , EKK1151A010CBSMsg1List.HTB_TCHI_YH_2 , EKK1151A010CBSMsg1List.HTB_TCHI_YH_2_NM , EKK1151A010CBSMsg1List.N_104_YH_2 , EKK1151A010CBSMsg1List.N_104_YH_2_NM , EKK1151A010CBSMsg1List.HELLOTOWN_KEISAI_YH_2 , EKK1151A010CBSMsg1List.HELLOTOWN_KEISAI_YH_2_NM , EKK1151A010CBSMsg1List.WARKMI_TEL_UM_2 , EKK1151A010CBSMsg1List.WARKMI_TEL_UM_2_NM , EKK1151A010CBSMsg1List.TENSO_TEL_UM_2 , EKK1151A010CBSMsg1List.TENSO_TEL_UM_2_NM , EKK1151A010CBSMsg1List.TENSO_TEL_CHOICE_UM_2 , EKK1151A010CBSMsg1List.TENSO_TEL_CHOICE_UM_2_NM , EKK1151A010CBSMsg1List.HITCHI_INCMHI_UM_2 , EKK1151A010CBSMsg1List.HITCHI_INCMHI_UM_2_NM , EKK1151A010CBSMsg1List.MWKTEL_KYOHI_UM_2 , EKK1151A010CBSMsg1List.MWKTEL_KYOHI_UM_2_NM , EKK1151A010CBSMsg1List.STINO_INCOMING_CHOICE_UM_2 , EKK1151A010CBSMsg1List.STINO_INCOMING_CHOICE_UM_2_NM , EKK1151A010CBSMsg1List.PCALL_DTL_SOHU_UM_2 , EKK1151A010CBSMsg1List.PCALL_DTL_SOHU_UM_2_NM , EKK1151A010CBSMsg1List.N_050_NO_UM_2 , EKK1151A010CBSMsg1List.N_050_NO_UM_2_NM , EKK1151A010CBSMsg1List.HASINSHA_NO_TCH_UM_2 , EKK1151A010CBSMsg1List.HASINSHA_NO_TCH_UM_2_NM , EKK1151A010CBSMsg1List.NTT_KEISHA_NM_2 , EKK1151A010CBSMsg1List.NTT_KSH_KANA_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_PCD_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_STATE_NM_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_CITY_NM_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_OAZTSU_NM_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_AZCHO_NM_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_BNCHIGO_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_ADRTTM_2 , EKK1151A010CBSMsg1List.NTT_KEISHA_ADRRM_2 , EKK1151A010CBSMsg1List.TSJGS_CD_2 , EKK1151A010CBSMsg1List.EO_BBR_TAKNKIKI_MODEL_CD , EKK1151A010CBSMsg1List.EO_BBR_TK_SBT_CD , EKK1151A010CBSMsg1List.EO_BBR_TK_SBT_CD_NM , EKK1151A010CBSMsg1List.EO_BBR_TK_WAY_CD , EKK1151A010CBSMsg1List.PLC_TAKNKIKI_MODEL_CD_1 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_1 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_1_NM , EKK1151A010CBSMsg1List.PLC_CNT_1 , EKK1151A010CBSMsg1List.PLC_TAKNKIKI_MODEL_CD_2 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_2 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_2_NM , EKK1151A010CBSMsg1List.PLC_CNT_2 , EKK1151A010CBSMsg1List.PLC_TAKNKIKI_MODEL_CD_3 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_3 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_3_NM , EKK1151A010CBSMsg1List.PLC_CNT_3 , EKK1151A010CBSMsg1List.PLC_TAKNKIKI_MODEL_CD_4 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_4 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_4_NM , EKK1151A010CBSMsg1List.PLC_CNT_4 , EKK1151A010CBSMsg1List.PLC_TAKNKIKI_MODEL_CD_5 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_5 , EKK1151A010CBSMsg1List.PLC_TK_SBT_CD_5_NM , EKK1151A010CBSMsg1List.PLC_CNT_5 , EKK1151A010CBSMsg1List.STB_ADD_CNT , EKK1151A010CBSMsg1List.STB_SBT_NM_1 , EKK1151A010CBSMsg1List.TV_COURSE_NM_1 , EKK1151A010CBSMsg1List.STB_SBT_CNT_1 , EKK1151A010CBSMsg1List.STB_SBT_NM_2 , EKK1151A010CBSMsg1List.TV_COURSE_NM_2 , EKK1151A010CBSMsg1List.STB_SBT_CNT_2 , EKK1151A010CBSMsg1List.STB_SBT_NM_3 , EKK1151A010CBSMsg1List.TV_COURSE_NM_3 , EKK1151A010CBSMsg1List.STB_SBT_CNT_3 , EKK1151A010CBSMsg1List.STB_SBT_NM_4 , EKK1151A010CBSMsg1List.TV_COURSE_NM_4 , EKK1151A010CBSMsg1List.STB_SBT_CNT_4 , EKK1151A010CBSMsg1List.STB_SBT_NM_5 , EKK1151A010CBSMsg1List.TV_COURSE_NM_5 , EKK1151A010CBSMsg1List.STB_SBT_CNT_5 , EKK1151A010CBSMsg1List.CABLE_GUIDE_MSKM_CNT , EKK1151A010CBSMsg1List.DMPS_ANKEN_NO , EKK1151A010CBSMsg1List.STB_NON_MENU_FLG , EKK1151A010CBSMsg1List.STB_NON_MENU_FLG_NM , EKK1151A010CBSMsg1List.CMP_CD_1 , EKK1151A010CBSMsg1List.CMP_CD_2 , EKK1151A010CBSMsg1List.CMP_CD_3 , EKK1151A010CBSMsg1List.CMP_CD_4 , EKK1151A010CBSMsg1List.CMP_CD_5 , EKK1151A010CBSMsg1List.KIKI_SOHUS_PCD , EKK1151A010CBSMsg1List.KIKI_SOHUS_STATE_NM , EKK1151A010CBSMsg1List.KIKI_SOHUS_CITY_NM , EKK1151A010CBSMsg1List.KIKI_SOHUS_OAZTSU_NM , EKK1151A010CBSMsg1List.KIKI_SOHUS_AZCHO_NM , EKK1151A010CBSMsg1List.KIKI_SOHUS_BNCHIGO , EKK1151A010CBSMsg1List.KIKI_SOHUS_ADRTTM , EKK1151A010CBSMsg1List.KIKI_SOHUS_ADRRM , EKK1151A010CBSMsg1List.KIKI_SOHUS_NM , EKK1151A010CBSMsg1List.IDO_DIV , EKK1151A010CBSMsg1List.ADD_DTM , EKK1151A010CBSMsg1List.ADD_OPEACNT , EKK1151A010CBSMsg1List.UPD_DTM , EKK1151A010CBSMsg1List.UPD_OPEACNT , EKK1151A010CBSMsg1List.DEL_DTM , EKK1151A010CBSMsg1List.DEL_OPEACNT , EKK1151A010CBSMsg1List.MK_FLG , EKK1151A010CBSMsg1List.MK_FLG_NM , EKK1151A010CBSMsg1List.KEISHA_AD_CD , EKK1151A010CBSMsg1List.KEISHA_AD_MAN_INPUT_FLG , EKK1151A010CBSMsg1List.KEISHA_AD_MAN_INPUT_FLG_NM , EKK1151A010CBSMsg1List.KAISEN_PLACE_AD_CD , EKK1151A010CBSMsg1List.NTT_KEISHA_AD_CD_1 , EKK1151A010CBSMsg1List.NKYS_AD_MAN_INPUT_FLG_1 , EKK1151A010CBSMsg1List.NKYS_AD_MAN_INPUT_FLG_1_NM , EKK1151A010CBSMsg1List.NTT_KEISHA_AD_CD_2 , EKK1151A010CBSMsg1List.NKYS_AD_MAN_INPUT_FLG_2 , EKK1151A010CBSMsg1List.NKYS_AD_MAN_INPUT_FLG_2_NM , EKK1151A010CBSMsg1List.KIKI_SOHUS_AD_CD , EKK1151A010CBSMsg1List.KIKI_SHS_AD_MAN_INPUT_FLG , EKK1151A010CBSMsg1List.KIKI_SHS_AD_MAN_INPUT_FLG_NM , EKK1151A010CBSMsg1List.MOBILE_MODEL_CD , EKK1151A010CBSMsg1List.MOBILE_MODEL_CD_NM , EKK1151A010CBSMsg1List.PRC_GRP_CD , EKK1151A010CBSMsg1List.PRC_GRP_CD_NM , EKK1151A010CBSMsg1List.PPLAN_CD , EKK1151A010CBSMsg1List.PPLAN_CD_NM , EKK1151A010CBSMsg1List.MANSION_BUKKEN_CD , EKK1151A010CBSMsg1List.MANSION_BUKKEN_CD_NM , EKK1151A010CBSMsg1List.SVC_CD_NM , EKK1151A010CBSMsg1List.PCRS_CD_NM , EKK1151A010CBSMsg1List.CHOKZUWRI_MSKM_UM , EKK1151A010CBSMsg1List.CHOKZUWRI_MSKM_UM_NM , EKK1151A010CBSMsg1List.CHOKZUWRI_AT_KEIZK_MSKM_UM , EKK1151A010CBSMsg1List.CHOKZUWRI_AT_KEIZK_MSKM_UM_NM , EKK1151A010CBSMsg1List.TEL_ADD_SBT_CD_1 , EKK1151A010CBSMsg1List.TEL_ADD_SBT_CD_1_NM , EKK1151A010CBSMsg1List.TEL_ADD_SBT_CD_2 , EKK1151A010CBSMsg1List.TEL_ADD_SBT_CD_2_NM , EKK1151A010CBSMsg1List.CUST_KANA , EKK1151A010CBSMsg1List.TEL_SVKEIUW_SHOSA_ZM_FLG_1 , EKK1151A010CBSMsg1List.TEL_SVKEIUW_SHOSA_ZM_FLG_1_NM , EKK1151A010CBSMsg1List.TEL_SVKEIUW_SHOSA_ZM_FLG_2 , EKK1151A010CBSMsg1List.TEL_SVKEIUW_SHOSA_ZM_FLG_2_NM , EKK1151A010CBSMsg1List.PREMIUM_OP_MKM_UM , EKK1151A010CBSMsg1List.PREMIUM_OP_MKM_UM_NM , EKK1151A010CBSMsg1List.TABLET_TAKNKIKI_MODEL_CD , EKK1151A010CBSMsg1List.TABLET_CRADLE_TKKKMDL_CD , EKK1151A010CBSMsg1List.KAP_HAMBAI_FORM_CD , EKK1151A010CBSMsg1List.KAP_HAMBAI_FORM_CD_NM , EKK1151A010CBSMsg1List.KAP_PAY_CNT , EKK1151A010CBSMsg1List.IPSTB_RENT_MSKM_UM , EKK1151A010CBSMsg1List.IPSTB_RENT_MSKM_UM_NM , EKK1151A010CBSMsg1List.TEL_OP_PACK_SKCD_1 , EKK1151A010CBSMsg1List.TEL_OP_PACK_SKCD_1_NM , EKK1151A010CBSMsg1List.TEL_OP_PACK_SKCD_2 , EKK1151A010CBSMsg1List.TEL_OP_PACK_SKCD_2_NM }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK1151A010CBSMsg1List",0); // inMsg(CBSMsg)に明細をセット inMsg.set("EKK1151A010CBSMsg1List", outMsg1); } catch(SQLException e) { inMsg.set(EKK1151A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } finally { // 資源の解放 try{ if(rsltQuery != null){ rsltQuery.close(); } if(pstmt != null){ pstmt.close(); } if(con1 != null){ closeConnection(con1); } }catch(SQLException e){ inMsg.set(EKK1151A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }