#-----------------------------------------------------------
#--明細本文非定型部(CC_T_DTL_TEXT_HTKB-CC_INSERT_001)
#-----------------------------------------------------------

--KEY:CC_INSERT_001

INSERT INTO CC_T_DTL_TEXT_HTKB
(
 MAIL_SEND_NO, 
 MAIL_DTL_CD, 
 DTL_TEXT_HTKB_SEQ, 
 DTL_TEXT_HTK_CKAN_MOJI,  
 ADD_DTM, 
 ADD_OPEACNT, 
 UPD_DTM, 
 UPD_OPEACNT, 
 DEL_DTM, 
 DEL_OPEACNT, 
 MK_FLG,
 ADD_UNYO_YMD,
 ADD_TRN_ID,
 UPD_UNYO_YMD,
 UPD_TRN_ID
)
VALUES
( ?,?,?,?,?,?,?,?,?,?,?,'ADD_UNYO','ADD_TRN','UPD_UNYO','UPD_TRN' )
#-

#-----------------------------------------------------------
#--明細本文非定型部(CC_T_DTL_TEXT_HTKB-CC_SELECT_001)
#-----------------------------------------------------------

--KEY:CC_SELECT_001

SELECT CC0161.MAIL_DTL_CD
FROM CC_M_MAIL_DTL CC0161
WHERE CC0161.MAIL_DTL_CD = ?
AND CC0161.GENE_ADD_DTM =
(
  SELECT MAX(CC0161_GENE.GENE_ADD_DTM)
  FROM CC_M_MAIL_DTL CC0161_GENE 
  WHERE CC0161_GENE.MAIL_DTL_CD=CC0161.MAIL_DTL_CD
) 
AND MK_FLG = '0'
#-

#-----------------------------------------------------------
#--明細本文非定型部(CC_T_DTL_TEXT_HTKB-CC_SELECT_002)
#-----------------------------------------------------------

--KEY:CC_SELECT_002

SELECT *
FROM CC_T_DTL_TEXT_HTKB CC0171
WHERE CC0171.MAIL_SEND_NO = ?
#-

#-----------------------------------------------------------
#--明細本文非定型部(CC_T_DTL_TEXT_HTKB-CC_SELECT_003)
#--指定したメール送信番号に紐づく明細本文非定型部テーブルの情報を抽出します。結果はメール明細コード、明細本文非定型部連番でソートします。
#-----------------------------------------------------------

--KEY:CC_SELECT_003

SELECT 
    CC0171.MAIL_SEND_NO
   ,CC0171.MAIL_DTL_CD
   ,CC0171.DTL_TEXT_HTKB_SEQ
   ,CC0171.DTL_TEXT_HTK_CKAN_MOJI
FROM 
    CC_T_DTL_TEXT_HTKB CC0171 
WHERE 
    CC0171.MAIL_SEND_NO = ?
AND CC0171.MK_FLG = '0' 
ORDER BY CC0171.MAIL_SEND_NO, CC0171.MAIL_DTL_CD, CC0171.DTL_TEXT_HTKB_SEQ

#-