#-----------------------------------------------------------
#--解約後転居先情報(KK_T_DSL_AF_TNKYS_IF-CH_SELECT_001)
#--請求契約番号に解約後転居先情報を取得する。
#-----------------------------------------------------------

--KEY:CH_SELECT_001

SELECT
    SEIKY_KEI_NO,
    GENE_ADD_DTM,
    CUST_NM,
    CUST_KANA,
    TELNO,
    TELNO_SBT,
    PCD,
    AD,
    MITCK_FLG,
    YK_KDNSK_NON_FLG,
    KIJI
FROM
    KK_T_DSL_AF_TNKYS_IF KK3213
WHERE SEIKY_KEI_NO = ?
AND GENE_ADD_DTM = (
    SELECT
        MAX(KK3213_GENE.GENE_ADD_DTM) AS MAX_KK3213_GENE_ADD_DTM
    FROM
        KK_T_DSL_AF_TNKYS_IF KK3213_GENE
    WHERE
        KK3213_GENE.SEIKY_KEI_NO = KK3213.SEIKY_KEI_NO
        AND KK3213_GENE.MK_FLG = '0')

#-