/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEKK0021B502TPDA
* ソースファイル名：JSYejbEKK0021B502TPDA.java
* 作成者 ：EK911940
* 日付 ：2012年11月15日
*＜機能概要＞
* 照査前申込明細＜eo光ネット＞一覧照会テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* ｖ31.00.00 2017/12/05 FJ) 麻生 【ANK-3136-00-00】OPMSハードウエア保守切れ対応(STEP2-2)
* ｖ56.00.00 2021/12/14 FJ) 杉本 【ANK-4174-00-00】開通前マイページ関連業務改善（2022年1月下旬リリース）
* ｖ57.00.00 2021/02/04 FJ) 吉村 【ANK-4088-00-00】宅内調査の日程調整業務における省人化施策(Step2)
* ｖ71.00.09 2024/04/01 FJ) 森下 【ANK-4468-09-00】eo光ネット「シンプルプラン」追加対応 仕変9
* ｖ73.00.00 2024/10/23 FJ) 舘山 【ANK-4427-00-00】NTT卸対応
* ｖ73.00.00 2024/10/23 FJ) 吉田あ 【ANK-4427-00-00】NTT卸対応
* ｖ75.00.00 2025/02/19 FJ) 寺田 【ANK-4640-00-00】typeN：追加要件対応
********************************************************************************/
package eo.ejb.cbs.sqlf;
import com.fujitsu.futurity.model.base.CAANMsg;
import com.fujitsu.futurity.model.base.CAANSQLFacility;
import com.fujitsu.futurity.model.base.CAANRuntimeException;
import com.fujitsu.futurity.model.base.CAANJDBCUtil;
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.TemplateDBAccessHandler;
import com.fujitsu.futurity.model.ejb.common.fw.AgentDispatchContext;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import eo.ejb.cbs.cbsmsg.EKK0021B502CBSMsg;
import eo.ejb.cbs.cbsmsg.EKK0021B502CBSMsg1List;
import eo.ejb.cbm.entity.KK0021ETMsg;
import eo.ejb.common.db.JKKejbExclusiveProcKK0011;
import eo.ejb.common.db.JKKejbExclusiveProcKK0161;
import eo.ejb.common.db.JKKejbExclusiveProcKK2111;
/**
*
* テンプレートDBアクセス部品 EKK0021B502_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEKK0021B502TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEKK0021B502TPDA() {
}
/**
* EKK0021B502_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(KK0021ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" KK0021.MSKM_DTL_NO AS MSKM_DTL_NO1, ")
.append(" KK0021.GENE_ADD_DTM AS GENE_ADD_DTM1, ")
.append(" KK0021.MSKM_DTL_STAT AS MSKM_DTL_STAT1, ")
.append(" KK0021.MSKM_NO AS MSKM_NO1, ")
.append(" KK0021.MSKMSHO_NO AS MSKMSHO_NO1, ")
.append(" KK0021.MSKMSHO_DTL_NO AS MSKMSHO_DTL_NO1, ")
.append(" KK0021.MSKM_YMD AS MSKM_YMD1, ")
.append(" KK0021.SYSID AS SYSID1, ")
.append(" KK0021.WEB_UK_NO AS WEB_UK_NO1, ")
.append(" KK0021.MSKM_FORM_CD AS MSKM_FORM_CD1, ")
.append(" KK0021.MSKM_DTL_SBT_CD AS MSKM_DTL_SBT_CD1, ")
.append(" KK0021.RRKS_KTAI_TELNO AS RRKS_KTAI_TELNO1, ")
.append(" KK0021.RRKS_OFFC_NM AS RRKS_OFFC_NM1, ")
.append(" KK0021.DT_RRKS_TELNO AS DT_RRKS_TELNO1, ")
.append(" KK0021.NEW_MSKM_SBT_CD AS NEW_MSKM_SBT_CD1, ")
.append(" KK0021.MSKM_OPTNTY_CD AS MSKM_OPTNTY_CD1, ")
.append(" KK0021.TAKCHO_KIBO_APO_KIGEN_YMD AS TAKCHO_KIBO_APO_KIGEN_YMD1, ")
.append(" KK0021.KOJI_APO_RRKS_SHITEI_CD AS KOJI_APO_RRKS_SHITEI_CD1, ")
.append(" KK0021.KOJI_APO_RRKS_TELNO AS KOJI_APO_RRKS_TELNO1, ")
.append(" KK0021.RRK_JIKO_ADD_DTM AS RRK_JIKO_ADD_DTM1, ")
.append(" KK0021.MSKM_DTL_SHOSA_DTM AS MSKM_DTL_SHOSA_DTM1, ")
.append(" KK0021.MSKM_DTL_SHOSA_CL_YMD AS MSKM_DTL_SHOSA_CL_YMD1, ")
.append(" KK0021.KZKWRK_REQYMD AS KZKWRK_REQYMD1, ")
.append(" KK0021.MSKM_DTL_CANCEL_YMD AS MSKM_DTL_CANCEL_YMD1, ")
.append(" KK0021.MSKM_DTL_CANCEL_RSN_CD AS MSKM_DTL_CANCEL_RSN_CD1, ")
.append(" KK0021.MSKM_DTL_CANCEL_RSN_MEMO AS MSKM_DTL_CANCEL_RSN_MEMO1, ")
.append(" KK0021.MSKM_DTL_CANCEL_CL_YMD AS MSKM_DTL_CANCEL_CL_YMD1, ")
.append(" KK0021.MSKM_RRKS_MLAD AS MSKM_RRKS_MLAD1, ")
.append(" KK0021.KOJI_PRG_TCHI_MLAD AS KOJI_PRG_TCHI_MLAD1, ")
.append(" KK0021.RRK_JIKO AS RRK_JIKO1, ")
.append(" KK0021.RCNT_SHOKAI_YMD AS RCNT_SHOKAI_YMD1, ")
.append(" KK0021.WEB_SHOKAI_CNT AS WEB_SHOKAI_CNT1, ")
.append(" KK0021.PC_SHOKAI_CNT AS PC_SHOKAI_CNT1, ")
.append(" KK0021.KTAI_SHOKAI_CNT AS KTAI_SHOKAI_CNT1, ")
.append(" KK0021.KJSC_TCH_KTAI_MLAD AS KJSC_TCH_KTAI_MLAD1, ")
.append(" KK0021.KJSC_TCH_PC_MLAD_CHG_YMD AS KJSC_TCH_PC_MLAD_CHG_YMD1, ")
.append(" KK0021.KJSC_TCH_KTAI_MLAD_CHG_YMD AS KJSC_TCH_KTAI_MLAD_CHG_YMD1, ")
.append(" KK0021.PRG_ML_LAST_SEND_DTM AS PRG_ML_LAST_SEND_DTM1, ")
.append(" KK0021.ML_SEND_JGI_FLG AS ML_SEND_JGI_FLG1, ")
.append(" KK0021.ML_SEND_JGI_RSN_MEMO AS ML_SEND_JGI_RSN_MEMO1, ")
.append(" KK0021.BMP_MSKM_RRKS_TLN AS BMP_MSKM_RRKS_TLN1, ")
.append(" KK0021.OP_SVC_HKTGI_UM AS OP_SVC_HKTGI_UM1, ")
.append(" KK0021.DSL_ATICLE_SOHU_KIBO_UM AS DSL_ATICLE_SOHU_KIBO_UM1, ")
.append(" KK0021.RRK_WAY_HOKI AS RRK_WAY_HOKI1, ")
.append(" KK0021.NEWCONST_BUKKEN_CD AS NEWCONST_BUKKEN_CD1, ")
.append(" KK0021.HUKKAT_ANKEN_FLG AS HUKKAT_ANKEN_FLG1, ")
.append(" KK0021.SAME_EQUIP_RE_MSKM_CD AS SAME_EQUIP_RE_MSKM_CD1, ")
.append(" KK0021.HNIN_CFM_ATICLE_SBT_CD AS HNIN_CFM_ATICLE_SBT_CD1, ")
.append(" KK0021.MSKMSHO_SBT_CD AS MSKMSHO_SBT_CD1, ")
.append(" KK0021.MAP_TEMP_UM AS MAP_TEMP_UM1, ")
.append(" KK0021.KCN_STB_MSKM_CNT AS KCN_STB_MSKM_CNT1, ")
.append(" KK0021.KCN_STB_KIND_CD AS KCN_STB_KIND_CD1, ")
.append(" NULL AS LAST_UPD_DTM1, ")
.append(" KK0081.SVC_KEI_NO AS SVC_KEI_NO2, ")
.append(" KK0081.GENE_ADD_DTM AS GENE_ADD_DTM2, ")
.append(" KK0081.SVC_KEI_STAT AS SVC_KEI_STAT2, ")
.append(" KK0081.SYSID AS SYSID2, ")
.append(" KK0081.SVC_CD AS SVC_CD2, ")
.append(" KK0081.MSKM_DTL_NO AS MSKM_DTL_NO2, ")
.append(" KK0081.MENKAIHAT_ANKEN_NO AS MENKAIHAT_ANKEN_NO2, ")
.append(" KK0081.PRC_GRP_CD AS PRC_GRP_CD2, ")
.append(" KK0081.PCRS_CD AS PCRS_CD2, ")
.append(" KK0081.PPLAN_CD AS PPLAN_CD2, ")
.append(" KK0081.TK_HOSHIKI_KEI_NO AS TK_HOSHIKI_KEI_NO2, ")
.append(" KK0081.SVC_USE_STA_KIBO_YMD AS SVC_USE_STA_KIBO_YMD2, ")
.append(" KK0081.RSV_TSTA_KIBO_YMD AS RSV_TSTA_KIBO_YMD2, ")
.append(" KK0081.ID_SOKHOSHO_OUTPUT_YH AS ID_SOKHOSHO_OUTPUT_YH2, ")
.append(" KK0081.SVC_KEI_KZKWRK_REQYMD AS SVC_KEI_KZKWRK_REQYMD2, ")
.append(" KK0081.SHOSA_YMD AS SHOSA_YMD2, ")
.append(" KK0081.SHOSA_CL_YMD AS SHOSA_CL_YMD2, ")
.append(" KK0081.SKEKKA_CD AS SKEKKA_CD2, ")
.append(" (SELECT ")
.append(" ZM0171_13.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_13 ")
.append(" WHERE ")
.append(" ZM0171_13.CD_SBT_CD = 'CD00281' AND ")
.append(" ZM0171_13.CD_DIV = KK0081.SKEKKA_CD AND ")
.append(" ZM0171_13.CD_TSTAYMD <= ? AND ")
.append(" ZM0171_13.MK_FLG = '0' ")
.append(" ) AS SKEKKA_CD_NM2, ")
.append(" KK0081.SKEKKA_DTL_CD AS SKEKKA_DTL_CD2, ")
.append(" KK0081.SKEKKA_HOKI_CD AS SKEKKA_HOKI_CD2, ")
.append(" KK0081.SKEKKA_SEND_CD AS SKEKKA_SEND_CD2, ")
.append(" KK0081.PAYWAY_KEIZOKU_FLG AS PAYWAY_KEIZOKU_FLG2, ")
.append(" KK0081.FTRIAL_KANYU_YMD AS FTRIAL_KANYU_YMD2, ")
.append(" KK0081.FTRIAL_PRD_ENDYMD AS FTRIAL_PRD_ENDYMD2, ")
.append(" KK0081.HONKANYU_YMD AS HONKANYU_YMD2, ")
.append(" KK0081.HONKANYU_IKO_KIGEN_YMD AS HONKANYU_IKO_KIGEN_YMD2, ")
.append(" KK0081.KEI_CNC_YMD AS KEI_CNC_YMD2, ")
.append(" KK0081.PLAN_STAYMD AS PLAN_STAYMD2, ")
.append(" KK0081.PLAN_ENDYMD AS PLAN_ENDYMD2, ")
.append(" KK0081.PLAN_CHRG_STAYMD AS PLAN_CHRG_STAYMD2, ")
.append(" KK0081.PLAN_CHRG_ENDYMD AS PLAN_CHRG_ENDYMD2, ")
.append(" KK0081.PLAN_END_SBT_CD AS PLAN_END_SBT_CD2, ")
.append(" KK0081.RSV_APLY_YMD AS RSV_APLY_YMD2, ")
.append(" KK0081.RSV_CL_YMD AS RSV_CL_YMD2, ")
.append(" KK0081.RSV_APLY_CD AS RSV_APLY_CD2, ")
.append(" KK0081.SVC_CANCEL_YMD AS SVC_CANCEL_YMD2, ")
.append(" KK0081.SVC_CANCEL_RSN_CD AS SVC_CANCEL_RSN_CD2, ")
.append(" KK0081.SVC_STA_YMD AS SVC_STA_YMD2, ")
.append(" KK0081.SVC_CHRG_STAYMD AS SVC_CHRG_STAYMD2, ")
.append(" KK0081.LETTER_HASSO_SHIWAKE_DIV AS LETTER_HASSO_SHIWAKE_DIV2, ")
.append(" KK0081.THNX_LETTER_SHS_CD AS THNX_LETTER_SHS_CD2, ")
.append(" KK0081.WEB_OP_ADD_FAIL_FLG AS WEB_OP_ADD_FAIL_FLG2, ")
.append(" KK0081.SVC_STP_YMD AS SVC_STP_YMD2, ")
.append(" KK0081.SVC_STP_RSN_CD AS SVC_STP_RSN_CD2, ")
.append(" KK0081.SVC_STP_RLS_YMD AS SVC_STP_RLS_YMD2, ")
.append(" KK0081.SVC_STP_RLS_RSN_CD AS SVC_STP_RLS_RSN_CD2, ")
.append(" KK0081.PAUSE_STP_CD AS PAUSE_STP_CD2, ")
.append(" KK0081.SVC_PAUSE_YMD AS SVC_PAUSE_YMD2, ")
.append(" KK0081.SVC_PAUSE_RSN_CD AS SVC_PAUSE_RSN_CD2, ")
.append(" KK0081.SVC_PAUSE_RSN_MEMO AS SVC_PAUSE_RSN_MEMO2, ")
.append(" KK0081.SVC_PAUSE_RLS_YMD AS SVC_PAUSE_RLS_YMD2, ")
.append(" KK0081.SVC_PAUSE_RLS_RSN_CD AS SVC_PAUSE_RLS_RSN_CD2, ")
.append(" KK0081.SVC_PAUSE_RLS_RSN_MEMO AS SVC_PAUSE_RLS_RSN_MEMO2, ")
.append(" KK0081.SVC_ENDYMD AS SVC_ENDYMD2, ")
.append(" KK0081.SVC_CHRG_ENDYMD AS SVC_CHRG_ENDYMD2, ")
.append(" KK0081.SVC_DSL_YMD AS SVC_DSL_YMD2, ")
.append(" KK0081.SVC_DLRE_CD AS SVC_DLRE_CD2, ")
.append(" KK0081.SVC_DLRE_MEMO AS SVC_DLRE_MEMO2, ")
.append(" KK0081.SVC_DSL_TTDKI_FIN_FLG AS SVC_DSL_TTDKI_FIN_FLG2, ")
.append(" KK0081.KAIHK_YMD AS KAIHK_YMD2, ")
.append(" KK0081.SVC_CANCEL_CL_YMD AS SVC_CANCEL_CL_YMD2, ")
.append(" KK0081.SVC_DSL_CL_YMD AS SVC_DSL_CL_YMD2, ")
.append(" KK0081.CHGE_MT_HOJINSVKEI_UK_NO AS CHGE_MT_HOJINSVKEI_UK_NO2, ")
.append(" KK0081.CHGE_MT_HOJINSVKEI_UK_NOPT AS CHGE_MT_HOJINSVKEI_UK_NOPT2, ")
.append(" KK0081.CHGE_SK_HOJINSVKEI_UK_NO AS CHGE_SK_HOJINSVKEI_UK_NO2, ")
.append(" KK0081.CHGE_SK_HOJINSVKEI_UK_NOPT AS CHGE_SK_HOJINSVKEI_UK_NOPT2, ")
.append(" KK0081.CHMT_HJIN_EO_YKAE_SVKEI_NO AS CHMT_HJIN_EO_YKAE_SVKEI_NO2, ")
.append(" KK0081.CHSK_HJIN_EO_YKAE_SVKEI_NO AS CHSK_HJIN_EO_YKAE_SVKEI_NO2, ")
.append(" KK0081.PNLTY_HASSEI_CD AS PNLTY_HASSEI_CD2, ")
.append(" KK0081.PNLTY_CHGE_RSN_CD AS PNLTY_CHGE_RSN_CD2, ")
.append(" KK0081.IDO_DIV AS IDO_DIV2, ")
.append(" KK0081.SHK_DFLT_PWD AS SHK_DFLT_PWD2, ")
.append(" KK0081.MENKAIHAT_ANKEN_KR_ADD_FLG AS MENKAIHAT_ANKEN_KR_ADD_FLG2, ")
.append(" KK0081.INTR_CD AS INTR_CD2, ")
.append(" KK0081.SHOSA_DSL_FIN_CD AS SHOSA_DSL_FIN_CD2, ")
.append(" KK0081.IDO_NG_STAT_CD AS IDO_NG_STAT_CD2, ")
.append(" KK0081.CHRG_STA_YMD_HOSEI_UM AS CHRG_STA_YMD_HOSEI_UM2, ")
.append(" KK0081.SVC_PAUSE_CHRG_STA_YMD AS SVC_PAUSE_CHRG_STA_YMD2, ")
.append(" KK0081.WORK_RRK_BIKO AS WORK_RRK_BIKO2, ")
.append(" KK0081.AUTO_SHOSA_TRAN_STAT_CD AS AUTO_SHOSA_TRAN_STAT_CD2, ")
.append(" KK0081.KIKI_MIADD_LIST_OPUTZM_FLG AS KIKI_MIADD_LIST_OPUTZM_FLG2, ")
.append(" KK0081.KAIHK_FAIL_KEI_CST_ZM_FLG AS KAIHK_FAIL_KEI_CST_ZM_FLG2, ")
.append(" KK0081.SVCTK_BUT_DEL_TRN_JSSI_DTM AS SVCTK_BUT_DEL_TRN_JSSI_DTM2, ")
.append(" NULL AS LAST_UPD_DTM2, ")
.append(" KK0091.SVC_KEI_NO AS SVC_KEI_NO3, ")
.append(" KK0091.GENE_ADD_DTM AS GENE_ADD_DTM3, ")
.append(" KK0091.KOTEI_IP_AD_HKTGI_UM AS KOTEI_IP_AD_HKTGI_UM3, ")
.append(" KK0091.PC_PACK_UM AS PC_PACK_UM3, ")
.append(" KK0091.CUST_NOVA_USE_UM AS CUST_NOVA_USE_UM3, ")
.append(" KK0091.RSV_APLY_CD AS RSV_APLY_CD3, ")
.append(" NULL AS LAST_UPD_DTM3, ")
.append(" KK0161.SVC_KEI_UCWK_NO AS SVC_KEI_UCWK_NO4, ")
.append(" KK0161.GENE_ADD_DTM AS GENE_ADD_DTM4, ")
.append(" KK0161.SVC_KEI_UCWK_STAT AS SVC_KEI_UCWK_STAT4, ")
.append(" KK0161.SVC_KEI_NO AS SVC_KEI_NO4, ")
.append(" KK0161.MSKM_DTL_NO AS MSKM_DTL_NO4, ")
.append(" KK0161.PCRS_CD AS PCRS_CD4, ")
.append(" KK0161.PPLAN_CD AS PPLAN_CD4, ")
.append(" KK0161.TK_HOSHIKI_KEI_NO AS TK_HOSHIKI_KEI_NO4, ")
.append(" KK0161.PAYWAY_KEIZOKU_FLG AS PAYWAY_KEIZOKU_FLG4, ")
.append(" KK0161.WEB_OP_ADD_FAIL_FLG AS WEB_OP_ADD_FAIL_FLG4, ")
.append(" KK0161.WORK_RRK_BIKO AS WORK_RRK_BIKO4, ")
.append(" KK0161.SVC_USE_STA_KIBO_YMD AS SVC_USE_STA_KIBO_YMD4, ")
.append(" KK0161.RSV_TSTA_KIBO_YMD AS RSV_TSTA_KIBO_YMD4, ")
.append(" KK0161.SKEKKA_SEND_CD AS SKEKKA_SEND_CD4, ")
.append(" KK0161.SVC_KEI_UCWK_KZKWRK_REQYMD AS SVC_KEI_UCWK_KZKWRK_REQYMD4, ")
.append(" KK0161.SHOSA_YMD AS SHOSA_YMD4, ")
.append(" KK0161.SHOSA_CL_YMD AS SHOSA_CL_YMD4, ")
.append(" KK0161.FTRIAL_KANYU_YMD AS FTRIAL_KANYU_YMD4, ")
.append(" KK0161.FTRIAL_PRD_ENDYMD AS FTRIAL_PRD_ENDYMD4, ")
.append(" KK0161.HONKANYU_YMD AS HONKANYU_YMD4, ")
.append(" KK0161.HONKANYU_IKO_KIGEN_YMD AS HONKANYU_IKO_KIGEN_YMD4, ")
.append(" KK0161.KEI_CNC_YMD AS KEI_CNC_YMD4, ")
.append(" KK0161.RSV_APLY_YMD AS RSV_APLY_YMD4, ")
.append(" KK0161.RSV_CL_YMD AS RSV_CL_YMD4, ")
.append(" KK0161.RSV_APLY_CD AS RSV_APLY_CD4, ")
.append(" KK0161.PLAN_STAYMD AS PLAN_STAYMD4, ")
.append(" KK0161.PLAN_ENDYMD AS PLAN_ENDYMD4, ")
.append(" KK0161.PLAN_CHRG_STAYMD AS PLAN_CHRG_STAYMD4, ")
.append(" KK0161.PLAN_CHRG_ENDYMD AS PLAN_CHRG_ENDYMD4, ")
.append(" KK0161.PLAN_END_SBT_CD AS PLAN_END_SBT_CD4, ")
.append(" KK0161.SVC_CANCEL_YMD AS SVC_CANCEL_YMD4, ")
.append(" KK0161.SVC_CANCEL_RSN_CD AS SVC_CANCEL_RSN_CD4, ")
.append(" KK0161.SVC_STA_YMD AS SVC_STA_YMD4, ")
.append(" KK0161.SVC_CHRG_STAYMD AS SVC_CHRG_STAYMD4, ")
.append(" KK0161.SVC_STP_YMD AS SVC_STP_YMD4, ")
.append(" KK0161.SVC_STP_RSN_CD AS SVC_STP_RSN_CD4, ")
.append(" KK0161.SVC_STP_RLS_YMD AS SVC_STP_RLS_YMD4, ")
.append(" KK0161.SVC_STP_RLS_RSN_CD AS SVC_STP_RLS_RSN_CD4, ")
.append(" KK0161.PAUSE_STP_CD AS PAUSE_STP_CD4, ")
.append(" KK0161.SVC_PAUSE_YMD AS SVC_PAUSE_YMD4, ")
.append(" KK0161.SVC_PAUSE_RSN_CD AS SVC_PAUSE_RSN_CD4, ")
.append(" KK0161.SVC_PAUSE_RSN_MEMO AS SVC_PAUSE_RSN_MEMO4, ")
.append(" KK0161.SVC_PAUSE_RLS_YMD AS SVC_PAUSE_RLS_YMD4, ")
.append(" KK0161.SVC_PAUSE_RLS_RSN_CD AS SVC_PAUSE_RLS_RSN_CD4, ")
.append(" KK0161.SVC_PAUSE_RLS_RSN_MEMO AS SVC_PAUSE_RLS_RSN_MEMO4, ")
.append(" KK0161.SVC_ENDYMD AS SVC_ENDYMD4, ")
.append(" KK0161.SVC_CHRG_ENDYMD AS SVC_CHRG_ENDYMD4, ")
.append(" KK0161.SVC_DSL_YMD AS SVC_DSL_YMD4, ")
.append(" KK0161.SVC_DLRE_CD AS SVC_DLRE_CD4, ")
.append(" KK0161.SVC_DLRE_MEMO AS SVC_DLRE_MEMO4, ")
.append(" KK0161.SVC_DSL_TTDKI_FIN_FLG AS SVC_DSL_TTDKI_FIN_FLG4, ")
.append(" KK0161.KAIHK_YMD AS KAIHK_YMD4, ")
.append(" KK0161.SVC_CANCEL_CL_YMD AS SVC_CANCEL_CL_YMD4, ")
.append(" KK0161.SVC_DSL_CL_YMD AS SVC_DSL_CL_YMD4, ")
.append(" KK0161.SVKEIUW_HKHASYMD AS SVKEIUW_HKHASYMD4, ")
.append(" KK0161.CHRG_STA_YMD_HOSEI_UM AS CHRG_STA_YMD_HOSEI_UM4, ")
.append(" KK0161.SVC_PAUSE_CHRG_STA_YMD AS SVC_PAUSE_CHRG_STA_YMD4, ")
.append(" KK0161.PNLTY_HASSEI_CD AS PNLTY_HASSEI_CD4, ")
.append(" KK0161.IDO_DIV AS IDO_DIV4, ")
.append(" KK0161.SHOSA_DSL_FIN_CD AS SHOSA_DSL_FIN_CD4, ")
.append(" KK0161.SVCTK_BUT_DEL_TRN_JSSI_DTM AS SVCTK_BUT_DEL_TRN_JSSI_DTM4, ")
.append(" NULL AS LAST_UPD_DTM4, ")
.append(" KK0171.SVC_KEI_UCWK_NO AS SVC_KEI_UCWK_NO5, ")
.append(" KK0171.GENE_ADD_DTM AS GENE_ADD_DTM5, ")
.append(" KK0171.SHK_ISP_NINSHO_ID_PWD AS SHK_ISP_NINSHO_ID_PWD5, ")
.append(" KK0171.ISP_NINSHO_ID AS ISP_NINSHO_ID5, ")
.append(" KK0171.ISP_NINSHO_ID_PWD AS ISP_NINSHO_ID_PWD5, ")
.append(" KK0171.TK_TAIIKI_CD AS TK_TAIIKI_CD5, ")
.append(" KK0171.RSV_APLY_CD AS RSV_APLY_CD5, ")
.append(" NULL AS LAST_UPD_DTM5, ")
.append(" KK0021.KEI_HUKA_CD, ")
.append(" KK0021.MANSSBSYS_RNKI_YO_KIJIRAN, ")
.append(" KK0021.MANSION_ID, ")
.append(" KK0021.CATID, ")
.append(" KK0021.MKM_UK_SBT_CD, ")
.append(" KK0021.MSKMSHO_TRAT_IF_TNTSHA_NM, ")
.append(" KK0021.MSKMSHO_TRAT_IF_TELNO, ")
.append(" KK0021.HNIN_CFM_ATICLE_NM, ")
.append(" KK0081.SEIRI_NO, ")
.append(" KK0021.UPD_DTM, ")
// ANK-3136-00-00 MOD START
//.append(" KK0081.UPD_DTM ");
.append(" KK0081.UPD_DTM, ")
// ANK-3136-00-00 MOD END
// ANK-3136-00-00 ADD START
.append(" KK0021.TSYRN_KJ_RRKS_NM, ")
.append(" KK0021.TSYRN_KJ_RRKS_TLN, ")
.append(" KK0021.TSYRN_TAKCHO_JI_RRKS_NM, ")
.append(" KK0021.TSYRN_TAKCHO_JI_RRKS_TLN, ")
.append(" KK0021.TSYRN_RRK_KIBO_DATE, ")
.append(" KK0021.TSYRN_TAKCHO_YH, ")
.append(" KK0021.TSYRN_MAP_UM, ")
.append(" KK0021.TSYRN_KZN_KEI_INF, ")
.append(" KK0021.TSYRN_HBI_KAISHOU_YMD, ")
.append(" KK0021.EQUIP_RYUYO_UM, ")
.append(" KK0021.RYUYO_MOTO_KJAK_NO, ")
// ANK-4096-00-00 MOD START
// .append(" KK0021.SBRY_KJ_FIN_KIBOYMD ");
.append(" KK0021.SBRY_KJ_FIN_KIBOYMD, ")
// ANK-4096-00-00 MOD END
// ANK-3136-00-00 ADD END
// ANK-4096-00-00 ADD START
.append(" KK0021.NOW_USE_SK_KEI_KISN_DIV, ")
.append(" KK0021.KIKI_SETPLC_CHGUM, ")
.append(" KK0021.DOJITU_JSSI_KBUM, ")
.append(" KK0021.EARLY_OPEN_EARLY_RRK_KBUM, ")
// ANK-4096-00-00 ADD END
// ANK-4174-00-00 ADD START
// ANK-4088-00-00 MOD START
// .append(" KK0021.DNSKH_DOI_UM ");
// ANK-4174-00-00 ADD END
.append(" KK0021.DNSKH_DOI_UM, ")
// ANK-4468-09-00 MOD START
//.append(" KK0021.TAKCHO_APO_KADEN_KIBO_UM ");
.append(" KK0021.TAKCHO_APO_KADEN_KIBO_UM, ")
// ANK-4468-09-00 MOD END
// ANK-4088-00-00 MOD END
// ANK-4468-09-00 ADD START
.append(" KK0091.NRKEMT_SVKEI_NO, ")
// ANK-4427-00-00 ADD START
// .append(" NRKEMT_KK0081.PCRS_CD ");
.append(" NRKEMT_KK0081.PCRS_CD ")
.append(" , KK0091.WAO_HAKEN_YH_KIBO ")
.append(" , KK0091.WAO_KOJI_KIBO_YMD_1 ")
.append(" , KK0091.WAO_KOJI_KIBO_TIMEZ_1 ")
.append(" , KK0091.WAO_KOJI_KIBO_YMD_2 ")
.append(" , KK0091.WAO_KOJI_KIBO_TIMEZ_2 ")
.append(" , KK0091.WAO_KOJI_KIBO_YMD_3 ")
.append(" , KK0091.WAO_KOJI_KIBO_TIMEZ_3 ")
.append(" , KK0091.WAO_KOCOMP_RRK_JIKO ")
.append(" , KK0091.WAO_TENYO_DIV ")
.append(" , KK0091.WAO_TENYO_SHODAKU_NO ")
.append(" , KK0091.WAO_YK_KIGEN ")
.append(" , KK0091.WAO_AD_BNCHI_MEMO ")
// ANK-4427-00-00 MOD START
// ;
//ANK-4427-00-00 ADD END
.append(" , KK0791.NTTORS_DIV ")
// ANK-4427-00-00 MOD END
// ANK-4468-09-00 ADD END
// ANK-4640-00-00 ADD START
.append(" , KK0021.WAO_CHUMN_RNKI_YOKSI_FLG ");
// ANK-4640-00-00 ADD END
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(EKK0021B502CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" FROM ")
.append(" (SELECT ")
.append(" KK0021_1.MSKM_DTL_NO, ")
.append(" KK0021_1.GENE_ADD_DTM, ")
.append(" KK0021_1.MSKM_DTL_STAT, ")
.append(" KK0021_1.MSKM_NO, ")
.append(" KK0021_1.MSKMSHO_NO, ")
.append(" KK0021_1.MSKMSHO_DTL_NO, ")
.append(" KK0021_1.MSKM_YMD, ")
.append(" KK0021_1.SYSID, ")
.append(" KK0021_1.WEB_UK_NO, ")
.append(" KK0021_1.MSKM_FORM_CD, ")
.append(" KK0021_1.MSKM_DTL_SBT_CD, ")
.append(" KK0021_1.RRKS_KTAI_TELNO, ")
.append(" KK0021_1.RRKS_OFFC_NM, ")
.append(" KK0021_1.DT_RRKS_TELNO, ")
.append(" KK0021_1.NEW_MSKM_SBT_CD, ")
.append(" KK0021_1.MSKM_OPTNTY_CD, ")
.append(" KK0021_1.TAKCHO_KIBO_APO_KIGEN_YMD, ")
.append(" KK0021_1.KOJI_APO_RRKS_SHITEI_CD, ")
.append(" KK0021_1.KOJI_APO_RRKS_TELNO, ")
.append(" KK0021_1.RRK_JIKO_ADD_DTM, ")
.append(" KK0021_1.MSKM_DTL_SHOSA_DTM, ")
.append(" KK0021_1.MSKM_DTL_SHOSA_CL_YMD, ")
.append(" KK0021_1.KZKWRK_REQYMD, ")
.append(" KK0021_1.MSKM_DTL_CANCEL_YMD, ")
.append(" KK0021_1.MSKM_DTL_CANCEL_RSN_CD, ")
.append(" KK0021_1.MSKM_DTL_CANCEL_RSN_MEMO, ")
.append(" KK0021_1.MSKM_DTL_CANCEL_CL_YMD, ")
.append(" KK0021_1.MSKM_RRKS_MLAD, ")
.append(" KK0021_1.KOJI_PRG_TCHI_MLAD, ")
.append(" KK0021_1.RRK_JIKO, ")
.append(" KK0021_1.RCNT_SHOKAI_YMD, ")
.append(" KK0021_1.WEB_SHOKAI_CNT, ")
.append(" KK0021_1.PC_SHOKAI_CNT, ")
.append(" KK0021_1.KTAI_SHOKAI_CNT, ")
.append(" KK0021_1.KJSC_TCH_KTAI_MLAD, ")
.append(" KK0021_1.KJSC_TCH_PC_MLAD_CHG_YMD, ")
.append(" KK0021_1.KJSC_TCH_KTAI_MLAD_CHG_YMD, ")
.append(" KK0021_1.PRG_ML_LAST_SEND_DTM, ")
.append(" KK0021_1.ML_SEND_JGI_FLG, ")
.append(" KK0021_1.ML_SEND_JGI_RSN_MEMO, ")
.append(" KK0021_1.BMP_MSKM_RRKS_TLN, ")
.append(" KK0021_1.OP_SVC_HKTGI_UM, ")
.append(" KK0021_1.DSL_ATICLE_SOHU_KIBO_UM, ")
.append(" KK0021_1.RRK_WAY_HOKI, ")
.append(" KK0021_1.NEWCONST_BUKKEN_CD, ")
.append(" KK0021_1.HUKKAT_ANKEN_FLG, ")
.append(" KK0021_1.SAME_EQUIP_RE_MSKM_CD, ")
.append(" KK0021_1.HNIN_CFM_ATICLE_SBT_CD, ")
.append(" KK0021_1.MSKMSHO_SBT_CD, ")
.append(" KK0021_1.MAP_TEMP_UM, ")
.append(" KK0021_1.KCN_STB_MSKM_CNT, ")
.append(" KK0021_1.KCN_STB_KIND_CD, ")
.append(" KK0021_1.KEI_HUKA_CD, ")
.append(" KK0021_1.MANSSBSYS_RNKI_YO_KIJIRAN, ")
.append(" KK0021_1.MANSION_ID, ")
.append(" KK0021_1.CATID, ")
.append(" KK0021_1.MKM_UK_SBT_CD, ")
.append(" KK0021_1.MSKMSHO_TRAT_IF_TNTSHA_NM, ")
.append(" KK0021_1.MSKMSHO_TRAT_IF_TELNO, ")
.append(" KK0021_1.HNIN_CFM_ATICLE_NM, ")
// ANK-3136-00-00 MOD START
// .append(" KK0021_1.UPD_DTM ")
.append(" KK0021_1.UPD_DTM, ")
// ANK-3136-00-00 MOD END
// ANK-3136-00-00 ADD START
.append(" KK0021_1.TSYRN_KJ_RRKS_NM, ")
.append(" KK0021_1.TSYRN_KJ_RRKS_TLN, ")
.append(" KK0021_1.TSYRN_TAKCHO_JI_RRKS_NM, ")
.append(" KK0021_1.TSYRN_TAKCHO_JI_RRKS_TLN, ")
.append(" KK0021_1.TSYRN_RRK_KIBO_DATE, ")
.append(" KK0021_1.TSYRN_TAKCHO_YH, ")
.append(" KK0021_1.TSYRN_MAP_UM, ")
.append(" KK0021_1.TSYRN_KZN_KEI_INF, ")
.append(" KK0021_1.TSYRN_HBI_KAISHOU_YMD, ")
.append(" KK0021_1.EQUIP_RYUYO_UM, ")
.append(" KK0021_1.RYUYO_MOTO_KJAK_NO, ")
// ANK-4096-00-00 MOD START
// .append(" KK0021_1.SBRY_KJ_FIN_KIBOYMD ")
.append(" KK0021_1.SBRY_KJ_FIN_KIBOYMD, ")
// ANK-3136-00-00 ADD END
// ANK-4096-00-00 ADD START
.append(" KK0021_1.NOW_USE_SK_KEI_KISN_DIV, ")
.append(" KK0021_1.KIKI_SETPLC_CHGUM, ")
.append(" KK0021_1.DOJITU_JSSI_KBUM, ")
.append(" KK0021_1.EARLY_OPEN_EARLY_RRK_KBUM, ")
// ANK-4096-00-00 ADD END
// ANK-4174-00-00 ADD START
// ANK-4088-00-00 MOD START
// .append(" KK0021_1.DNSKH_DOI_UM ")
// ANK-4174-00-00 ADD END
.append(" KK0021_1.DNSKH_DOI_UM, ")
.append(" KK0021_1.TAKCHO_APO_KADEN_KIBO_UM ")
// ANK-4088-00-00 MOD END
// ANK-4640-00-00 ADD START
.append(" ,KK0021_1.WAO_CHUMN_RNKI_YOKSI_FLG ")
// ANK-4640-00-00 ADD END
.append(" FROM KK_T_MSKM_DTL KK0021_1 ")
.append(" WHERE KK0021_1.GENE_ADD_DTM = ")
.append(" (SELECT MAX(KK0021_GENE.GENE_ADD_DTM) ")
.append(" FROM KK_T_MSKM_DTL KK0021_GENE ")
.append(" WHERE KK0021_GENE.MSKM_DTL_NO = KK0021_1.MSKM_DTL_NO ")
.append(" AND KK0021_GENE.MK_FLG = '0') ")
.append(" AND KK0021_1.MSKM_DTL_STAT < '910' ")
.append(" AND KK0021_1.MSKM_DTL_NO = ? ")
.append(" ) KK0021 ")
.append(" INNER JOIN (SELECT ")
.append(" KK0081_1.SVC_KEI_NO, ")
.append(" KK0081_1.GENE_ADD_DTM, ")
.append(" KK0081_1.SVC_KEI_STAT, ")
.append(" KK0081_1.SYSID, ")
.append(" KK0081_1.SVC_CD, ")
.append(" KK0081_1.MSKM_DTL_NO, ")
.append(" KK0081_1.MENKAIHAT_ANKEN_NO, ")
.append(" KK0081_1.PRC_GRP_CD, ")
.append(" KK0081_1.PCRS_CD, ")
.append(" KK0081_1.PPLAN_CD, ")
.append(" KK0081_1.TK_HOSHIKI_KEI_NO, ")
.append(" KK0081_1.SVC_USE_STA_KIBO_YMD, ")
.append(" KK0081_1.RSV_TSTA_KIBO_YMD, ")
.append(" KK0081_1.ID_SOKHOSHO_OUTPUT_YH, ")
.append(" KK0081_1.SVC_KEI_KZKWRK_REQYMD, ")
.append(" KK0081_1.SHOSA_YMD, ")
.append(" KK0081_1.SHOSA_CL_YMD, ")
.append(" KK0081_1.SKEKKA_CD, ")
.append(" KK0081_1.SKEKKA_DTL_CD, ")
.append(" KK0081_1.SKEKKA_HOKI_CD, ")
.append(" KK0081_1.SKEKKA_SEND_CD, ")
.append(" KK0081_1.PAYWAY_KEIZOKU_FLG, ")
.append(" KK0081_1.FTRIAL_KANYU_YMD, ")
.append(" KK0081_1.FTRIAL_PRD_ENDYMD, ")
.append(" KK0081_1.HONKANYU_YMD, ")
.append(" KK0081_1.HONKANYU_IKO_KIGEN_YMD, ")
.append(" KK0081_1.KEI_CNC_YMD, ")
.append(" KK0081_1.PLAN_STAYMD, ")
.append(" KK0081_1.PLAN_ENDYMD, ")
.append(" KK0081_1.PLAN_CHRG_STAYMD, ")
.append(" KK0081_1.PLAN_CHRG_ENDYMD, ")
.append(" KK0081_1.PLAN_END_SBT_CD, ")
.append(" KK0081_1.RSV_APLY_YMD, ")
.append(" KK0081_1.RSV_CL_YMD, ")
.append(" KK0081_1.RSV_APLY_CD, ")
.append(" KK0081_1.SVC_CANCEL_YMD, ")
.append(" KK0081_1.SVC_CANCEL_RSN_CD, ")
.append(" KK0081_1.SVC_STA_YMD, ")
.append(" KK0081_1.SVC_CHRG_STAYMD, ")
.append(" KK0081_1.LETTER_HASSO_SHIWAKE_DIV, ")
.append(" KK0081_1.THNX_LETTER_SHS_CD, ")
.append(" KK0081_1.WEB_OP_ADD_FAIL_FLG, ")
.append(" KK0081_1.SVC_STP_YMD, ")
.append(" KK0081_1.SVC_STP_RSN_CD, ")
.append(" KK0081_1.SVC_STP_RLS_YMD, ")
.append(" KK0081_1.SVC_STP_RLS_RSN_CD, ")
.append(" KK0081_1.PAUSE_STP_CD, ")
.append(" KK0081_1.SVC_PAUSE_YMD, ")
.append(" KK0081_1.SVC_PAUSE_RSN_CD, ")
.append(" KK0081_1.SVC_PAUSE_RSN_MEMO, ")
.append(" KK0081_1.SVC_PAUSE_RLS_YMD, ")
.append(" KK0081_1.SVC_PAUSE_RLS_RSN_CD, ")
.append(" KK0081_1.SVC_PAUSE_RLS_RSN_MEMO, ")
.append(" KK0081_1.SVC_ENDYMD, ")
.append(" KK0081_1.SVC_CHRG_ENDYMD, ")
.append(" KK0081_1.SVC_DSL_YMD, ")
.append(" KK0081_1.SVC_DLRE_CD, ")
.append(" KK0081_1.SVC_DLRE_MEMO, ")
.append(" KK0081_1.SVC_DSL_TTDKI_FIN_FLG, ")
.append(" KK0081_1.KAIHK_YMD, ")
.append(" KK0081_1.SVC_CANCEL_CL_YMD, ")
.append(" KK0081_1.SVC_DSL_CL_YMD, ")
.append(" KK0081_1.CHGE_MT_HOJINSVKEI_UK_NO, ")
.append(" KK0081_1.CHGE_MT_HOJINSVKEI_UK_NOPT, ")
.append(" KK0081_1.CHGE_SK_HOJINSVKEI_UK_NO, ")
.append(" KK0081_1.CHGE_SK_HOJINSVKEI_UK_NOPT, ")
.append(" KK0081_1.CHMT_HJIN_EO_YKAE_SVKEI_NO, ")
.append(" KK0081_1.CHSK_HJIN_EO_YKAE_SVKEI_NO, ")
.append(" KK0081_1.PNLTY_HASSEI_CD, ")
.append(" KK0081_1.PNLTY_CHGE_RSN_CD, ")
.append(" KK0081_1.IDO_DIV, ")
.append(" KK0081_1.SHK_DFLT_PWD, ")
.append(" KK0081_1.MENKAIHAT_ANKEN_KR_ADD_FLG, ")
.append(" KK0081_1.INTR_CD, ")
.append(" KK0081_1.SHOSA_DSL_FIN_CD, ")
.append(" KK0081_1.IDO_NG_STAT_CD, ")
.append(" KK0081_1.CHRG_STA_YMD_HOSEI_UM, ")
.append(" KK0081_1.SVC_PAUSE_CHRG_STA_YMD, ")
.append(" KK0081_1.WORK_RRK_BIKO, ")
.append(" KK0081_1.AUTO_SHOSA_TRAN_STAT_CD, ")
.append(" KK0081_1.KIKI_MIADD_LIST_OPUTZM_FLG, ")
.append(" KK0081_1.KAIHK_FAIL_KEI_CST_ZM_FLG, ")
.append(" KK0081_1.SVCTK_BUT_DEL_TRN_JSSI_DTM, ")
.append(" KK0081_1.SEIRI_NO, ")
.append(" KK0081_1.UPD_DTM ")
.append(" FROM ")
.append(" KK_T_SVC_KEI KK0081_1 ")
.append(" WHERE ")
.append(" KK0081_1.RSV_APLY_YMD || KK0081_1.GENE_ADD_DTM = ")
.append(" (SELECT MAX(KK0081_GENE.RSV_APLY_YMD || KK0081_GENE.GENE_ADD_DTM) AS KK0081_MAX ")
.append(" FROM KK_T_SVC_KEI KK0081_GENE ")
.append(" WHERE KK0081_GENE.SVC_KEI_NO = KK0081_1.SVC_KEI_NO ")
.append(" AND KK0081_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0081_GENE.RSV_APLY_CD = '2' ")
.append(" AND KK0081_GENE.MK_FLG = '0') ")
.append(" AND KK0081_1.SVC_KEI_STAT < '910' ")
.append(" ) KK0081 ")
.append(" ON KK0081.MSKM_DTL_NO = KK0021.MSKM_DTL_NO ")
.append(" INNER JOIN (SELECT ")
.append(" KK0091_1.SVC_KEI_NO, ")
.append(" KK0091_1.GENE_ADD_DTM, ")
.append(" KK0091_1.KOTEI_IP_AD_HKTGI_UM, ")
.append(" KK0091_1.PC_PACK_UM, ")
.append(" KK0091_1.CUST_NOVA_USE_UM, ")
// ANK-4468-09-00 MOD START
//.append(" KK0091_1.RSV_APLY_CD ")
.append(" KK0091_1.RSV_APLY_CD, ")
// ANK-4468-09-00 MOD END
// ANK-4468-09-00 ADD START
.append(" KK0091_1.NRKEMT_SVKEI_NO ")
// ANK-4468-09-00 ADD END
// ANK-4427-00-00 ADD START
.append(" , KK0091_1.WAO_HAKEN_YH_KIBO ")
.append(" , KK0091_1.WAO_KOJI_KIBO_YMD_1 ")
.append(" , KK0091_1.WAO_KOJI_KIBO_TIMEZ_1 ")
.append(" , KK0091_1.WAO_KOJI_KIBO_YMD_2 ")
.append(" , KK0091_1.WAO_KOJI_KIBO_TIMEZ_2 ")
.append(" , KK0091_1.WAO_KOJI_KIBO_YMD_3 ")
.append(" , KK0091_1.WAO_KOJI_KIBO_TIMEZ_3 ")
.append(" , KK0091_1.WAO_KOCOMP_RRK_JIKO ")
.append(" , KK0091_1.WAO_TENYO_DIV ")
.append(" , KK0091_1.WAO_TENYO_SHODAKU_NO ")
.append(" , KK0091_1.WAO_YK_KIGEN ")
.append(" , KK0091_1.WAO_AD_BNCHI_MEMO ")
// ANK-4427-00-00 ADD END
.append(" FROM ")
.append(" KK_T_SVC_KEI_EOH_NET KK0091_1 ")
.append(" WHERE ")
.append(" KK0091_1.GENE_ADD_DTM = ")
.append(" (SELECT MAX(KK0091_GENE.GENE_ADD_DTM) AS KK0091_MAX ")
.append(" FROM KK_T_SVC_KEI_EOH_NET KK0091_GENE ")
.append(" WHERE KK0091_GENE.SVC_KEI_NO = KK0091_1.SVC_KEI_NO ")
.append(" AND KK0091_1.RSV_APLY_CD = '2' ")
.append(" AND KK0091_GENE.MK_FLG = '0') ")
.append(" ) KK0091 ")
.append(" ON KK0091.SVC_KEI_NO = KK0081.SVC_KEI_NO ")
.append(" INNER JOIN (SELECT ")
.append(" KK0161_1.SVC_KEI_UCWK_NO, ")
.append(" KK0161_1.GENE_ADD_DTM, ")
.append(" KK0161_1.SVC_KEI_UCWK_STAT, ")
.append(" KK0161_1.SVC_KEI_NO, ")
.append(" KK0161_1.MSKM_DTL_NO, ")
.append(" KK0161_1.PCRS_CD, ")
.append(" KK0161_1.PPLAN_CD, ")
.append(" KK0161_1.TK_HOSHIKI_KEI_NO, ")
.append(" KK0161_1.PAYWAY_KEIZOKU_FLG, ")
.append(" KK0161_1.WEB_OP_ADD_FAIL_FLG, ")
.append(" KK0161_1.WORK_RRK_BIKO, ")
.append(" KK0161_1.SVC_USE_STA_KIBO_YMD, ")
.append(" KK0161_1.RSV_TSTA_KIBO_YMD, ")
.append(" KK0161_1.SKEKKA_SEND_CD, ")
.append(" KK0161_1.SVC_KEI_UCWK_KZKWRK_REQYMD, ")
.append(" KK0161_1.SHOSA_YMD, ")
.append(" KK0161_1.SHOSA_CL_YMD, ")
.append(" KK0161_1.FTRIAL_KANYU_YMD, ")
.append(" KK0161_1.FTRIAL_PRD_ENDYMD, ")
.append(" KK0161_1.HONKANYU_YMD, ")
.append(" KK0161_1.HONKANYU_IKO_KIGEN_YMD, ")
.append(" KK0161_1.KEI_CNC_YMD, ")
.append(" KK0161_1.RSV_APLY_YMD, ")
.append(" KK0161_1.RSV_CL_YMD, ")
.append(" KK0161_1.RSV_APLY_CD, ")
.append(" KK0161_1.PLAN_STAYMD, ")
.append(" KK0161_1.PLAN_ENDYMD, ")
.append(" KK0161_1.PLAN_CHRG_STAYMD, ")
.append(" KK0161_1.PLAN_CHRG_ENDYMD, ")
.append(" KK0161_1.PLAN_END_SBT_CD, ")
.append(" KK0161_1.SVC_CANCEL_YMD, ")
.append(" KK0161_1.SVC_CANCEL_RSN_CD, ")
.append(" KK0161_1.SVC_STA_YMD, ")
.append(" KK0161_1.SVC_CHRG_STAYMD, ")
.append(" KK0161_1.SVC_STP_YMD, ")
.append(" KK0161_1.SVC_STP_RSN_CD, ")
.append(" KK0161_1.SVC_STP_RLS_YMD, ")
.append(" KK0161_1.SVC_STP_RLS_RSN_CD, ")
.append(" KK0161_1.PAUSE_STP_CD, ")
.append(" KK0161_1.SVC_PAUSE_YMD, ")
.append(" KK0161_1.SVC_PAUSE_RSN_CD, ")
.append(" KK0161_1.SVC_PAUSE_RSN_MEMO, ")
.append(" KK0161_1.SVC_PAUSE_RLS_YMD, ")
.append(" KK0161_1.SVC_PAUSE_RLS_RSN_CD, ")
.append(" KK0161_1.SVC_PAUSE_RLS_RSN_MEMO, ")
.append(" KK0161_1.SVC_ENDYMD, ")
.append(" KK0161_1.SVC_CHRG_ENDYMD, ")
.append(" KK0161_1.SVC_DSL_YMD, ")
.append(" KK0161_1.SVC_DLRE_CD, ")
.append(" KK0161_1.SVC_DLRE_MEMO, ")
.append(" KK0161_1.SVC_DSL_TTDKI_FIN_FLG, ")
.append(" KK0161_1.KAIHK_YMD, ")
.append(" KK0161_1.SVC_CANCEL_CL_YMD, ")
.append(" KK0161_1.SVC_DSL_CL_YMD, ")
.append(" KK0161_1.SVKEIUW_HKHASYMD, ")
.append(" KK0161_1.CHRG_STA_YMD_HOSEI_UM, ")
.append(" KK0161_1.SVC_PAUSE_CHRG_STA_YMD, ")
.append(" KK0161_1.PNLTY_HASSEI_CD, ")
.append(" KK0161_1.IDO_DIV, ")
.append(" KK0161_1.SHOSA_DSL_FIN_CD, ")
.append(" KK0161_1.SVCTK_BUT_DEL_TRN_JSSI_DTM ")
.append(" FROM ")
.append(" KK_T_SVC_KEI_UCWK KK0161_1 ")
.append(" WHERE ")
.append(" KK0161_1.RSV_APLY_YMD || KK0161_1.GENE_ADD_DTM = ")
.append(" (SELECT MAX(KK0161_GENE.RSV_APLY_YMD || KK0161_GENE.GENE_ADD_DTM) AS KK0161_MAX ")
.append(" FROM KK_T_SVC_KEI_UCWK KK0161_GENE ")
.append(" WHERE KK0161_GENE.SVC_KEI_UCWK_NO = KK0161_1.SVC_KEI_UCWK_NO ")
.append(" AND KK0161_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0161_GENE.RSV_APLY_CD = '2' ")
.append(" AND KK0161_GENE.MK_FLG = '0') ")
.append(" AND KK0161_1.SVC_KEI_UCWK_STAT < '910' ")
.append(" ) KK0161 ")
.append(" ON KK0161.SVC_KEI_NO = KK0081.SVC_KEI_NO ")
.append(" INNER JOIN (SELECT ")
.append(" KK0171_1.SVC_KEI_UCWK_NO, ")
.append(" KK0171_1.GENE_ADD_DTM, ")
.append(" KK0171_1.SHK_ISP_NINSHO_ID_PWD, ")
.append(" KK0171_1.ISP_NINSHO_ID, ")
.append(" KK0171_1.ISP_NINSHO_ID_PWD, ")
.append(" KK0171_1.TK_TAIIKI_CD, ")
.append(" KK0171_1.RSV_APLY_CD ")
.append(" FROM ")
.append(" KK_T_SVKEIUW_EOH_NET KK0171_1 ")
.append(" WHERE ")
.append(" KK0171_1.GENE_ADD_DTM = ")
.append(" (SELECT MAX(KK0171_GENE.GENE_ADD_DTM) AS KK0171_MAX ")
.append(" FROM KK_T_SVKEIUW_EOH_NET KK0171_GENE ")
.append(" WHERE KK0171_GENE.SVC_KEI_UCWK_NO = KK0171_1.SVC_KEI_UCWK_NO ")
.append(" AND KK0171_1.RSV_APLY_CD = '2' ")
.append(" AND KK0171_GENE.MK_FLG = '0') ")
.append(" ) KK0171 ")
.append(" ON KK0171.SVC_KEI_UCWK_NO = KK0161.SVC_KEI_UCWK_NO ")
// ANK-4468-09-00 MOD START
//.append(" AND KK0171.GENE_ADD_DTM = KK0161.GENE_ADD_DTM ");
.append(" AND KK0171.GENE_ADD_DTM = KK0161.GENE_ADD_DTM ")
// ANK-4468-09-00 MOD END
// ANK-4468-09-00 ADD START
.append(" LEFT JOIN (SELECT ")
.append(" NRKEMT_KK0081_1.PCRS_CD ,")
.append(" NRKEMT_KK0081_1.SVC_KEI_NO ")
.append(" FROM ")
.append(" KK_T_SVC_KEI NRKEMT_KK0081_1 ")
.append(" WHERE ")
.append(" NRKEMT_KK0081_1.RSV_APLY_YMD || NRKEMT_KK0081_1.GENE_ADD_DTM = ")
.append(" (SELECT MAX(KK0081_GENE.RSV_APLY_YMD || KK0081_GENE.GENE_ADD_DTM) AS KK0081_MAX ")
.append(" FROM KK_T_SVC_KEI KK0081_GENE ")
.append(" WHERE KK0081_GENE.SVC_KEI_NO = NRKEMT_KK0081_1.SVC_KEI_NO ")
.append(" AND KK0081_GENE.RSV_APLY_YMD <= ? ")
.append(" AND KK0081_GENE.RSV_APLY_CD = '2' ")
.append(" AND KK0081_GENE.MK_FLG = '0') ")
.append(" ) NRKEMT_KK0081 ")
// ANK-4427-00-00 MOD START
//.append(" ON KK0091.NRKEMT_SVKEI_NO = NRKEMT_KK0081.SVC_KEI_NO ");
.append(" ON KK0091.NRKEMT_SVKEI_NO = NRKEMT_KK0081.SVC_KEI_NO ")
.append(" INNER JOIN KK_M_PCRS KK0791 ")
.append(" ON KK0081.PRC_GRP_CD = KK0791.PRC_GRP_CD ")
.append(" AND KK0081.PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KK0791.RSV_APLY_YMD <= ? ")
.append(" AND KK0791.MK_FLG = '0' ");
// ANK-4427-00-00 MOD END
// ANK-4468-09-00 ADD END
}
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if ( "1".equals( inMsg.getString(EKK0021B502CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(ＫＥＹ＿予約適用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(EKK0021B502CBSMsg.KEY_RSV_APLY_YMD));
// パラメータの設定(ＫＥＹ＿申込明細番号を指定)
CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(EKK0021B502CBSMsg.KEY_MSKM_DTL_NO));
// パラメータの設定(ＫＥＹ＿予約適用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 3, inMsg.getObject(EKK0021B502CBSMsg.KEY_RSV_APLY_YMD));
// パラメータの設定(ＫＥＹ＿予約適用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 4, inMsg.getObject(EKK0021B502CBSMsg.KEY_RSV_APLY_YMD));
// ANK-4468-09-00 ADD START
// パラメータの設定(ＫＥＹ＿予約適用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 5, inMsg.getObject(EKK0021B502CBSMsg.KEY_RSV_APLY_YMD));
// ANK-4468-09-00 ADD END
// ANK-4427-00-00 ADD START
// パラメータの設定(ＫＥＹ＿予約適用年月日を指定)
CAANJDBCUtil.setParam(pstmt, 6, inMsg.getObject(EKK0021B502CBSMsg.KEY_RSV_APLY_YMD));
// ANK-4427-00-00 ADD END
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EKK0021B502CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_NO
, EKK0021B502CBSMsg1List.KK0021_GENE_ADD_DTM
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_STAT
, EKK0021B502CBSMsg1List.KK0021_MSKM_NO
, EKK0021B502CBSMsg1List.KK0021_MSKMSHO_NO
, EKK0021B502CBSMsg1List.KK0021_MSKMSHO_DTL_NO
, EKK0021B502CBSMsg1List.KK0021_MSKM_YMD
, EKK0021B502CBSMsg1List.KK0021_SYSID
, EKK0021B502CBSMsg1List.KK0021_WEB_UK_NO
, EKK0021B502CBSMsg1List.KK0021_MSKM_FORM_CD
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_SBT_CD
, EKK0021B502CBSMsg1List.KK0021_RRKS_KTAI_TELNO
, EKK0021B502CBSMsg1List.KK0021_RRKS_OFFC_NM
, EKK0021B502CBSMsg1List.KK0021_DT_RRKS_TELNO
, EKK0021B502CBSMsg1List.KK0021_NEW_MSKM_SBT_CD
, EKK0021B502CBSMsg1List.KK0021_MSKM_OPTNTY_CD
, EKK0021B502CBSMsg1List.KK0021_TAKCHO_KIBO_APO_KIGEN_YMD
, EKK0021B502CBSMsg1List.KK0021_KOJI_APO_RRKS_SHITEI_CD
, EKK0021B502CBSMsg1List.KK0021_KOJI_APO_RRKS_TELNO
, EKK0021B502CBSMsg1List.KK0021_RRK_JIKO_ADD_DTM
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_SHOSA_DTM
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_SHOSA_CL_YMD
, EKK0021B502CBSMsg1List.KK0021_KZKWRK_REQYMD
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_CANCEL_YMD
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_CANCEL_RSN_CD
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_CANCEL_RSN_MEMO
, EKK0021B502CBSMsg1List.KK0021_MSKM_DTL_CANCEL_CL_YMD
, EKK0021B502CBSMsg1List.KK0021_MSKM_RRKS_MLAD
, EKK0021B502CBSMsg1List.KK0021_KOJI_PRG_TCHI_MLAD
, EKK0021B502CBSMsg1List.KK0021_RRK_JIKO
, EKK0021B502CBSMsg1List.KK0021_RCNT_SHOKAI_YMD
, EKK0021B502CBSMsg1List.KK0021_WEB_SHOKAI_CNT
, EKK0021B502CBSMsg1List.KK0021_PC_SHOKAI_CNT
, EKK0021B502CBSMsg1List.KK0021_KTAI_SHOKAI_CNT
, EKK0021B502CBSMsg1List.KK0021_KJSC_TCH_KTAI_MLAD
, EKK0021B502CBSMsg1List.KK0021_KJSC_TCH_PC_MLAD_CHG_YMD
, EKK0021B502CBSMsg1List.KK0021_KJSC_TCH_KTAI_MLAD_CHG_YMD
, EKK0021B502CBSMsg1List.KK0021_PRG_ML_LAST_SEND_DTM
, EKK0021B502CBSMsg1List.KK0021_ML_SEND_JGI_FLG
, EKK0021B502CBSMsg1List.KK0021_ML_SEND_JGI_RSN_MEMO
, EKK0021B502CBSMsg1List.KK0021_BMP_MSKM_RRKS_TLN
, EKK0021B502CBSMsg1List.KK0021_OP_SVC_HKTGI_UM
, EKK0021B502CBSMsg1List.KK0021_DSL_ATICLE_SOHU_KIBO_UM
, EKK0021B502CBSMsg1List.KK0021_RRK_WAY_HOKI
, EKK0021B502CBSMsg1List.KK0021_NEWCONST_BUKKEN_CD
, EKK0021B502CBSMsg1List.KK0021_HUKKAT_ANKEN_FLG
, EKK0021B502CBSMsg1List.KK0021_SAME_EQUIP_RE_MSKM_CD
, EKK0021B502CBSMsg1List.KK0021_HNIN_CFM_ATICLE_SBT_CD
, EKK0021B502CBSMsg1List.KK0021_MSKMSHO_SBT_CD
, EKK0021B502CBSMsg1List.KK0021_MAP_TEMP_UM
, EKK0021B502CBSMsg1List.KK0021_KCN_STB_MSKM_CNT
, EKK0021B502CBSMsg1List.KK0021_KCN_STB_KIND_CD
, EKK0021B502CBSMsg1List.KK0021_LAST_UPD_DTM
, EKK0021B502CBSMsg1List.KK0081_SVC_KEI_NO
, EKK0021B502CBSMsg1List.KK0081_GENE_ADD_DTM
, EKK0021B502CBSMsg1List.KK0081_SVC_KEI_STAT
, EKK0021B502CBSMsg1List.KK0081_SYSID
, EKK0021B502CBSMsg1List.KK0081_SVC_CD
, EKK0021B502CBSMsg1List.KK0081_MSKM_DTL_NO
, EKK0021B502CBSMsg1List.KK0081_MENKAIHAT_ANKEN_NO
, EKK0021B502CBSMsg1List.KK0081_PRC_GRP_CD
, EKK0021B502CBSMsg1List.KK0081_PCRS_CD
, EKK0021B502CBSMsg1List.KK0081_PPLAN_CD
, EKK0021B502CBSMsg1List.KK0081_TK_HOSHIKI_KEI_NO
, EKK0021B502CBSMsg1List.KK0081_SVC_USE_STA_KIBO_YMD
, EKK0021B502CBSMsg1List.KK0081_RSV_TSTA_KIBO_YMD
, EKK0021B502CBSMsg1List.KK0081_ID_SOKHOSHO_OUTPUT_YH
, EKK0021B502CBSMsg1List.KK0081_SVC_KEI_KZKWRK_REQYMD
, EKK0021B502CBSMsg1List.KK0081_SHOSA_YMD
, EKK0021B502CBSMsg1List.KK0081_SHOSA_CL_YMD
, EKK0021B502CBSMsg1List.KK0081_SKEKKA_CD
, EKK0021B502CBSMsg1List.KK0081_SKEKKA_CD_NM
, EKK0021B502CBSMsg1List.KK0081_SKEKKA_DTL_CD
, EKK0021B502CBSMsg1List.KK0081_SKEKKA_HOKI_CD
, EKK0021B502CBSMsg1List.KK0081_SKEKKA_SEND_CD
, EKK0021B502CBSMsg1List.KK0081_PAYWAY_KEIZOKU_FLG
, EKK0021B502CBSMsg1List.KK0081_FTRIAL_KANYU_YMD
, EKK0021B502CBSMsg1List.KK0081_FTRIAL_PRD_ENDYMD
, EKK0021B502CBSMsg1List.KK0081_HONKANYU_YMD
, EKK0021B502CBSMsg1List.KK0081_HONKANYU_IKO_KIGEN_YMD
, EKK0021B502CBSMsg1List.KK0081_KEI_CNC_YMD
, EKK0021B502CBSMsg1List.KK0081_PLAN_STAYMD
, EKK0021B502CBSMsg1List.KK0081_PLAN_ENDYMD
, EKK0021B502CBSMsg1List.KK0081_PLAN_CHRG_STAYMD
, EKK0021B502CBSMsg1List.KK0081_PLAN_CHRG_ENDYMD
, EKK0021B502CBSMsg1List.KK0081_PLAN_END_SBT_CD
, EKK0021B502CBSMsg1List.KK0081_RSV_APLY_YMD
, EKK0021B502CBSMsg1List.KK0081_RSV_CL_YMD
, EKK0021B502CBSMsg1List.KK0081_RSV_APLY_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_CANCEL_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_CANCEL_RSN_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_STA_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_CHRG_STAYMD
, EKK0021B502CBSMsg1List.KK0081_LETTER_HASSO_SHIWAKE_DIV
, EKK0021B502CBSMsg1List.KK0081_THNX_LETTER_SHS_CD
, EKK0021B502CBSMsg1List.KK0081_WEB_OP_ADD_FAIL_FLG
, EKK0021B502CBSMsg1List.KK0081_SVC_STP_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_STP_RSN_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_STP_RLS_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_STP_RLS_RSN_CD
, EKK0021B502CBSMsg1List.KK0081_PAUSE_STP_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_RSN_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_RSN_MEMO
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_RLS_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_RLS_RSN_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_RLS_RSN_MEMO
, EKK0021B502CBSMsg1List.KK0081_SVC_ENDYMD
, EKK0021B502CBSMsg1List.KK0081_SVC_CHRG_ENDYMD
, EKK0021B502CBSMsg1List.KK0081_SVC_DSL_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_DLRE_CD
, EKK0021B502CBSMsg1List.KK0081_SVC_DLRE_MEMO
, EKK0021B502CBSMsg1List.KK0081_SVC_DSL_TTDKI_FIN_FLG
, EKK0021B502CBSMsg1List.KK0081_KAIHK_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_CANCEL_CL_YMD
, EKK0021B502CBSMsg1List.KK0081_SVC_DSL_CL_YMD
, EKK0021B502CBSMsg1List.KK0081_CHGE_MT_HOJINSVKEI_UK_NO
, EKK0021B502CBSMsg1List.KK0081_CHGE_MT_HOJINSVKEI_UK_NOPT
, EKK0021B502CBSMsg1List.KK0081_CHGE_SK_HOJINSVKEI_UK_NO
, EKK0021B502CBSMsg1List.KK0081_CHGE_SK_HOJINSVKEI_UK_NOPT
, EKK0021B502CBSMsg1List.KK0081_CHMT_HJIN_EO_YKAE_SVKEI_NO
, EKK0021B502CBSMsg1List.KK0081_CHSK_HJIN_EO_YKAE_SVKEI_NO
, EKK0021B502CBSMsg1List.KK0081_PNLTY_HASSEI_CD
, EKK0021B502CBSMsg1List.KK0081_PNLTY_CHGE_RSN_CD
, EKK0021B502CBSMsg1List.KK0081_IDO_DIV
, EKK0021B502CBSMsg1List.KK0081_SHK_DFLT_PWD
, EKK0021B502CBSMsg1List.KK0081_MENKAIHAT_ANKEN_KR_ADD_FLG
, EKK0021B502CBSMsg1List.KK0081_INTR_CD
, EKK0021B502CBSMsg1List.KK0081_SHOSA_DSL_FIN_CD
, EKK0021B502CBSMsg1List.KK0081_IDO_NG_STAT_CD
, EKK0021B502CBSMsg1List.KK0081_CHRG_STA_YMD_HOSEI_UM
, EKK0021B502CBSMsg1List.KK0081_SVC_PAUSE_CHRG_STA_YMD
, EKK0021B502CBSMsg1List.KK0081_WORK_RRK_BIKO
, EKK0021B502CBSMsg1List.KK0081_AUTO_SHOSA_TRAN_STAT_CD
, EKK0021B502CBSMsg1List.KK0081_KIKI_MIADD_LIST_OPUTZM_FLG
, EKK0021B502CBSMsg1List.KK0081_KAIHK_FAIL_KEI_CST_ZM_FLG
, EKK0021B502CBSMsg1List.KK0081_SVCTK_BUT_DEL_TRN_JSSI_DTM
, EKK0021B502CBSMsg1List.KK0081_LAST_UPD_DTM
, EKK0021B502CBSMsg1List.KK0091_SVC_KEI_NO
, EKK0021B502CBSMsg1List.KK0091_GENE_ADD_DTM
, EKK0021B502CBSMsg1List.KK0091_KOTEI_IP_AD_HKTGI_UM
, EKK0021B502CBSMsg1List.KK0091_PC_PACK_UM
, EKK0021B502CBSMsg1List.KK0091_CUST_NOVA_USE_UM
, EKK0021B502CBSMsg1List.KK0091_RSV_APLY_CD
, EKK0021B502CBSMsg1List.KK0091_LAST_UPD_DTM
, EKK0021B502CBSMsg1List.KK0161_SVC_KEI_UCWK_NO
, EKK0021B502CBSMsg1List.KK0161_GENE_ADD_DTM
, EKK0021B502CBSMsg1List.KK0161_SVC_KEI_UCWK_STAT
, EKK0021B502CBSMsg1List.KK0161_SVC_KEI_NO
, EKK0021B502CBSMsg1List.KK0161_MSKM_DTL_NO
, EKK0021B502CBSMsg1List.KK0161_PCRS_CD
, EKK0021B502CBSMsg1List.KK0161_PPLAN_CD
, EKK0021B502CBSMsg1List.KK0161_TK_HOSHIKI_KEI_NO
, EKK0021B502CBSMsg1List.KK0161_PAYWAY_KEIZOKU_FLG
, EKK0021B502CBSMsg1List.KK0161_WEB_OP_ADD_FAIL_FLG
, EKK0021B502CBSMsg1List.KK0161_WORK_RRK_BIKO
, EKK0021B502CBSMsg1List.KK0161_SVC_USE_STA_KIBO_YMD
, EKK0021B502CBSMsg1List.KK0161_RSV_TSTA_KIBO_YMD
, EKK0021B502CBSMsg1List.KK0161_SKEKKA_SEND_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_KEI_UCWK_KZKWRK_REQYMD
, EKK0021B502CBSMsg1List.KK0161_SHOSA_YMD
, EKK0021B502CBSMsg1List.KK0161_SHOSA_CL_YMD
, EKK0021B502CBSMsg1List.KK0161_FTRIAL_KANYU_YMD
, EKK0021B502CBSMsg1List.KK0161_FTRIAL_PRD_ENDYMD
, EKK0021B502CBSMsg1List.KK0161_HONKANYU_YMD
, EKK0021B502CBSMsg1List.KK0161_HONKANYU_IKO_KIGEN_YMD
, EKK0021B502CBSMsg1List.KK0161_KEI_CNC_YMD
, EKK0021B502CBSMsg1List.KK0161_RSV_APLY_YMD
, EKK0021B502CBSMsg1List.KK0161_RSV_CL_YMD
, EKK0021B502CBSMsg1List.KK0161_RSV_APLY_CD
, EKK0021B502CBSMsg1List.KK0161_PLAN_STAYMD
, EKK0021B502CBSMsg1List.KK0161_PLAN_ENDYMD
, EKK0021B502CBSMsg1List.KK0161_PLAN_CHRG_STAYMD
, EKK0021B502CBSMsg1List.KK0161_PLAN_CHRG_ENDYMD
, EKK0021B502CBSMsg1List.KK0161_PLAN_END_SBT_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_CANCEL_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_CANCEL_RSN_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_STA_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_CHRG_STAYMD
, EKK0021B502CBSMsg1List.KK0161_SVC_STP_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_STP_RSN_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_STP_RLS_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_STP_RLS_RSN_CD
, EKK0021B502CBSMsg1List.KK0161_PAUSE_STP_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_RSN_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_RSN_MEMO
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_RLS_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_RLS_RSN_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_RLS_RSN_MEMO
, EKK0021B502CBSMsg1List.KK0161_SVC_ENDYMD
, EKK0021B502CBSMsg1List.KK0161_SVC_CHRG_ENDYMD
, EKK0021B502CBSMsg1List.KK0161_SVC_DSL_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_DLRE_CD
, EKK0021B502CBSMsg1List.KK0161_SVC_DLRE_MEMO
, EKK0021B502CBSMsg1List.KK0161_SVC_DSL_TTDKI_FIN_FLG
, EKK0021B502CBSMsg1List.KK0161_KAIHK_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_CANCEL_CL_YMD
, EKK0021B502CBSMsg1List.KK0161_SVC_DSL_CL_YMD
, EKK0021B502CBSMsg1List.KK0161_SVKEIUW_HKHASYMD
, EKK0021B502CBSMsg1List.KK0161_CHRG_STA_YMD_HOSEI_UM
, EKK0021B502CBSMsg1List.KK0161_SVC_PAUSE_CHRG_STA_YMD
, EKK0021B502CBSMsg1List.KK0161_PNLTY_HASSEI_CD
, EKK0021B502CBSMsg1List.KK0161_IDO_DIV
, EKK0021B502CBSMsg1List.KK0161_SHOSA_DSL_FIN_CD
, EKK0021B502CBSMsg1List.KK0161_SVCTK_BUT_DEL_TRN_JSSI_DTM
, EKK0021B502CBSMsg1List.KK0161_LAST_UPD_DTM
, EKK0021B502CBSMsg1List.KK0171_SVC_KEI_UCWK_NO
, EKK0021B502CBSMsg1List.KK0171_GENE_ADD_DTM
, EKK0021B502CBSMsg1List.KK0171_SHK_ISP_NINSHO_ID_PWD
, EKK0021B502CBSMsg1List.KK0171_ISP_NINSHO_ID
, EKK0021B502CBSMsg1List.KK0171_ISP_NINSHO_ID_PWD
, EKK0021B502CBSMsg1List.KK0171_TK_TAIIKI_CD
, EKK0021B502CBSMsg1List.KK0171_RSV_APLY_CD
, EKK0021B502CBSMsg1List.KK0171_LAST_UPD_DTM
, EKK0021B502CBSMsg1List.KK0021_KEI_HUKA_CD
, EKK0021B502CBSMsg1List.KK0021_MANSSBSYS_RNKI_YO_KIJIRAN
, EKK0021B502CBSMsg1List.KK0021_MANSION_ID
, EKK0021B502CBSMsg1List.KK0021_CATID
, EKK0021B502CBSMsg1List.KK0021_MKM_UK_SBT_CD
, EKK0021B502CBSMsg1List.KK0021_MSKMSHO_TRAT_IF_TNTSHA_NM
, EKK0021B502CBSMsg1List.KK0021_MSKMSHO_TRAT_IF_TELNO
, EKK0021B502CBSMsg1List.KK0021_HNIN_CFM_ATICLE_NM
, EKK0021B502CBSMsg1List.KK0081_SEIRI_NO
, EKK0021B502CBSMsg1List.KK0021_UPD_DTM
, EKK0021B502CBSMsg1List.KK0081_UPD_DTM
// ANK-3136-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0021_TSYRN_KJ_RRKS_NM
, EKK0021B502CBSMsg1List.KK0021_TSYRN_KJ_RRKS_TLN
, EKK0021B502CBSMsg1List.KK0021_TSYRN_TAKCHO_JI_RRKS_NM
, EKK0021B502CBSMsg1List.KK0021_TSYRN_TAKCHO_JI_RRKS_TLN
, EKK0021B502CBSMsg1List.KK0021_TSYRN_RRK_KIBO_DATE
, EKK0021B502CBSMsg1List.KK0021_TSYRN_TAKCHO_YH
, EKK0021B502CBSMsg1List.KK0021_TSYRN_MAP_UM
, EKK0021B502CBSMsg1List.KK0021_TSYRN_KZN_KEI_INF
, EKK0021B502CBSMsg1List.KK0021_TSYRN_HBI_KAISHOU_YMD
, EKK0021B502CBSMsg1List.KK0021_EQUIP_RYUYO_UM
, EKK0021B502CBSMsg1List.KK0021_RYUYO_MOTO_KJAK_NO
, EKK0021B502CBSMsg1List.KK0021_SBRY_KJ_FIN_KIBOYMD
// ANK-3136-00-00 ADD END
// ANK-4096-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0021_NOW_USE_SK_KEI_KISN_DIV
, EKK0021B502CBSMsg1List.KK0021_KIKI_SETPLC_CHGUM
, EKK0021B502CBSMsg1List.KK0021_DOJITU_JSSI_KBUM
, EKK0021B502CBSMsg1List.KK0021_EARLY_OPEN_EARLY_RRK_KBUM
// ANK-4096-00-00 ADD END
// ANK-4174-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0021_DNSKH_DOI_UM
// ANK-4174-00-00 ADD END
// ANK-4088-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0021_TAKCHO_APO_KADEN_KIBO_UM
// ANK-4088-00-00 ADD END
// ANK-4468-09-00 ADD START
, EKK0021B502CBSMsg1List.KK0091_NRKEMT_SVKEI_NO
, EKK0021B502CBSMsg1List.NRKEMT_KK0081_PCRS_CD
// ANK-4468-09-00 ADD END
// ANK-4427-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0091_WAO_HAKEN_YH_KIBO
, EKK0021B502CBSMsg1List.KK0091_WAO_KOJI_KIBO_YMD_1
, EKK0021B502CBSMsg1List.KK0091_WAO_KOJI_KIBO_TIMEZ_1
, EKK0021B502CBSMsg1List.KK0091_WAO_KOJI_KIBO_YMD_2
, EKK0021B502CBSMsg1List.KK0091_WAO_KOJI_KIBO_TIMEZ_2
, EKK0021B502CBSMsg1List.KK0091_WAO_KOJI_KIBO_YMD_3
, EKK0021B502CBSMsg1List.KK0091_WAO_KOJI_KIBO_TIMEZ_3
, EKK0021B502CBSMsg1List.KK0091_WAO_KOCOMP_RRK_JIKO
, EKK0021B502CBSMsg1List.KK0091_WAO_TENYO_DIV
, EKK0021B502CBSMsg1List.KK0091_WAO_TENYO_SHODAKU_NO
, EKK0021B502CBSMsg1List.KK0091_WAO_YK_KIGEN
, EKK0021B502CBSMsg1List.KK0091_WAO_AD_BNCHI_MEMO
// ANK-4427-00-00 ADD END
// ANK-4427-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0791_NTTORS_DIV
// ANK-4427-00-00 ADD END
// ANK-4640-00-00 ADD START
, EKK0021B502CBSMsg1List.KK0021_WAO_CHUMN_RNKI_YOKSI_FLG
// ANK-4640-00-00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK0021B502CBSMsg1List",0);
if (outMsg1.length > 0)
{
String lastUpdDtm1 = null;
String lastUpdDtm2 = null;
String lastUpdDtm3 = null;
String lastUpdDtm4 = null;
String lastUpdDtm5 = null;
for (int i=0; outMsg1.length>i; i++)
{
// 検索結果に"申込番号"が設定されていた場合
if (!outMsg1[i].isNull(EKK0021B502CBSMsg1List.KK0021_MSKM_NO))
{
lastUpdDtm1 = new JKKejbExclusiveProcKK0011().getLastUpdDtmMskmNo(inMsg,
outMsg1[i].getString(EKK0021B502CBSMsg1List.KK0021_MSKM_NO));
}
// 取得した最大最終更新年月日時分秒を設定
outMsg1[i].set(EKK0021B502CBSMsg1List.KK0021_LAST_UPD_DTM, lastUpdDtm1);
// 検索結果に"サービス契約番号"が設定されていた場合
if (!outMsg1[i].isNull(EKK0021B502CBSMsg1List.KK0081_SVC_KEI_NO))
{
lastUpdDtm2 = new JKKejbExclusiveProcKK2111().getLastUpdDtmSvcKeiNo(inMsg,
outMsg1[i].getString(EKK0021B502CBSMsg1List.KK0081_SVC_KEI_NO));
}
// 取得した最大最終更新年月日時分秒を設定
outMsg1[i].set(EKK0021B502CBSMsg1List.KK0081_LAST_UPD_DTM, lastUpdDtm2);
// 検索結果に"サービス契約番号"が設定されていた場合
if (!outMsg1[i].isNull(EKK0021B502CBSMsg1List.KK0091_SVC_KEI_NO))
{
lastUpdDtm3 = new JKKejbExclusiveProcKK2111().getLastUpdDtmSvcKeiNo(inMsg,
outMsg1[i].getString(EKK0021B502CBSMsg1List.KK0091_SVC_KEI_NO));
}
// 取得した最大最終更新年月日時分秒を設定
outMsg1[i].set(EKK0021B502CBSMsg1List.KK0091_LAST_UPD_DTM, lastUpdDtm3);
// 検索結果に"サービス契約番号"が設定されていた場合
if (!outMsg1[i].isNull(EKK0021B502CBSMsg1List.KK0161_SVC_KEI_NO))
{
lastUpdDtm4 = new JKKejbExclusiveProcKK2111().getLastUpdDtmSvcKeiNo(inMsg,
outMsg1[i].getString(EKK0021B502CBSMsg1List.KK0161_SVC_KEI_NO));
}
// 取得した最大最終更新年月日時分秒を設定
outMsg1[i].set(EKK0021B502CBSMsg1List.KK0161_LAST_UPD_DTM, lastUpdDtm4);
// 検索結果に"サービス契約内訳番号"が設定されていた場合
if (!outMsg1[i].isNull(EKK0021B502CBSMsg1List.KK0171_SVC_KEI_UCWK_NO))
{
lastUpdDtm5 = new JKKejbExclusiveProcKK0161().getLastUpdDtmSvcKeiUcwkNo(inMsg,
outMsg1[i].getString(EKK0021B502CBSMsg1List.KK0171_SVC_KEI_UCWK_NO));
}
// 取得した最大最終更新年月日時分秒を設定
outMsg1[i].set(EKK0021B502CBSMsg1List.KK0171_LAST_UPD_DTM, lastUpdDtm5);
}
}
// inMsg(CBSMsg)に明細をセット
inMsg.set("EKK0021B502CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EKK0021B502CBSMsg.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(EKK0021B502CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}