sql.setLength(0);
sql.append("SELECT "+ System.getProperty("line.separator"));
sql.append(" EN.SOHNCD "+ System.getProperty("line.separator"));
sql.append(" ,EN.HANGUCD AS H_HANGUCD "+ System.getProperty("line.separator"));
sql.append(" ,U.HANGUCD AS U_HANGUCD "+ System.getProperty("line.separator"));
sql.append(" ,EN.UDTL_MSEQ AS H_UDTL_MSEQ "+ System.getProperty("line.separator"));
sql.append(" ,U.UDTL_MSEQ AS U_UDTL_MSEQ "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_UPDKBN "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_UPDYMDHMS "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_GUCD "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_SOKAISHIYMD "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_YOUBICD "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_KAISHIHM "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_ENDHM "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_USHIFLG "+ System.getProperty("line.separator"));
sql.append(" ,EN.BHI_DGJI AS BHI_DGJI "+ System.getProperty("line.separator"));
sql.append(" ,U.XXAYMD "+ System.getProperty("line.separator"));
sql.append(" ,U.XXAKAISHIHM "+ System.getProperty("line.separator"));
sql.append(" ,U.XXAENDHM "+ System.getProperty("line.separator"));
sql.append(" ,U.USHIFLG "+ System.getProperty("line.separator"));
sql.append(" ,EN.J_SAKCD "+ System.getProperty("line.separator"));
sql.append(" ,U.JIUMUFLG "+ System.getProperty("line.separator"));
sql.append("FROM " + System.getProperty("line.separator"));
sql.append("( " + System.getProperty("line.separator"));
sql.append(" SELECT " + System.getProperty("line.separator"));
sql.append(" YJT.SOHNCD " + System.getProperty("line.separator"));
sql.append(" ,YJT.GUCD AS J_GUCD " + System.getProperty("line.separator"));
sql.append(" ,UDTL.HANGUCD " + System.getProperty("line.separator"));
sql.append(" ,UDTL.MSEQ AS UDTL_MSEQ " + System.getProperty("line.separator"));
sql.append(" ,YJT.SOKAISHIYMD AS J_SOKAISHIYMD " + System.getProperty("line.separator"));
sql.append(" ,YJT.KAISHIHM AS J_KAISHIHM " + System.getProperty("line.separator"));
sql.append(" ,YJT.ENDHM AS J_ENDHM" + System.getProperty("line.separator"));
sql.append(" ,DECODE(YJT.USHIKBN,'1','0','1') AS J_USHIFLG " + System.getProperty("line.separator"));
sql.append(" ,YJT.UPDKBN AS J_UPDKBN " + System.getProperty("line.separator"));
sql.append(" ,YJT.UPDYMDHMS AS J_UPDYMDHMS " + System.getProperty("line.separator"));
sql.append(" ,YJT.YOUBICD AS J_YOUBICD " + System.getProperty("line.separator"));
sql.append(" ,BHI.DGJI AS BHI_DGJI " + System.getProperty("line.separator"));
sql.append(" ,YJT.SAKCD AS J_SAKCD " + System.getProperty("line.separator"));
sql.append(" FROM " + System.getProperty("line.separator"));
sql.append(" KT_SOJITSU YJT " + System.getProperty("line.separator"));
sql.append(" LEFT OUTER JOIN KT_JITSUKKN YJTKN " + System.getProperty("line.separator"));
sql.append(" ON YJT.SOHNCD = YJTKN.SOHNCD " + System.getProperty("line.separator"));
sql.append(" LEFT OUTER JOIN KT_HANWKINFO BHI " + System.getProperty("line.separator"));
sql.append(" ON (YJT.DASUHNID = BHI.DASUHNID AND YJT.DASUWKID = BHI.DASUWKID) " + System.getProperty("line.separator"));
sql.append(" LEFT OUTER JOIN " + System.getProperty("line.separator"));
sql.append(" (SELECT * FROM KT_HANDTL UD WHERE UD.DELFLG = 0) UDTL " + System.getProperty("line.separator"));
sql.append(" ON YJT.SOHNCD = UDTL.SOHNCD " + System.getProperty("line.separator"));
sql.append(" WHERE " + System.getProperty("line.separator"));
sql.append(" YJT.GUCD = \'" + result.get(progCnt).get("GUCD") + "\'" + System.getProperty("line.separator"));
sql.append(" AND " + System.getProperty("line.separator"));
sql.append(" ((GREATEST(YJT.UPDYMDHMS,NVL(BHI.UPDYMDHMS,\'1970/01/01\')) >= \'" + strShoriKaishiYmdhms + "\') OR YJTKN.KKNSTATUS = \'20\')" + System.getProperty("line.separator"));
sql.append(") EN " + System.getProperty("line.separator"));
sql.append("FULL OUTER JOIN " + System.getProperty("line.separator"));
sql.append("( " + System.getProperty("line.separator"));
sql.append(" SELECT " + System.getProperty("line.separator"));
sql.append(" U.HANGUCD " + System.getProperty("line.separator"));
sql.append(" ,UDTL.MSEQ AS UDTL_MSEQ " + System.getProperty("line.separator"));
sql.append(" ,U.XXAYMD " + System.getProperty("line.separator"));
sql.append(" ,U.XXAKAISHIHM " + System.getProperty("line.separator"));
sql.append(" ,U.XXAENDHM " + System.getProperty("line.separator"));
sql.append(" ,U.USHIFLG " + System.getProperty("line.separator"));
sql.append(" ,U.JIUMUFLG " + System.getProperty("line.separator"));
sql.append(" FROM " + System.getProperty("line.separator"));
sql.append(" KT_HAN U " + System.getProperty("line.separator"));
sql.append(" LEFT OUTER JOIN " + System.getProperty("line.separator"));
sql.append(" (SELECT * FROM KT_HANDTL UD WHERE UD.DELFLG = 0) UDTL " + System.getProperty("line.separator"));
sql.append(" ON U.HANGUCD = UDTL.HANGUCD " + System.getProperty("line.separator"));
sql.append(" WHERE " + System.getProperty("line.separator"));
sql.append(" U.GUCD = \'" + result.get(progCnt).get("GUCD") + "\'" + System.getProperty("line.separator"));
sql.append(" AND (U.HASEIDTLCD = \'00\' OR U.HASEIDTLCD IS NULL) " + System.getProperty("line.separator"));
sql.append(" AND U.DELFLG = 0 " + System.getProperty("line.separator"));
sql.append(" AND U.HNTSHOGIFLG = 0 " + System.getProperty("line.separator"));
sql.append(") U " + System.getProperty("line.separator"));
sql.append("ON " + System.getProperty("line.separator"));
sql.append(" EN.HANGUCD = U.HANGUCD " + System.getProperty("line.separator"));
sql.append("OR " + System.getProperty("line.separator"));
sql.append(" (EN.J_SOKAISHIYMD = U.XXAYMD " + System.getProperty("line.separator"));
sql.append(" AND EN.J_KAISHIHM = U.XXAKAISHIHM " + System.getProperty("line.separator"));
sql.append(" AND EN.J_ENDHM = U.XXAENDHM) " + System.getProperty("line.separator"));
sql.append("WHERE " + System.getProperty("line.separator"));
sql.append(" U.HANGUCD IS NULL " + System.getProperty("line.separator"));
sql.append(" OR " + System.getProperty("line.separator"));
sql.append(" EN.SOHNCD IS NOT NULL " + System.getProperty("line.separator"));
sql.append("ORDER BY " + System.getProperty("line.separator"));
sql.append(" NVL(EN.J_SOKAISHIYMD,U.XXAYMD) " + System.getProperty("line.separator"));
sql.append(" ,NVL(EN.J_KAISHIHM,U.XXAKAISHIHM) " + System.getProperty("line.separator"));
sql.append(" ,NVL(EN.J_ENDHM,U.XXAENDHM) " + System.getProperty("line.separator"));
sql.append(" ,EN.SOHNCD ");
db.setSql(sql.toString());
resultDetail = db.selectMapList();
sMsgAppStr = new String[]{"★GUMループ" + progCnt + "番目:GUMコード" + result.get(progCnt).get("GUCD") + "の平情報、ユン情報 件数" + resultDetail.size(), "取得"};
HANLog.info(ResourceUtil.getMessage("BT0011I", sMsgAppStr));