SELECT
        KK2541.KAP_KEI_NO,
        KK2541.GENE_ADD_DTM,
        KK2541.KKTK_SVC_KEI_NO,
        KK2541.KAP_SEIKY_ENDYMD,
        TO_CHAR(KK2541.KAP_PAY_ZAN_CNT) AS KAP_PAY_ZAN_CNT,
        KK2541.KAP_KEI_STAT,
        KK2541.RSV_APLY_YMD,
        KK2541.RSV_APLY_CD,
        KK2541.MK_FLG,
        KK2541.KAP_PLAN_CD,
        KK2541.KAP_KEI_CHRG_STAYMD,
        KK2541.KAP_KEI_DSL_YMD,
        KK2541.KAP_SEIKY_STA_YM
FROM
    KK_T_KAP_KEI KK2541