ALTER VIEW "SYS"."SYSREMOTEUSERS"
  as select u.user_name,r.consolidate,t.type_name,r.address,r.frequency,
    r.send_time,
    (if r.frequency = 'A' then null else if r.frequency = 'P' then
        if r.time_sent is null then current timestamp
        else(select min(minutes(a.time_sent,60*hour(a.send_time)
            +minute(seconds(a.send_time,59))))
            from SYS.ISYSREMOTEUSER as a where a.frequency = 'P'
            and a.send_time = r.send_time)
        endif
      else if current date+r.send_time
         > coalesce(r.time_sent,current timestamp) then
          current date+r.send_time else current date+r.send_time+1 endif
      endif endif) as next_send,
    r.log_send,r.time_sent,r.log_sent,r.confirm_sent,r.send_count,
    r.resend_count,r.time_received,r.log_received,
    r.confirm_received,r.receive_count,r.rereceive_count
    from SYS.ISYSREMOTEUSER as r
      join SYS.ISYSUSER as u on(u.user_id = r.user_id)
      join SYS.ISYSREMOTETYPE as t on(t.type_id = r.type_id)