CREATE view usd_v_nr_of_ok_applics as
select A.objectid, A.activity, A.target
from usd_applic A
where A.status in (9,13)
or(A.task in (0x00000000,0x00000010,0x00000020)
    and(A.status = 4 or A.status = 6))
GO
GRANT SELECT ON  [dbo].[usd_v_nr_of_ok_applics] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_nr_of_ok_applics] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_nr_of_ok_applics] TO [ca_itrm_group_ams]
GO