[dbo].[arg_entitlement_count_view]
(local)
>
mdb
>
Views
> dbo.arg_entitlement_count_view
Properties
Columns
SQL Script
Uses
Used By
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Created
4:35:48 PM Wednesday, March 07, 2007
Last Modified
2:49:53 PM Saturday, July 19, 2008
Columns
Name
object_uuid
entitlement_count
SQL Script
SET
QUOTED_IDENTIFIER
OFF
GO
CREATE
VIEW
arg_entitlement_count_view
AS
SELECT
a.primary_object_uuid
object_uuid
,
count
(*)
entitlement_count
FROM
arg_actionlk
a
RIGHT
OUTER
JOIN
arg_actiondf
b
ON
a.lkacadid
=
b.adid
AND
1
=
b.adtype
GROUP
BY
a.primary_object_uuid
GO
Uses
[dbo].[arg_actiondf]
[dbo].[arg_actionlk]
dbo
Used By
[dbo].[arg_entitlement_summary_view]