#-------------------------FU START--------------------------
#-----------------------------------------------------------
#--工事工程進捗(KU_T_KOJI_STEP_PRG-FU_SELECT_001)
#--ホームタイプ契約時の工事工程情報を出力する。
#-----------------------------------------------------------

--KEY:FU_SELECT_001

SELECT JOIN_1.MSKM_DTL_NO,
       KU0151.CANCEL_FLG
FROM KU_T_KOJI_STEP_PRG KU0151
INNER JOIN
(SELECT KU0091.KOJIAK_NO,
        KU0091.MSKM_DTL_NO
  FROM KU_T_MSKM_DTL_KOJIAK KU0091
 WHERE KU0091.MSKM_DTL_NO = ?
   AND KU0091.MSKM_DTL_KOJIAK_TSTAYMD = 
(SELECT MAX(MSKM_DTL_KOJIAK_TSTAYMD) AS KU0091_MAX
  FROM KU_T_MSKM_DTL_KOJIAK KU0091_GENE
 WHERE KU0091_GENE.MSKM_DTL_KOJIAK_TSTAYMD <= ?
   AND KU0091_GENE.MSKM_DTL_NO = ?
   AND KU0091_GENE.MK_FLG = '0')) JOIN_1
 ON KU0151.KOJIAK_NO = JOIN_1.KOJIAK_NO
AND KU0151.STEP_UK_FIN_CD = '2'
AND KU0151.MK_FLG = '0'
AND KU0151.KOJI_STEP_PRG_YMD = 
(SELECT MAX(KOJI_STEP_PRG_YMD) AS KU0151_MAX
  FROM KU_T_KOJI_STEP_PRG KU0151_GENE
 WHERE KU0151_GENE.KOJI_STEP_PRG_YMD <= ?
   AND KU0151_GENE.MK_FLG = '0'
   AND KU0151_GENE.KOJIAK_NO = (SELECT KU0091_1.KOJIAK_NO
  FROM KU_T_MSKM_DTL_KOJIAK KU0091_1
 WHERE KU0091_1.MSKM_DTL_NO = ?
   AND KU0091_1.MSKM_DTL_KOJIAK_TSTAYMD = 
(SELECT MAX(MSKM_DTL_KOJIAK_TSTAYMD) AS KU0091_MAX
  FROM KU_T_MSKM_DTL_KOJIAK KU0091_GENE_1
 WHERE KU0091_GENE_1.MSKM_DTL_KOJIAK_TSTAYMD <= ?
   AND KU0091_GENE_1.MSKM_DTL_NO = ?
   AND KU0091_GENE_1.MK_FLG = '0')))

#-
#-------------------------FU END----------------------------

#-----------------------------------------------------------
#--工事工程進捗(KU_T_KOJI_STEP_PRG-KU_SELECT_001)
#--【Web工程進捗情報反映】
#--工事工程進捗年月日の年月日が同一の件数を取得する。
#-----------------------------------------------------------

--KEY:KU_SELECT_001

SELECT
    COUNT(*) AS CNT
FROM
    KU_T_KOJI_STEP_PRG
WHERE
    KOJI_STEP_PRG_YMD = ?

#-

#-----------------------------------------------------------
#--工事工程進捗(KU_T_KOJI_STEP_PRG-KU_DELETE_001)
#--【Web工程進捗情報反映】
#--工事工程進捗年月日より連携ＷＥＢ工程進捗保持日数前の工事工程進捗を削除する。
#-----------------------------------------------------------

--KEY:KU_DELETE_001

DELETE KU_T_KOJI_STEP_PRG WHERE KOJI_STEP_PRG_YMD < ?

#-