SELECT KK0451.WRIB_SVC_KEI_NO ,KK0451.RSV_APLY_YMD || KK0451.GENE_ADD_DTM AS GENE_ADD_DTM ,KK0451.WRIB_SVC_KEI_STAT ,KK0451.WRIB_SVC_CD ,KK0451.PPLAN_CD ,KK0451.SVC_USE_STA_KIBO_YMD ,KK0451.RSV_TSTA_KIBO_YMD ,KK0451.MSKM_DTL_NO ,KK0451.RSV_APLY_YMD ,KK0451.RSV_APLY_CD ,KK0451.MK_FLG ,KK0451.SVC_CHRG_STAYMD ,KK0451.SVC_CHRG_ENDYMD FROM KK_T_WRIB_SVC_KEI KK0451