CREATE  view usd_v_query_inst_time
as
select APPL.target,
case when APPL.status in (1,2,3,4,7,8,17,18,19,20,21,27) then APPL.activationtime
else APPL.completiontime
end as anytime
from usd_applic APPL
/* not uninstalled */
where APPL.uninstallstate <> 2
/* task&install and status!=execution_error and status!=already_installed and status!=manipulation_not_allowed */
and (APPL.task = 0x00000001 and APPL.status != 10 and APPL.status != 15 and APPL.status != 16)
GO
GRANT SELECT ON  [dbo].[usd_v_query_inst_time] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_query_inst_time] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_query_inst_time] TO [ca_itrm_group_ams]
GO