SELECT
    KK0711.WRIB_SVC_TANKA_NO
   ,KK0711.WRIB_SVC_CD
   ,KK0711.PPLAN_CD
   ,KK0711.TMP_PAY_PRC_NO
   ,KK0711.WRIB_SVC_TANKA_TSTAYMD
   ,KK0711.WRIB_SVC_TANKA_TENDYMD
FROM
    KK_M_WRIB_SVC_TANKA KK0711
WHERE
    KK0711.MK_FLG = '0'