CREATE view usd_v_nr_of_waiting_applics
as
select A.objectid, A.activity, A.target
from usd_applic A
where A.status in (0,1,2)
or(A.task in (0x00000000,0x00000010,0x00000020)
    and
    A.status = 11)
or(A.task in (0x00000000,0x00000001,0x00000002,0x00000004,0x00000008)
    and
    A.status = 4)
GO
GRANT SELECT ON  [dbo].[usd_v_nr_of_waiting_applics] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_nr_of_waiting_applics] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_nr_of_waiting_applics] TO [ca_itrm_group_ams]
GO