Views [dbo].[usd_v_query_del_time]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:09 AM Wednesday, March 07, 2007
Last Modified6:12:26 PM Monday, May 04, 2009
Columns
Name
target
anytime
Permissions
TypeActionOwning Principal
GrantSelectca_itrm_group
GrantSelectca_itrm_group_ams
GrantSelectams_group
SQL Script
/* 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
Uses