create view usm_vw_sla_instance_times as
select
    sla_instance_id,
    offering_sla_def_id,
    cast(subscription_detail_id as varchar) as subscription_detail_id_char,
    subscription_detail_id,
    cast(request_id as varchar) as request_id_char,
    request_id,
    is_sla_active,
    sla_status,
    time_to_warn,
    time_to_violate,
    last_event_time,
    next_event_time,
    next_event_type,
    created_time,
    warned_time,
    violated_time,
    completed_time,
    paused_time,
    resumed_time,
    canceled_time,
    dbo.usm_fn_get_request_holdtime(request_id,subscription_detail_id,'Approval Done') as hold_approval_seconds,
    dbo.usm_fn_get_request_holdtime(request_id,subscription_detail_id,'Fulfilled') as hold_fulfilled_seconds,
    dbo.usm_fn_get_request_holdtime(request_id,subscription_detail_id,'Completed') as hold_compled_seconds,
    case when (datediff(day,created_time,getdate()) < 1) then 1 else 0 end as current_day_tf,
    case when (datediff(week,created_time,getdate()) < 1) then 1 else 0 end as current_week_tf,
    case when (datediff(month,created_time,getdate()) < 1) then 1 else 0 end as current_month_tf,
    case when (datediff(year,created_time,getdate()) < 1) then 1 else 0 end as current_year_tf
from usm_request_sla_instance
GO
GRANT SELECT ON  [dbo].[usm_vw_sla_instance_times] TO [usmgroup]
GO