/* Start of locks for dependent tables */

/* End of lines added to convert to online lock */

/* ********************** 10297 begin  ******************* */
CREATE  view usd_v_query_del_time
as
select APPL.target,
case when APPL.status in (1,2,3) then APPL.activationtime
else APPL.completiontime
end as anytime
from usd_applic APPL
/* not uninstalled */
where APPL.uninstallstate <> 2
/* Delivery and WAITING,DELIVERY_ORDERED,DELIVERING,DELIVERY_OK */
and APPL.task = 0x00000010 and status in (1,2,3,4)
GO
GRANT SELECT ON  [dbo].[usd_v_query_del_time] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_query_del_time] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_query_del_time] TO [ca_itrm_group_ams]
GO