[dbo].[productidview]

(local) > mdb > Views > dbo.productidview

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:14 AM Wednesday, March 07, 2007
Last Modified	11:10:14 AM Wednesday, March 07, 2007

Columns

Name
productid

Permissions

Type	Action	Owning Principal
Grant	Select	aionadmin_group

SQL Script

CREATE VIEW "productidview" AS
       SELECT "productids"."productid"
       FROM "productids", "productkeyview"
       WHERE productids.productkey = productkeyview.product_key

GO
GRANT SELECT ON  [dbo].[productidview] TO [aionadmin_group]
GO

Uses

[dbo].[productids]
[dbo].[productkeyview]
dbo

Used By

[dbo].[ActivitiesLateCompView]
[dbo].[ActivitiesLateIncompView]
[dbo].[ActivitiesTimeToDueDate]
[dbo].[activitydistrcompview]
[dbo].[ActorBottleneckView]
[dbo].[ActorThroughputView]
[dbo].[processlistview]
[dbo].[ProcStatusCompView]
[dbo].[ProcStatusIncompView]