/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEKU0011A010TPDA
* ソースファイル名：JSYejbEKU0011A010TPDA.java
* 作成者 ：EK959724
* 日付 ：2021年10月07日
*＜機能概要＞
* 工事案件一意照会テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* v60.00.00 2022/05/16 FJ)Carl ANK-4244-00-00_【eo定期】MT既設賃貸対応
* v60.00.00 2022/07/01 FJ)アら 【ANK-4269-00-00】マンション卸回線(WI-FIスキーム)の不備対応 STEP2
* v71.00.00 2024/04/22 FJ)明石 【ANK-4468-00-00】eo光ネット「シンプルプラン」追加対応
********************************************************************************/
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.EKU0011A010CBSMsg;
import eo.ejb.cbs.cbsmsg.EKU0011A010CBSMsg1List;
import eo.ejb.cbm.entity.KU0011ETMsg;
/**
*
* テンプレートDBアクセス部品 EKU0011A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEKU0011A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEKU0011A010TPDA() {
}
/**
* EKU0011A010_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(KU0011ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT KU0011.KOJIAK_NO ")
.append(" ,KU0011.KOJIAK_STAT ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00474' ")
.append(" AND KU0011.KOJIAK_STAT = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJIAK_STAT_NM ")
.append(" ,KU0011.AD_CHG_NEWESTA_KJAK_NO ")
.append(" ,KU0011.AD_CHG_TEKKYO_KJAK_NO ")
.append(" ,KU0011.SYSID ")
.append(" ,KU0011.RNKI_SVC_KEI_NO ")
.append(" ,KU0011.OWNR_KEI_NO ")
.append(" ,KU0011.PID ")
.append(" ,KU0011.SEIKY_KEI_NO ")
.append(" ,KU0011.KOJIAK_SBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00577' ")
.append(" AND KU0011.KOJIAK_SBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJIAK_SBT_NM ")
.append(" ,KU0011.PRC_GRP_CD ")
.append(" ,CASE ")
.append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ")
.append(" THEN (SELECT KK0781.PRC_GRP_NM FROM KK_M_PRC_GRP KK0781 ")
.append(" WHERE ")
.append(" KU0011.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0781.PRC_GRP_TSTAYMD AND KK0781.PRC_GRP_TENDYMD ")
.append(" AND KK0781.MK_FLG = '0') ")
.append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ")
.append(" THEN (SELECT KK0781.PRC_GRP_NM FROM KK_M_PRC_GRP KK0781 ")
.append(" WHERE ")
.append(" KU0011.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0781.PRC_GRP_TSTAYMD AND KK0781.PRC_GRP_TENDYMD ")
.append(" AND KK0781.MK_FLG = '0') ")
.append(" ELSE (SELECT KK0781.PRC_GRP_NM FROM KK_M_PRC_GRP KK0781 ")
.append(" WHERE ")
.append(" KU0011.PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KK0781.PRC_GRP_TENDYMD = '20991231' ")
.append(" AND KK0781.MK_FLG = '0') ")
.append(" END PRC_GRP_NM ")
.append(" ,KU0011.PCRS_CD ")
.append(" ,CASE ")
.append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ")
.append(" THEN (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ")
.append(" WHERE ")
.append(" KU0011.PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0791.PCRS_TSTAYMD AND KK0791.PCRS_TENDYMD ")
.append(" AND KK0791.MK_FLG = '0') ")
.append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ")
.append(" THEN (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ")
.append(" WHERE ")
.append(" KU0011.PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0791.PCRS_TSTAYMD AND KK0791.PCRS_TENDYMD ")
.append(" AND KK0791.MK_FLG = '0') ")
.append(" ELSE (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ")
.append(" WHERE ")
.append(" KU0011.PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KK0791.PCRS_TENDYMD = '20991231' ")
.append(" AND KK0791.MK_FLG = '0') ")
.append(" END PCRS_NM ")
.append(" ,KU0011.PPLAN_CD ")
.append(" ,CASE ")
.append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ")
.append(" THEN (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ")
.append(" WHERE ")
.append(" KU0011.PCRS_CD = KK0591.PCRS_CD ")
.append(" AND KU0011.PPLAN_CD = KK0591.PPLAN_CD ")
.append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0591.PPLAN_TSTAYMD AND KK0591.PPLAN_TENDYMD ")
.append(" AND KK0591.MK_FLG = '0') ")
.append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ")
.append(" THEN (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ")
.append(" WHERE ")
.append(" KU0011.PCRS_CD = KK0591.PCRS_CD ")
.append(" AND KU0011.PPLAN_CD = KK0591.PPLAN_CD ")
.append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0591.PPLAN_TSTAYMD AND KK0591.PPLAN_TENDYMD ")
.append(" AND KK0591.MK_FLG = '0') ")
.append(" ELSE (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ")
.append(" WHERE ")
.append(" KU0011.PCRS_CD = KK0591.PCRS_CD ")
.append(" AND KU0011.PPLAN_CD = KK0591.PPLAN_CD ")
.append(" AND KK0591.PPLAN_TENDYMD = '20991231' ")
.append(" AND KK0591.MK_FLG = '0') ")
.append(" END PPLAN_NM ")
.append(" ,KU0011.WRIB_TYPE_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00284' ")
.append(" AND KU0011.WRIB_TYPE_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )WRIB_TYPE_NM ")
.append(" ,KU0011.HOJIN_PRC_GRP_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00886' ")
.append(" AND KU0011.HOJIN_PRC_GRP_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )HOJIN_PRC_GRP_NM ")
.append(" ,KU0011.HOJIN_PCRS_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00887' ")
.append(" AND KU0011.HOJIN_PCRS_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )HOJIN_PCRS_NM ")
.append(" ,KU0011.HOJIN_PPLAN_CD ")
.append(" ,'' HOJIN_PPLAN_NM ")
.append(" ,KU0011.UPD_TRGT_KOJIAK_NO ")
.append(" ,KU0011.KSI_DSL_KOJIAK_SAKSEI_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.KSI_DSL_KOJIAK_SAKSEI_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KSI_DSL_KOJIAK_SAKSEI_YH_NM ")
.append(" ,KU0011.OPMS_CHGE_RNKI_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.OPMS_CHGE_RNKI_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPMS_CHGE_RNKI_YH_NM ")
.append(" ,KU0011.FCDS_CHGE_RNKI_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.FCDS_CHGE_RNKI_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )FCDS_CHGE_RNKI_YH_NM ")
.append(" ,KU0011.FCDS_DSL_RNKI_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.FCDS_DSL_RNKI_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )FCDS_DSL_RNKI_YH_NM ")
.append(" ,KU0011.FCDS_RNKI_SBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00699' ")
.append(" AND KU0011.FCDS_RNKI_SBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )FCDS_RNKI_SBT_NM ")
.append(" ,KU0011.FCDS_RNKI_SBT_CHGE_DTM ")
.append(" ,KU0011.FCDS_ZNKI_RNKI_SVC_KEI_NO ")
.append(" ,KU0011.GENESIS_CHGE_RNKI_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.GENESIS_CHGE_RNKI_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )GENESIS_CHGE_RNKI_YH_NM ")
.append(" ,KU0011.GENESIS_DSL_RNKI_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.GENESIS_DSL_RNKI_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )GENESIS_DSL_RNKI_YH_NM ")
.append(" ,KU0011.GENESIS_RNKI_SBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00699' ")
.append(" AND KU0011.GENESIS_RNKI_SBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )GENESIS_RNKI_SBT_NM ")
.append(" ,KU0011.GENESIS_RNKI_SBT_CHGE_DTM ")
.append(" ,KU0011.GENESIS_ZNKI_RNKI_SVKEI_NO ")
.append(" ,KU0011.US_KANRI_RNKI_SVC_KEI_NO ")
.append(" ,KU0011.RNKI_SVC_DSL_SBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00693' ")
.append(" AND KU0011.RNKI_SVC_DSL_SBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )RNKI_SVC_DSL_SBT_NM ")
.append(" ,KU0011.RNKI_SVC_STAYMD ")
.append(" ,KU0011.RNKI_SVC_ENDYMD ")
.append(" ,KU0011.RNKI_SVC_CANCEL_YMD ")
.append(" ,KU0011.RCNT_KIHON_KOJI_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00882' ")
.append(" AND KU0011.RCNT_KIHON_KOJI_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )RCNT_KIHON_KOJI_FLG_NM ")
.append(" ,KU0011.ADD_SVC_KEI_NO ")
.append(" ,KU0011.AREA_CHK_JUDGE_YMD ")
.append(" ,KU0011.MSKM_UK_YMD ")
.append(" ,KU0011.MSKMSHO_ARIV_YMD ")
.append(" ,KU0011.PLACE_NO ")
.append(" ,KU0011.KOJI_KIBO_YMD ")
.append(" ,KU0011.TENTAKU_SAKI_AD_CD ")
.append(" ,KU0011.TENTAKU_SAKI_PCD ")
.append(" ,KU0011.TENTAKU_SAKI_STATE_NM ")
.append(" ,KU0011.TENTAKU_SAKI_CITY_NM ")
.append(" ,KU0011.TENTAKU_SAKI_OAZTSU_NM ")
.append(" ,KU0011.TENTAKU_SAKI_AZCHO_NM ")
.append(" ,KU0011.TENTAKU_SAKI_AD_BNCHIGO ")
.append(" ,KU0011.TENTAKU_SAKI_ADRTTM ")
.append(" ,KU0011.TENTAKU_SAKI_ADRRM ")
.append(" ,KU0011.AD_CHG_FIX_DTM ")
.append(" ,KU0011.MSKMSHA_NM ")
.append(" ,KU0011.CUST_NM ")
.append(" ,KU0011.CUST_KANA ")
.append(" ,KU0011.CUST_HOME_TELNO ")
.append(" ,KU0011.CUST_KTAI_TELNO ")
.append(" ,KU0011.CUST_RRKS_TELNO ")
.append(" ,KU0011.RRKS_OFFC_NM ")
.append(" ,KU0011.OPEN_AF_TEL_USE_KIBO_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.OPEN_AF_TEL_USE_KIBO_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPEN_AF_TEL_USE_KIBO_UM_NM ")
.append(" ,KU0011.KEISHA_AD_CD ")
.append(" ,KU0011.KEISHA_PCD ")
.append(" ,KU0011.KEISHA_STATE_NM ")
.append(" ,KU0011.KEISHA_CITY_NM ")
.append(" ,KU0011.KEISHA_OAZTSU_NM ")
.append(" ,KU0011.KEISHA_AZCHO_NM ")
.append(" ,KU0011.KEISHA_AD_BNCHIGO ")
.append(" ,KU0011.KEISHA_ADRTTM ")
.append(" ,KU0011.KEISHA_ADRRM ")
.append(" ,KU0011.KEISHA_AD_MAN_INPUT_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01239' ")
.append(" AND KU0011.KEISHA_AD_MAN_INPUT_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KEISHA_AD_MAN_INPUT_FLG_NM ")
.append(" ,KU0011.TENTAKU_BF_AD_CD ")
.append(" ,KU0011.TENTAKU_BF_PCD ")
.append(" ,KU0011.TENTAKU_BF_STATE_NM ")
.append(" ,KU0011.TENTAKU_BF_CITY_NM ")
.append(" ,KU0011.TENTAKU_BF_OAZTSU_NM ")
.append(" ,KU0011.TENTAKU_BF_AZCHO_NM ")
.append(" ,KU0011.TENTAKU_BF_AD_BNCHIGO ")
.append(" ,KU0011.TENTAKU_BF_ADRTTM ")
.append(" ,KU0011.TENTAKU_BF_ADRRM ")
.append(" ,KU0011.KEPCO_CUSTINFO_JUJU_DOI_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00558' ")
.append(" AND KU0011.KEPCO_CUSTINFO_JUJU_DOI_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KEPCO_CUSTINFO_JUJU_DOI_UM_NM ")
.append(" ,KU0011.MANSION_BUKKEN_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01228' ")
.append(" AND KU0011.MANSION_BUKKEN_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )MANSION_BUKKEN_NM ")
.append(" ,KU0011.AD_FORM_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00627' ")
.append(" AND KU0011.AD_FORM_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )AD_FORM_NM ")
.append(" ,KU0011.KUKAKU_SEIRI_CHU_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.KUKAKU_SEIRI_CHU_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KUKAKU_SEIRI_CHU_FLG_NM ")
.append(" ,KU0011.KOJI_SAKI_AD_MI_FIX_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00467' ")
.append(" AND KU0011.KOJI_SAKI_AD_MI_FIX_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJI_SAKI_AD_MI_FIX_FLG_NM ")
.append(" ,KU0011.KOJIAK_REQYMD ")
.append(" ,KU0011.TAKNI_KOJI_FIN_RSV_YMD ")
.append(" ,KU0011.TAKNIKJ_WORK_STA_HM ")
.append(" ,KU0011.KOJI_TUGO_DOJI_BMP_KH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00003' ")
.append(" AND KU0011.KOJI_TUGO_DOJI_BMP_KH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJI_TUGO_DOJI_BMP_KH_NM ")
.append(" ,KU0011.BMP_DOJI_KOJI_JSSI_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.BMP_DOJI_KOJI_JSSI_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )BMP_DOJI_KOJI_JSSI_FLG_NM ")
.append(" ,KU0011.DOJI_BMP_KIBO_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.DOJI_BMP_KIBO_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )DOJI_BMP_KIBO_UM_NM ")
.append(" ,KU0011.CHBF_TAKNIKJ_FIN_RSV_YMD ")
.append(" ,KU0011.CHBF_TAKNIKJ_WORK_STA_HM ")
.append(" ,KU0011.CHBF_KOJI_TUGO_DOJI_BMP_KH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00003' ")
.append(" AND KU0011.CHBF_KOJI_TUGO_DOJI_BMP_KH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )CHBF_KOJI_TUGO_DOJI_BMP_KH_NM ")
.append(" ,KU0011.CHBF_BMP_DKOJI_JSSI_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.CHBF_BMP_DKOJI_JSSI_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )CHBF_BMP_DKOJI_JSSI_FLG_NM ")
.append(" ,KU0011.CHBF_DOJI_BMP_KIBO_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.CHBF_DOJI_BMP_KIBO_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )CHBF_DOJI_BMP_KIBO_UM_NM ")
.append(" ,KU0011.OPMS_TNKJ_LAST_RSPNS_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00481' ")
.append(" AND KU0011.OPMS_TNKJ_LAST_RSPNS_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPMS_TNKJ_LAST_RSPNS_NM ")
.append(" ,KU0011.KOJIAK_FIN_RSV_YMD ")
.append(" ,KU0011.LGTD ")
.append(" ,KU0011.LTTD ")
.append(" ,KU0011.XZAHYO_6 ")
.append(" ,KU0011.YZAHYO_6 ")
.append(" ,KU0011.XZAHYO_5 ")
.append(" ,KU0011.YZAHYO_5 ")
.append(" ,KU0011.ZAHYO_HOSEI_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.ZAHYO_HOSEI_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )ZAHYO_HOSEI_UM_NM ")
.append(" ,KU0011.SHUNKO_RSV_YMD ")
.append(" ,KU0011.NYUKYO_RSV_YMD ")
.append(" ,KU0011.HIKIWATASHI_RSV_YMD ")
.append(" ,KU0011.EPOWER_SODEN_RSV_YMD ")
.append(" ,KU0011.NEWCONST_BUKKEN_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00480' ")
.append(" AND KU0011.NEWCONST_BUKKEN_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )NEWCONST_BUKKEN_NM ")
.append(" ,KU0011.NYUKYO_FLR_CNT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00345' ")
.append(" AND KU0011.NYUKYO_FLR_CNT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )NYUKYO_FLR_CNT_NM ")
.append(" ,KU0011.KCKU_FLR_CNT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00840' ")
.append(" AND KU0011.KCKU_FLR_CNT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KCKU_FLR_CNT_NM ")
.append(" ,KU0011.DIRECTION_CD_1 ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00741' ")
.append(" AND KU0011.DIRECTION_CD_1 = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )DIRECTION_1_NM ")
.append(" ,KU0011.DIRECTION_CD_2 ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00741' ")
.append(" AND KU0011.DIRECTION_CD_2 = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )DIRECTION_2_NM ")
.append(" ,KU0011.DOJI_DAIHYO_KOJIAK_NO ")
.append(" ,KU0011.TV_KEI_SHOSA_STAY_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.TV_KEI_SHOSA_STAY_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TV_KEI_SHOSA_STAY_UM_NM ")
.append(" ,KU0011.TEL_RRK_KIBO_YMD ")
.append(" ,KU0011.TEL_RRK_KIBO_TIME_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00560' ")
.append(" AND KU0011.TEL_RRK_KIBO_TIME_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TEL_RRK_KIBO_TIME_NM ")
.append(" ,KU0011.TAKCHO_KIBO_APO_KIGEN_YMD ")
.append(" ,KU0011.TNKJ_KIBO_APO_KIGEN_YMD ")
.append(" ,KU0011.KOJI_APO_RRKS_SHITEI_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00254' ")
.append(" AND KU0011.KOJI_APO_RRKS_SHITEI_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJI_APO_RRKS_SHITEI_NM ")
.append(" ,KU0011.KOJI_APO_RRKS_TELNO ")
.append(" ,KU0011.RRK_WAY_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00251' ")
.append(" AND KU0011.RRK_WAY_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )RRK_WAY_NM ")
.append(" ,KU0011.RRK_WAY_HOKI ")
.append(" ,KU0011.NECESSARY_HOJO_CD ")
.append(" ,'' NECESSARY_HOJO_NM ")
.append(" ,KU0011.OPSVKEI_HKTGI_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00771' ")
.append(" AND KU0011.OPSVKEI_HKTGI_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPSVKEI_HKTGI_FLG_NM ")
.append(" ,KU0011.OPMS_RNKI_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00481' ")
.append(" AND KU0011.OPMS_RNKI_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPMS_RNKI_NM ")
.append(" ,KU0011.BF_OPMS_RNKI_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00481' ")
.append(" AND KU0011.BF_OPMS_RNKI_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )BF_OPMS_RNKI_NM ")
.append(" ,KU0011.OPMS_RNKI_CD_CHGE_YMD ")
.append(" ,KU0011.BF_KOJIAK_STAT ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00474' ")
.append(" AND KU0011.BF_KOJIAK_STAT = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )BF_KOJIAK_STAT_NM ")
.append(" ,KU0011.KOJIAK_STAT_CHGE_YMD ")
.append(" ,KU0011.ADD_MOTO_PRC_GRP_CD ")
.append(" ,CASE ")
.append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ")
.append(" THEN (SELECT KK0781.PRC_GRP_NM FROM KK_M_PRC_GRP KK0781 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0781.PRC_GRP_TSTAYMD AND KK0781.PRC_GRP_TENDYMD ")
.append(" AND KK0781.MK_FLG = '0') ")
.append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ")
.append(" THEN (SELECT KK0781.PRC_GRP_NM FROM KK_M_PRC_GRP KK0781 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0781.PRC_GRP_TSTAYMD AND KK0781.PRC_GRP_TENDYMD ")
.append(" AND KK0781.MK_FLG = '0') ")
.append(" ELSE (SELECT KK0781.PRC_GRP_NM FROM KK_M_PRC_GRP KK0781 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PRC_GRP_CD = KK0781.PRC_GRP_CD ")
.append(" AND KK0781.PRC_GRP_TENDYMD = '20991231' ")
.append(" AND KK0781.MK_FLG = '0') ")
.append(" END ADD_MOTO_PRC_GRP_NM ")
.append(" ,KU0011.ADD_MOTO_PCRS_CD ")
.append(" ,CASE ")
.append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ")
.append(" THEN (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0791.PCRS_TSTAYMD AND KK0791.PCRS_TENDYMD ")
.append(" AND KK0791.MK_FLG = '0') ")
.append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ")
.append(" THEN (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0791.PCRS_TSTAYMD AND KK0791.PCRS_TENDYMD ")
.append(" AND KK0791.MK_FLG = '0') ")
.append(" ELSE (SELECT KK0791.PCRS_NM FROM KK_M_PCRS KK0791 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PCRS_CD = KK0791.PCRS_CD ")
.append(" AND KK0791.PCRS_TENDYMD = '20991231' ")
.append(" AND KK0791.MK_FLG = '0') ")
.append(" END ADD_MOTO_PCRS_NM ")
.append(" ,KU0011.ADD_MOTO_PPLAN_CD ")
.append(" ,CASE ")
.append(" WHEN KU0011.KOJIAK_REQYMD IS NOT NULL ")
.append(" THEN (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PCRS_CD = KK0591.PCRS_CD ")
.append(" AND KU0011.ADD_MOTO_PPLAN_CD = KK0591.PPLAN_CD ")
.append(" AND KU0011.KOJIAK_REQYMD BETWEEN KK0591.PPLAN_TSTAYMD AND KK0591.PPLAN_TENDYMD ")
.append(" AND KK0591.MK_FLG = '0') ")
.append(" WHEN KU0011.MSKM_UK_YMD IS NOT NULL ")
.append(" THEN (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PCRS_CD = KK0591.PCRS_CD ")
.append(" AND KU0011.ADD_MOTO_PPLAN_CD = KK0591.PPLAN_CD ")
.append(" AND KU0011.MSKM_UK_YMD BETWEEN KK0591.PPLAN_TSTAYMD AND KK0591.PPLAN_TENDYMD ")
.append(" AND KK0591.MK_FLG = '0') ")
.append(" ELSE (SELECT KK0591.PPLAN_NM FROM KK_M_PPLAN KK0591 ")
.append(" WHERE ")
.append(" KU0011.ADD_MOTO_PCRS_CD = KK0591.PCRS_CD ")
.append(" AND KU0011.ADD_MOTO_PPLAN_CD = KK0591.PPLAN_CD ")
.append(" AND KK0591.PPLAN_TENDYMD = '20991231' ")
.append(" AND KK0591.MK_FLG = '0') ")
.append(" END ADD_MOTO_PPLAN_NM ")
.append(" ,KU0011.ADD_MOTO_WRIB_TYPE_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00284' ")
.append(" AND KU0011.ADD_MOTO_WRIB_TYPE_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )ADD_MOTO_WRIB_TYPE_NM ")
.append(" ,KU0011.ADD_MOTO_KOJIAK_SBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00577' ")
.append(" AND KU0011.ADD_MOTO_KOJIAK_SBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )ADD_MOTO_KOJIAK_SBT_NM ")
.append(" ,KU0011.KOJI_UK_OPTNTY_IDO_DIV ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00576' ")
.append(" AND KU0011.KOJI_UK_OPTNTY_IDO_DIV = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJI_UK_OPTNTY_IDO_DIV_NM ")
.append(" ,KU0011.KOJI_UK_OPTNTY_IDO_DTM ")
.append(" ,KU0011.KOJIAK_UK_USER_ID ")
.append(" ,KU0011.KOJIAK_STP_TNT_USER_ID ")
.append(" ,KU0011.LAST_RSP_RSLT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00694' ")
.append(" AND KU0011.LAST_RSP_RSLT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )LAST_RSP_RSLT_NM ")
.append(" ,KU0011.LAST_RSP_RSLT_CD_CHG_YMD ")
.append(" ,KU0011.LAST_RSP_RSLT_OPMS_RNKI_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00481' ")
.append(" AND KU0011.LAST_RSP_RSLT_OPMS_RNKI_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )LAST_RSP_RSLT_OPMS_RNKI_NM ")
.append(" ,KU0011.TAKCHO_KIBO_YMD ")
.append(" ,KU0011.TAKCHO_KIBO_TIME_CD ")
.append(" ,'' TAKCHO_KIBO_TIME_NM ")
.append(" ,KU0011.TAKCHO_JUDGE_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00695' ")
.append(" AND KU0011.TAKCHO_JUDGE_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TAKCHO_JUDGE_NM ")
.append(" ,KU0011.TAKCHO_JSSI_YMD ")
.append(" ,KU0011.KOJIAK_RRK_JIKO ")
.append(" ,KU0011.KOJIAK_BIKO_1 ")
.append(" ,KU0011.KOJIAK_BIKO_2 ")
.append(" ,KU0011.TAKCHO_FIN_YMD ")
.append(" ,KU0011.TAKCHO_SHODAKS_KAISHU_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00566' ")
.append(" AND KU0011.TAKCHO_SHODAKS_KAISHU_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TAKCHO_SHODAKS_KAISHU_NM ")
.append(" ,KU0011.TAKCHO_SHODAKS_RCP_YMD ")
.append(" ,KU0011.SKKK_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00567' ")
.append(" AND KU0011.SKKK_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )SKKK_NM ")
.append(" ,KU0011.SKKK_MEMO ")
.append(" ,KU0011.DSGN_FIN_YMD ")
.append(" ,KU0011.SKKK_ETM_DSGN_RPT_YMD ")
.append(" ,KU0011.SKKK_KOJI_NYO_CFMS_RCP_YMD ")
.append(" ,KU0011.KITEN_HDSHO_CD ")
.append(" ,KU0011.HISOS_BUIOFFC_KOJI_COMP_CD ")
.append(" ,(SELECT ZM0381.KOJI_COMP_NM ")
.append(" FROM ZM_M_KOJI_COMP ZM0381 ")
.append(" WHERE ZM0381.KOJI_COMP_CD = KU0011.HISOS_BUIOFFC_KOJI_COMP_CD ")
.append(" AND ZM0381.MK_FLG = '0' ")
.append(" )HISOS_BUIOFFC_KOJI_COMP_NM ")
.append(" ,KU0011.KEPCO_BUSIOFFICE_CD ")
.append(" ,KU0011.KKSHKA_RSVD_SNSTSTD_YMD ")
.append(" ,KU0011.KOJI_RSV_DSGN_BUNSHO_NO ")
.append(" ,KU0011.KOJI_RSV_MSKM_FORM_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00679' ")
.append(" AND KU0011.KOJI_RSV_MSKM_FORM_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJI_RSV_MSKM_FORM_NM ")
.append(" ,KU0011.HAISO_SAKSEI_ZUMI_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00581' ")
.append(" AND KU0011.HAISO_SAKSEI_ZUMI_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )HAISO_SAKSEI_ZUMI_FLG_NM ")
.append(" ,KU0011.TAKNKIKI_RSV_ADD_YMD ")
.append(" ,KU0011.TTL_TCASE_CNT_GK ")
.append(" ,KU0011.KOCOMP_SHKA_REQ_RCP_YMD ")
.append(" ,KU0011.HAISO_KIGEN_YMD ")
.append(" ,KU0011.KIKI_KNPN_FIN_YMD ")
.append(" ,KU0011.HAISO_ARIV_SHITEI_YMD ")
.append(" ,KU0011.STC_BF_KIKI_KOKAN_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00482' ")
.append(" AND KU0011.STC_BF_KIKI_KOKAN_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )STC_BF_KIKI_KOKAN_FLG_NM ")
.append(" ,KU0011.STC_BF_KIKI_KOKAN_YMD ")
.append(" ,KU0011.KIKI_STC_TEKKYO_YMD ")
.append(" ,KU0011.LOOPBACK_TEST_FIN_YMD ")
.append(" ,KU0011.OPMS_KOJIAK_RSLT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00800' ")
.append(" AND KU0011.OPMS_KOJIAK_RSLT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPMS_KOJIAK_RSLT_NM ")
.append(" ,KU0011.KOJIAK_JSSI_YMD ")
.append(" ,KU0011.KOJIAK_FIN_DTM ")
.append(" ,KU0011.KOJIHI_FIX_YMD ")
.append(" ,KU0011.PON_SBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00211' ")
.append(" AND KU0011.PON_SBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )PON_SBT_NM ")
.append(" ,KU0011.KOJIAK_CANCEL_YMD ")
.append(" ,KU0011.OPMS_KOJIAK_STP_RSLT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00801' ")
.append(" AND KU0011.OPMS_KOJIAK_STP_RSLT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )OPMS_KOJIAK_STP_RSLT_NM ")
.append(" ,KU0011.KOJIAK_STP_CANCEL_PRC_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.KOJIAK_STP_CANCEL_PRC_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJIAK_STP_CANCEL_PRC_UM_NM ")
.append(" ,KU0011.KOJIAK_STP_UK_YMD ")
.append(" ,KU0011.KOJIAK_STP_ADD_YMD ")
.append(" ,KU0011.KOJIAK_STP_YMD ")
.append(" ,KU0011.KOJI_PDING_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.KOJI_PDING_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJI_PDING_UM_NM ")
.append(" ,KU0011.KOJIAK_STP_RSN_CD_1 ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01454' ")
.append(" AND KU0011.KOJIAK_STP_RSN_CD_1 = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJIAK_STP_RSN_NM_1 ")
.append(" ,KU0011.KOJIAK_STP_RSN_CD_2 ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01455' ")
.append(" AND KU0011.KOJIAK_STP_RSN_CD_2 = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KOJIAK_STP_RSN_NM_2 ")
.append(" ,KU0011.PLAN_CHG_FIX_DTM ")
.append(" ,KU0011.KARI_KOJI_REQ_YMD ")
.append(" ,KU0011.GEMBA_WORK_FIN_YMD ")
.append(" ,KU0011.RCNT_SHOKAI_YMD ")
.append(" ,KU0011.WEB_SHOKAI_CNT ")
.append(" ,KU0011.PC_SHOKAI_CNT ")
.append(" ,KU0011.KTAI_SHOKAI_CNT ")
.append(" ,KU0011.TOKUSHU_KOJIAK_SKBT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01188' ")
.append(" AND KU0011.TOKUSHU_KOJIAK_SKBT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TOKUSHU_KOJIAK_SKBT_NM ")
.append(" ,KU0011.ADD_DTM ")
.append(" ,KU0011.ADD_OPEACNT ")
.append(" ,(SELECT ZM0051.USER_NM ")
.append(" FROM ZM_M_USER ZM0051 ")
.append(" WHERE KU0011.ADD_OPEACNT = ZM0051.USER_ID ")
.append(" AND ZM0051.MK_FLG = '0' ")
.append(" )ADD_OPEACNT_NM ")
.append(" ,KU0011.UPD_DTM ")
.append(" ,KU0011.UPD_OPEACNT ")
.append(" ,(SELECT ZM0051.USER_NM ")
.append(" FROM ZM_M_USER ZM0051 ")
.append(" WHERE KU0011.UPD_OPEACNT = ZM0051.USER_ID ")
.append(" AND ZM0051.MK_FLG = '0' ")
.append(" )UPD_OPEACNT_NM ")
.append(" ,KU0011.DEL_DTM ")
.append(" ,KU0011.DEL_OPEACNT ")
.append(" ,(SELECT ZM0051.USER_NM ")
.append(" FROM ZM_M_USER ZM0051 ")
.append(" WHERE KU0011.DEL_OPEACNT = ZM0051.USER_ID ")
.append(" AND ZM0051.MK_FLG = '0' ")
.append(" )DEL_OPEACNT_NM ")
.append(" ,KU0011.MK_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00016' ")
.append(" AND KU0011.MK_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )MK_FLG_NM ")
.append(" ,KU0011.MANS_KOJIAK_STAT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01651' ")
.append(" AND KU0011.MANS_KOJIAK_STAT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )MANS_KOJIAK_STAT_CD_NM ")
.append(" ,KU0011.SMTVL_KEI_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.SMTVL_KEI_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )SMTVL_KEI_UM_NM ")
.append(" ,KJ_KR_CNCL_FLG ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01714' ")
.append(" AND KU0011.KJ_KR_CNCL_FLG = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )KJ_KR_CNCL_FLG_NM ")
.append(" ,KR_CNCL_UK_YMD ")
.append(" ,EQUIP_RYUYO_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
// ANK-4468-00-00 MOD START
//.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01841' ")
// ANK-4468-00-00 MOD END
.append(" AND KU0011.EQUIP_RYUYO_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )EQUIP_RYUYO_UM_NM ")
.append(" ,VONU_RYUYO_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.VONU_RYUYO_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )VONU_RYUYO_UM_NM ")
.append(" ,RYUYO_MT_TEL_KEI_RYKK_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01715' ")
.append(" AND KU0011.RYUYO_MT_TEL_KEI_RYKK_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )RYUYO_MT_TEL_KEI_RYKK_CD_NM ")
.append(" ,RYUYO_MOTO_KJAK_NO ")
.append(" ,SBRY_KJ_FIN_KIBOYMD ")
.append(" ,TSYRN_KJ_RRKS_NM ")
.append(" ,TSYRN_KJ_RRKS_TLN ")
.append(" ,TSYRN_TAKCHO_JI_RRKS_NM ")
.append(" ,TSYRN_TAKCHO_JI_RRKS_TLN ")
.append(" ,TSYRN_RRK_KIBO_DATE ")
.append(" ,TSYRN_KOJI_HI ")
.append(" ,TSYRN_TAKCHO_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.TSYRN_TAKCHO_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TSYRN_TAKCHO_YH_NM ")
.append(" ,TSYRN_SDAKS_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.TSYRN_SDAKS_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TSYRN_SDAKS_YH_NM ")
.append(" ,TSYRN_TACHIAISHA_NM ")
.append(" ,TSYRN_HKKS_SISAK_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.TSYRN_HKKS_SISAK_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TSYRN_HKKS_SISAK_YH_NM ")
.append(" ,TSYRN_CAMPAIGN_INF ")
.append(" ,TSYRN_DOJI_KOJI_INF ")
.append(" ,TSYRN_TTK_JI_NSANK_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.TSYRN_TTK_JI_NSANK_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TSYRN_TTK_JI_NSANK_YH_NM ")
.append(" ,TSYRN_MAP_UM ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00002' ")
.append(" AND KU0011.TSYRN_MAP_UM = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TSYRN_MAP_UM_NM ")
.append(" ,TSYRN_KZN_KEI_INF ")
.append(" ,TSYRN_HBI_KAISHOU_YMD ")
.append(" ,TAKCHO_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.TAKCHO_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )TAKCHO_YH_NM ")
.append(" ,DSGN_YH ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD00001' ")
.append(" AND KU0011.DSGN_YH = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )DSGN_YH_NM ")
.append(" ,RSV_ROZETT_STC_STAT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01770' ")
.append(" AND KU0011.RSV_ROZETT_STC_STAT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )RSV_ROZETT_STC_STAT_NM ")
.append(" ,RSV_CONSNT_STC_NYO_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01771' ")
.append(" AND KU0011.RSV_CONSNT_STC_NYO_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )RSV_CONSNT_STC_NYO_NM ")
.append(" ,ROZETT_STC_RSLT_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01772' ")
.append(" AND KU0011.ROZETT_STC_RSLT_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )ROZETT_STC_RSLT_NM ")
.append(" ,JSK_CONSNT_STC_NYO_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01771' ")
.append(" AND KU0011.JSK_CONSNT_STC_NYO_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )JSK_CONSNT_STC_NYO_NM ")
.append(" ,JSK_TNMT_STC_FLR_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01766' ")
.append(" AND KU0011.JSK_TNMT_STC_FLR_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )JSK_TNMT_STC_FLR_NM ")
.append(" ,JSK_KISN_TD_SETPLC_1_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01767' ")
.append(" AND KU0011.JSK_KISN_TD_SETPLC_1_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )JSK_KISN_TD_SETPLC_1_NM ")
.append(" ,JSK_KISN_TD_SETPLC_2_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01768' ")
.append(" AND KU0011.JSK_KISN_TD_SETPLC_2_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )JSK_KISN_TD_SETPLC_2_NM ")
.append(" ,JSK_KISN_TD_STC_KASHO_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01769' ")
.append(" AND KU0011.JSK_KISN_TD_STC_KASHO_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )JSK_KISN_TD_STC_KASHO_NM ")
.append(" ,JSK_KISN_TD_SETPLC_1_OTR ")
.append(" ,JSK_KISN_TD_SETPLC_2_OTR ")
.append(" ,JSK_KISN_TD_STC_KASHO_OTR ")
.append(" ,JSK_TANMT_STC_MEN_CD ")
.append(" ,(SELECT ZM0171.CD_DIV_NM ")
.append(" FROM ZM_M_CD_NM_KANRI ZM0171 ")
.append(" WHERE ZM0171.CD_SBT_CD = 'CD01773' ")
.append(" AND KU0011.JSK_TANMT_STC_MEN_CD = ZM0171.CD_DIV ")
.append(" AND ZM0171.MK_FLG = '0' ")
.append(" )JSK_TANMT_STC_MEN_NM ")
//ANK-4244-00-00 ADD START
.append(" ,KAISEN_PLACE_RENBAN ")
//ANK-4244-00-00 ADD END;
//ANK-4269-00-00 ADD START
.append(" ,SCM_TYPE_CD ")
.append(" ,SCM_JGS_CD ")
//ANK-4269-00-00 ADD END;
.append(" FROM ")
.append(" KU_T_KOJIAK KU0011 ");
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(EKU0011A010CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" KU0011.KOJIAK_NO = ? ")
.append(" AND KU0011.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(EKU0011A010CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(ＫＥＹ＿工事案件番号を指定)
CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(EKU0011A010CBSMsg.KEY_KOJIAK_NO));
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EKU0011A010CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EKU0011A010CBSMsg1List.KOJIAK_NO
, EKU0011A010CBSMsg1List.KOJIAK_STAT
, EKU0011A010CBSMsg1List.KOJIAK_STAT_NM
, EKU0011A010CBSMsg1List.AD_CHG_NEWESTA_KJAK_NO
, EKU0011A010CBSMsg1List.AD_CHG_TEKKYO_KJAK_NO
, EKU0011A010CBSMsg1List.SYSID
, EKU0011A010CBSMsg1List.RNKI_SVC_KEI_NO
, EKU0011A010CBSMsg1List.OWNR_KEI_NO
, EKU0011A010CBSMsg1List.PID
, EKU0011A010CBSMsg1List.SEIKY_KEI_NO
, EKU0011A010CBSMsg1List.KOJIAK_SBT_CD
, EKU0011A010CBSMsg1List.KOJIAK_SBT_NM
, EKU0011A010CBSMsg1List.PRC_GRP_CD
, EKU0011A010CBSMsg1List.PRC_GRP_NM
, EKU0011A010CBSMsg1List.PCRS_CD
, EKU0011A010CBSMsg1List.PCRS_NM
, EKU0011A010CBSMsg1List.PPLAN_CD
, EKU0011A010CBSMsg1List.PPLAN_NM
, EKU0011A010CBSMsg1List.WRIB_TYPE_CD
, EKU0011A010CBSMsg1List.WRIB_TYPE_NM
, EKU0011A010CBSMsg1List.HOJIN_PRC_GRP_CD
, EKU0011A010CBSMsg1List.HOJIN_PRC_GRP_NM
, EKU0011A010CBSMsg1List.HOJIN_PCRS_CD
, EKU0011A010CBSMsg1List.HOJIN_PCRS_NM
, EKU0011A010CBSMsg1List.HOJIN_PPLAN_CD
, EKU0011A010CBSMsg1List.HOJIN_PPLAN_NM
, EKU0011A010CBSMsg1List.UPD_TRGT_KOJIAK_NO
, EKU0011A010CBSMsg1List.KSI_DSL_KOJIAK_SAKSEI_YH
, EKU0011A010CBSMsg1List.KSI_DSL_KOJIAK_SAKSEI_YH_NM
, EKU0011A010CBSMsg1List.OPMS_CHGE_RNKI_YH
, EKU0011A010CBSMsg1List.OPMS_CHGE_RNKI_YH_NM
, EKU0011A010CBSMsg1List.FCDS_CHGE_RNKI_YH
, EKU0011A010CBSMsg1List.FCDS_CHGE_RNKI_YH_NM
, EKU0011A010CBSMsg1List.FCDS_DSL_RNKI_YH
, EKU0011A010CBSMsg1List.FCDS_DSL_RNKI_YH_NM
, EKU0011A010CBSMsg1List.FCDS_RNKI_SBT_CD
, EKU0011A010CBSMsg1List.FCDS_RNKI_SBT_NM
, EKU0011A010CBSMsg1List.FCDS_RNKI_SBT_CHGE_DTM
, EKU0011A010CBSMsg1List.FCDS_ZNKI_RNKI_SVC_KEI_NO
, EKU0011A010CBSMsg1List.GENESIS_CHGE_RNKI_YH
, EKU0011A010CBSMsg1List.GENESIS_CHGE_RNKI_YH_NM
, EKU0011A010CBSMsg1List.GENESIS_DSL_RNKI_YH
, EKU0011A010CBSMsg1List.GENESIS_DSL_RNKI_YH_NM
, EKU0011A010CBSMsg1List.GENESIS_RNKI_SBT_CD
, EKU0011A010CBSMsg1List.GENESIS_RNKI_SBT_NM
, EKU0011A010CBSMsg1List.GENESIS_RNKI_SBT_CHGE_DTM
, EKU0011A010CBSMsg1List.GENESIS_ZNKI_RNKI_SVKEI_NO
, EKU0011A010CBSMsg1List.US_KANRI_RNKI_SVC_KEI_NO
, EKU0011A010CBSMsg1List.RNKI_SVC_DSL_SBT_CD
, EKU0011A010CBSMsg1List.RNKI_SVC_DSL_SBT_NM
, EKU0011A010CBSMsg1List.RNKI_SVC_STAYMD
, EKU0011A010CBSMsg1List.RNKI_SVC_ENDYMD
, EKU0011A010CBSMsg1List.RNKI_SVC_CANCEL_YMD
, EKU0011A010CBSMsg1List.RCNT_KIHON_KOJI_FLG
, EKU0011A010CBSMsg1List.RCNT_KIHON_KOJI_FLG_NM
, EKU0011A010CBSMsg1List.ADD_SVC_KEI_NO
, EKU0011A010CBSMsg1List.AREA_CHK_JUDGE_YMD
, EKU0011A010CBSMsg1List.MSKM_UK_YMD
, EKU0011A010CBSMsg1List.MSKMSHO_ARIV_YMD
, EKU0011A010CBSMsg1List.PLACE_NO
, EKU0011A010CBSMsg1List.KOJI_KIBO_YMD
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_AD_CD
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_PCD
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_STATE_NM
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_CITY_NM
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_OAZTSU_NM
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_AZCHO_NM
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_AD_BNCHIGO
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_ADRTTM
, EKU0011A010CBSMsg1List.TENTAKU_SAKI_ADRRM
, EKU0011A010CBSMsg1List.AD_CHG_FIX_DTM
, EKU0011A010CBSMsg1List.MSKMSHA_NM
, EKU0011A010CBSMsg1List.CUST_NM
, EKU0011A010CBSMsg1List.CUST_KANA
, EKU0011A010CBSMsg1List.CUST_HOME_TELNO
, EKU0011A010CBSMsg1List.CUST_KTAI_TELNO
, EKU0011A010CBSMsg1List.CUST_RRKS_TELNO
, EKU0011A010CBSMsg1List.RRKS_OFFC_NM
, EKU0011A010CBSMsg1List.OPEN_AF_TEL_USE_KIBO_UM
, EKU0011A010CBSMsg1List.OPEN_AF_TEL_USE_KIBO_UM_NM
, EKU0011A010CBSMsg1List.KEISHA_AD_CD
, EKU0011A010CBSMsg1List.KEISHA_PCD
, EKU0011A010CBSMsg1List.KEISHA_STATE_NM
, EKU0011A010CBSMsg1List.KEISHA_CITY_NM
, EKU0011A010CBSMsg1List.KEISHA_OAZTSU_NM
, EKU0011A010CBSMsg1List.KEISHA_AZCHO_NM
, EKU0011A010CBSMsg1List.KEISHA_AD_BNCHIGO
, EKU0011A010CBSMsg1List.KEISHA_ADRTTM
, EKU0011A010CBSMsg1List.KEISHA_ADRRM
, EKU0011A010CBSMsg1List.KEISHA_AD_MAN_INPUT_FLG
, EKU0011A010CBSMsg1List.KEISHA_AD_MAN_INPUT_FLG_NM
, EKU0011A010CBSMsg1List.TENTAKU_BF_AD_CD
, EKU0011A010CBSMsg1List.TENTAKU_BF_PCD
, EKU0011A010CBSMsg1List.TENTAKU_BF_STATE_NM
, EKU0011A010CBSMsg1List.TENTAKU_BF_CITY_NM
, EKU0011A010CBSMsg1List.TENTAKU_BF_OAZTSU_NM
, EKU0011A010CBSMsg1List.TENTAKU_BF_AZCHO_NM
, EKU0011A010CBSMsg1List.TENTAKU_BF_AD_BNCHIGO
, EKU0011A010CBSMsg1List.TENTAKU_BF_ADRTTM
, EKU0011A010CBSMsg1List.TENTAKU_BF_ADRRM
, EKU0011A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM
, EKU0011A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM_NM
, EKU0011A010CBSMsg1List.MANSION_BUKKEN_CD
, EKU0011A010CBSMsg1List.MANSION_BUKKEN_NM
, EKU0011A010CBSMsg1List.AD_FORM_CD
, EKU0011A010CBSMsg1List.AD_FORM_NM
, EKU0011A010CBSMsg1List.KUKAKU_SEIRI_CHU_FLG
, EKU0011A010CBSMsg1List.KUKAKU_SEIRI_CHU_FLG_NM
, EKU0011A010CBSMsg1List.KOJI_SAKI_AD_MI_FIX_FLG
, EKU0011A010CBSMsg1List.KOJI_SAKI_AD_MI_FIX_FLG_NM
, EKU0011A010CBSMsg1List.KOJIAK_REQYMD
, EKU0011A010CBSMsg1List.TAKNI_KOJI_FIN_RSV_YMD
, EKU0011A010CBSMsg1List.TAKNIKJ_WORK_STA_HM
, EKU0011A010CBSMsg1List.KOJI_TUGO_DOJI_BMP_KH
, EKU0011A010CBSMsg1List.KOJI_TUGO_DOJI_BMP_KH_NM
, EKU0011A010CBSMsg1List.BMP_DOJI_KOJI_JSSI_FLG
, EKU0011A010CBSMsg1List.BMP_DOJI_KOJI_JSSI_FLG_NM
, EKU0011A010CBSMsg1List.DOJI_BMP_KIBO_UM
, EKU0011A010CBSMsg1List.DOJI_BMP_KIBO_UM_NM
, EKU0011A010CBSMsg1List.CHBF_TAKNIKJ_FIN_RSV_YMD
, EKU0011A010CBSMsg1List.CHBF_TAKNIKJ_WORK_STA_HM
, EKU0011A010CBSMsg1List.CHBF_KOJI_TUGO_DOJI_BMP_KH
, EKU0011A010CBSMsg1List.CHBF_KOJI_TUGO_DOJI_BMP_KH_NM
, EKU0011A010CBSMsg1List.CHBF_BMP_DKOJI_JSSI_FLG
, EKU0011A010CBSMsg1List.CHBF_BMP_DKOJI_JSSI_FLG_NM
, EKU0011A010CBSMsg1List.CHBF_DOJI_BMP_KIBO_UM
, EKU0011A010CBSMsg1List.CHBF_DOJI_BMP_KIBO_UM_NM
, EKU0011A010CBSMsg1List.OPMS_TNKJ_LAST_RSPNS_CD
, EKU0011A010CBSMsg1List.OPMS_TNKJ_LAST_RSPNS_NM
, EKU0011A010CBSMsg1List.KOJIAK_FIN_RSV_YMD
, EKU0011A010CBSMsg1List.LGTD
, EKU0011A010CBSMsg1List.LTTD
, EKU0011A010CBSMsg1List.XZAHYO_6
, EKU0011A010CBSMsg1List.YZAHYO_6
, EKU0011A010CBSMsg1List.XZAHYO_5
, EKU0011A010CBSMsg1List.YZAHYO_5
, EKU0011A010CBSMsg1List.ZAHYO_HOSEI_UM
, EKU0011A010CBSMsg1List.ZAHYO_HOSEI_UM_NM
, EKU0011A010CBSMsg1List.SHUNKO_RSV_YMD
, EKU0011A010CBSMsg1List.NYUKYO_RSV_YMD
, EKU0011A010CBSMsg1List.HIKIWATASHI_RSV_YMD
, EKU0011A010CBSMsg1List.EPOWER_SODEN_RSV_YMD
, EKU0011A010CBSMsg1List.NEWCONST_BUKKEN_CD
, EKU0011A010CBSMsg1List.NEWCONST_BUKKEN_NM
, EKU0011A010CBSMsg1List.NYUKYO_FLR_CNT_CD
, EKU0011A010CBSMsg1List.NYUKYO_FLR_CNT_NM
, EKU0011A010CBSMsg1List.KCKU_FLR_CNT_CD
, EKU0011A010CBSMsg1List.KCKU_FLR_CNT_NM
, EKU0011A010CBSMsg1List.DIRECTION_CD_1
, EKU0011A010CBSMsg1List.DIRECTION_1_NM
, EKU0011A010CBSMsg1List.DIRECTION_CD_2
, EKU0011A010CBSMsg1List.DIRECTION_2_NM
, EKU0011A010CBSMsg1List.DOJI_DAIHYO_KOJIAK_NO
, EKU0011A010CBSMsg1List.TV_KEI_SHOSA_STAY_UM
, EKU0011A010CBSMsg1List.TV_KEI_SHOSA_STAY_UM_NM
, EKU0011A010CBSMsg1List.TEL_RRK_KIBO_YMD
, EKU0011A010CBSMsg1List.TEL_RRK_KIBO_TIME_CD
, EKU0011A010CBSMsg1List.TEL_RRK_KIBO_TIME_NM
, EKU0011A010CBSMsg1List.TAKCHO_KIBO_APO_KIGEN_YMD
, EKU0011A010CBSMsg1List.TNKJ_KIBO_APO_KIGEN_YMD
, EKU0011A010CBSMsg1List.KOJI_APO_RRKS_SHITEI_CD
, EKU0011A010CBSMsg1List.KOJI_APO_RRKS_SHITEI_NM
, EKU0011A010CBSMsg1List.KOJI_APO_RRKS_TELNO
, EKU0011A010CBSMsg1List.RRK_WAY_CD
, EKU0011A010CBSMsg1List.RRK_WAY_NM
, EKU0011A010CBSMsg1List.RRK_WAY_HOKI
, EKU0011A010CBSMsg1List.NECESSARY_HOJO_CD
, EKU0011A010CBSMsg1List.NECESSARY_HOJO_NM
, EKU0011A010CBSMsg1List.OPSVKEI_HKTGI_FLG
, EKU0011A010CBSMsg1List.OPSVKEI_HKTGI_FLG_NM
, EKU0011A010CBSMsg1List.OPMS_RNKI_CD
, EKU0011A010CBSMsg1List.OPMS_RNKI_NM
, EKU0011A010CBSMsg1List.BF_OPMS_RNKI_CD
, EKU0011A010CBSMsg1List.BF_OPMS_RNKI_NM
, EKU0011A010CBSMsg1List.OPMS_RNKI_CD_CHGE_YMD
, EKU0011A010CBSMsg1List.BF_KOJIAK_STAT
, EKU0011A010CBSMsg1List.BF_KOJIAK_STAT_NM
, EKU0011A010CBSMsg1List.KOJIAK_STAT_CHGE_YMD
, EKU0011A010CBSMsg1List.ADD_MOTO_PRC_GRP_CD
, EKU0011A010CBSMsg1List.ADD_MOTO_PRC_GRP_NM
, EKU0011A010CBSMsg1List.ADD_MOTO_PCRS_CD
, EKU0011A010CBSMsg1List.ADD_MOTO_PCRS_NM
, EKU0011A010CBSMsg1List.ADD_MOTO_PPLAN_CD
, EKU0011A010CBSMsg1List.ADD_MOTO_PPLAN_NM
, EKU0011A010CBSMsg1List.ADD_MOTO_WRIB_TYPE_CD
, EKU0011A010CBSMsg1List.ADD_MOTO_WRIB_TYPE_NM
, EKU0011A010CBSMsg1List.ADD_MOTO_KOJIAK_SBT_CD
, EKU0011A010CBSMsg1List.ADD_MOTO_KOJIAK_SBT_NM
, EKU0011A010CBSMsg1List.KOJI_UK_OPTNTY_IDO_DIV
, EKU0011A010CBSMsg1List.KOJI_UK_OPTNTY_IDO_DIV_NM
, EKU0011A010CBSMsg1List.KOJI_UK_OPTNTY_IDO_DTM
, EKU0011A010CBSMsg1List.KOJIAK_UK_USER_ID
, EKU0011A010CBSMsg1List.KOJIAK_STP_TNT_USER_ID
, EKU0011A010CBSMsg1List.LAST_RSP_RSLT_CD
, EKU0011A010CBSMsg1List.LAST_RSP_RSLT_NM
, EKU0011A010CBSMsg1List.LAST_RSP_RSLT_CD_CHG_YMD
, EKU0011A010CBSMsg1List.LAST_RSP_RSLT_OPMS_RNKI_CD
, EKU0011A010CBSMsg1List.LAST_RSP_RSLT_OPMS_RNKI_NM
, EKU0011A010CBSMsg1List.TAKCHO_KIBO_YMD
, EKU0011A010CBSMsg1List.TAKCHO_KIBO_TIME_CD
, EKU0011A010CBSMsg1List.TAKCHO_KIBO_TIME_NM
, EKU0011A010CBSMsg1List.TAKCHO_JUDGE_CD
, EKU0011A010CBSMsg1List.TAKCHO_JUDGE_NM
, EKU0011A010CBSMsg1List.TAKCHO_JSSI_YMD
, EKU0011A010CBSMsg1List.KOJIAK_RRK_JIKO
, EKU0011A010CBSMsg1List.KOJIAK_BIKO_1
, EKU0011A010CBSMsg1List.KOJIAK_BIKO_2
, EKU0011A010CBSMsg1List.TAKCHO_FIN_YMD
, EKU0011A010CBSMsg1List.TAKCHO_SHODAKS_KAISHU_CD
, EKU0011A010CBSMsg1List.TAKCHO_SHODAKS_KAISHU_NM
, EKU0011A010CBSMsg1List.TAKCHO_SHODAKS_RCP_YMD
, EKU0011A010CBSMsg1List.SKKK_CD
, EKU0011A010CBSMsg1List.SKKK_NM
, EKU0011A010CBSMsg1List.SKKK_MEMO
, EKU0011A010CBSMsg1List.DSGN_FIN_YMD
, EKU0011A010CBSMsg1List.SKKK_ETM_DSGN_RPT_YMD
, EKU0011A010CBSMsg1List.SKKK_KOJI_NYO_CFMS_RCP_YMD
, EKU0011A010CBSMsg1List.KITEN_HDSHO_CD
, EKU0011A010CBSMsg1List.HISOS_BUIOFFC_KOJI_COMP_CD
, EKU0011A010CBSMsg1List.HISOS_BUIOFFC_KOJI_COMP_NM
, EKU0011A010CBSMsg1List.KEPCO_BUSIOFFICE_CD
, EKU0011A010CBSMsg1List.KKSHKA_RSVD_SNSTSTD_YMD
, EKU0011A010CBSMsg1List.KOJI_RSV_DSGN_BUNSHO_NO
, EKU0011A010CBSMsg1List.KOJI_RSV_MSKM_FORM_CD
, EKU0011A010CBSMsg1List.KOJI_RSV_MSKM_FORM_NM
, EKU0011A010CBSMsg1List.HAISO_SAKSEI_ZUMI_FLG
, EKU0011A010CBSMsg1List.HAISO_SAKSEI_ZUMI_FLG_NM
, EKU0011A010CBSMsg1List.TAKNKIKI_RSV_ADD_YMD
, EKU0011A010CBSMsg1List.TTL_TCASE_CNT_GK
, EKU0011A010CBSMsg1List.KOCOMP_SHKA_REQ_RCP_YMD
, EKU0011A010CBSMsg1List.HAISO_KIGEN_YMD
, EKU0011A010CBSMsg1List.KIKI_KNPN_FIN_YMD
, EKU0011A010CBSMsg1List.HAISO_ARIV_SHITEI_YMD
, EKU0011A010CBSMsg1List.STC_BF_KIKI_KOKAN_FLG
, EKU0011A010CBSMsg1List.STC_BF_KIKI_KOKAN_FLG_NM
, EKU0011A010CBSMsg1List.STC_BF_KIKI_KOKAN_YMD
, EKU0011A010CBSMsg1List.KIKI_STC_TEKKYO_YMD
, EKU0011A010CBSMsg1List.LOOPBACK_TEST_FIN_YMD
, EKU0011A010CBSMsg1List.OPMS_KOJIAK_RSLT_CD
, EKU0011A010CBSMsg1List.OPMS_KOJIAK_RSLT_NM
, EKU0011A010CBSMsg1List.KOJIAK_JSSI_YMD
, EKU0011A010CBSMsg1List.KOJIAK_FIN_DTM
, EKU0011A010CBSMsg1List.KOJIHI_FIX_YMD
, EKU0011A010CBSMsg1List.PON_SBT_CD
, EKU0011A010CBSMsg1List.PON_SBT_NM
, EKU0011A010CBSMsg1List.KOJIAK_CANCEL_YMD
, EKU0011A010CBSMsg1List.OPMS_KOJIAK_STP_RSLT_CD
, EKU0011A010CBSMsg1List.OPMS_KOJIAK_STP_RSLT_NM
, EKU0011A010CBSMsg1List.KOJIAK_STP_CANCEL_PRC_UM
, EKU0011A010CBSMsg1List.KOJIAK_STP_CANCEL_PRC_UM_NM
, EKU0011A010CBSMsg1List.KOJIAK_STP_UK_YMD
, EKU0011A010CBSMsg1List.KOJIAK_STP_ADD_YMD
, EKU0011A010CBSMsg1List.KOJIAK_STP_YMD
, EKU0011A010CBSMsg1List.KOJI_PDING_UM
, EKU0011A010CBSMsg1List.KOJI_PDING_UM_NM
, EKU0011A010CBSMsg1List.KOJIAK_STP_RSN_CD_1
, EKU0011A010CBSMsg1List.KOJIAK_STP_RSN_NM_1
, EKU0011A010CBSMsg1List.KOJIAK_STP_RSN_CD_2
, EKU0011A010CBSMsg1List.KOJIAK_STP_RSN_NM_2
, EKU0011A010CBSMsg1List.PLAN_CHG_FIX_DTM
, EKU0011A010CBSMsg1List.KARI_KOJI_REQ_YMD
, EKU0011A010CBSMsg1List.GEMBA_WORK_FIN_YMD
, EKU0011A010CBSMsg1List.RCNT_SHOKAI_YMD
, EKU0011A010CBSMsg1List.WEB_SHOKAI_CNT
, EKU0011A010CBSMsg1List.PC_SHOKAI_CNT
, EKU0011A010CBSMsg1List.KTAI_SHOKAI_CNT
, EKU0011A010CBSMsg1List.TOKUSHU_KOJIAK_SKBT_CD
, EKU0011A010CBSMsg1List.TOKUSHU_KOJIAK_SKBT_NM
, EKU0011A010CBSMsg1List.ADD_DTM
, EKU0011A010CBSMsg1List.ADD_OPEACNT
, EKU0011A010CBSMsg1List.ADD_OPEACNT_NM
, EKU0011A010CBSMsg1List.UPD_DTM
, EKU0011A010CBSMsg1List.UPD_OPEACNT
, EKU0011A010CBSMsg1List.UPD_OPEACNT_NM
, EKU0011A010CBSMsg1List.DEL_DTM
, EKU0011A010CBSMsg1List.DEL_OPEACNT
, EKU0011A010CBSMsg1List.DEL_OPEACNT_NM
, EKU0011A010CBSMsg1List.MK_FLG
, EKU0011A010CBSMsg1List.MK_FLG_NM
, EKU0011A010CBSMsg1List.MANS_KOJIAK_STAT_CD
, EKU0011A010CBSMsg1List.MANS_KOJIAK_STAT_CD_NM
, EKU0011A010CBSMsg1List.SMTVL_KEI_UM
, EKU0011A010CBSMsg1List.SMTVL_KEI_UM_NM
, EKU0011A010CBSMsg1List.KJ_KR_CNCL_FLG
, EKU0011A010CBSMsg1List.KJ_KR_CNCL_FLG_NM
, EKU0011A010CBSMsg1List.KR_CNCL_UK_YMD
, EKU0011A010CBSMsg1List.EQUIP_RYUYO_UM
, EKU0011A010CBSMsg1List.EQUIP_RYUYO_UM_NM
, EKU0011A010CBSMsg1List.VONU_RYUYO_UM
, EKU0011A010CBSMsg1List.VONU_RYUYO_UM_NM
, EKU0011A010CBSMsg1List.RYUYO_MT_TEL_KEI_RYKK_CD
, EKU0011A010CBSMsg1List.RYUYO_MT_TEL_KEI_RYKK_CD_NM
, EKU0011A010CBSMsg1List.RYUYO_MOTO_KJAK_NO
, EKU0011A010CBSMsg1List.SBRY_KJ_FIN_KIBOYMD
, EKU0011A010CBSMsg1List.TSYRN_KJ_RRKS_NM
, EKU0011A010CBSMsg1List.TSYRN_KJ_RRKS_TLN
, EKU0011A010CBSMsg1List.TSYRN_TAKCHO_JI_RRKS_NM
, EKU0011A010CBSMsg1List.TSYRN_TAKCHO_JI_RRKS_TLN
, EKU0011A010CBSMsg1List.TSYRN_RRK_KIBO_DATE
, EKU0011A010CBSMsg1List.TSYRN_KOJI_HI
, EKU0011A010CBSMsg1List.TSYRN_TAKCHO_YH
, EKU0011A010CBSMsg1List.TSYRN_TAKCHO_YH_NM
, EKU0011A010CBSMsg1List.TSYRN_SDAKS_YH
, EKU0011A010CBSMsg1List.TSYRN_SDAKS_YH_NM
, EKU0011A010CBSMsg1List.TSYRN_TACHIAISHA_NM
, EKU0011A010CBSMsg1List.TSYRN_HKKS_SISAK_YH
, EKU0011A010CBSMsg1List.TSYRN_HKKS_SISAK_YH_NM
, EKU0011A010CBSMsg1List.TSYRN_CAMPAIGN_INF
, EKU0011A010CBSMsg1List.TSYRN_DOJI_KOJI_INF
, EKU0011A010CBSMsg1List.TSYRN_TTK_JI_NSANK_YH
, EKU0011A010CBSMsg1List.TSYRN_TTK_JI_NSANK_YH_NM
, EKU0011A010CBSMsg1List.TSYRN_MAP_UM
, EKU0011A010CBSMsg1List.TSYRN_MAP_UM_NM
, EKU0011A010CBSMsg1List.TSYRN_KZN_KEI_INF
, EKU0011A010CBSMsg1List.TSYRN_HBI_KAISHOU_YMD
, EKU0011A010CBSMsg1List.TAKCHO_YH
, EKU0011A010CBSMsg1List.TAKCHO_YH_NM
, EKU0011A010CBSMsg1List.DSGN_YH
, EKU0011A010CBSMsg1List.DSGN_YH_NM
, EKU0011A010CBSMsg1List.RSV_ROZETT_STC_STAT_CD
, EKU0011A010CBSMsg1List.RSV_ROZETT_STC_STAT_NM
, EKU0011A010CBSMsg1List.RSV_CONSNT_STC_NYO_CD
, EKU0011A010CBSMsg1List.RSV_CONSNT_STC_NYO_NM
, EKU0011A010CBSMsg1List.ROZETT_STC_RSLT_CD
, EKU0011A010CBSMsg1List.ROZETT_STC_RSLT_NM
, EKU0011A010CBSMsg1List.JSK_CONSNT_STC_NYO_CD
, EKU0011A010CBSMsg1List.JSK_CONSNT_STC_NYO_NM
, EKU0011A010CBSMsg1List.JSK_TNMT_STC_FLR_CD
, EKU0011A010CBSMsg1List.JSK_TNMT_STC_FLR_NM
, EKU0011A010CBSMsg1List.JSK_KISN_TD_SETPLC_1_CD
, EKU0011A010CBSMsg1List.JSK_KISN_TD_SETPLC_1_NM
, EKU0011A010CBSMsg1List.JSK_KISN_TD_SETPLC_2_CD
, EKU0011A010CBSMsg1List.JSK_KISN_TD_SETPLC_2_NM
, EKU0011A010CBSMsg1List.JSK_KISN_TD_STC_KASHO_CD
, EKU0011A010CBSMsg1List.JSK_KISN_TD_STC_KASHO_NM
, EKU0011A010CBSMsg1List.JSK_KISN_TD_SETPLC_1_OTR
, EKU0011A010CBSMsg1List.JSK_KISN_TD_SETPLC_2_OTR
, EKU0011A010CBSMsg1List.JSK_KISN_TD_STC_KASHO_OTR
, EKU0011A010CBSMsg1List.JSK_TANMT_STC_MEN_CD
, EKU0011A010CBSMsg1List.JSK_TANMT_STC_MEN_NM
//ANK-4244-00-00 ADD START
, EKU0011A010CBSMsg1List.KAISEN_PLACE_RENBAN
//ANK-4244-00-00 ADD END
//ANK-4269-00-00 ADD START
, EKU0011A010CBSMsg1List.SCM_TYPE_CD
, EKU0011A010CBSMsg1List.SCM_JGS_CD
//ANK-4269-00-00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKU0011A010CBSMsg1List",0);
// inMsg(CBSMsg)に明細をセット
inMsg.set("EKU0011A010CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EKU0011A010CBSMsg.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(EKU0011A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}