Table: AMV_U_ACCESS

Product:	AMV - Marketing Encyclopedia System
Description:	Stores what user or group have access to a channel or an application or an item and what kind of access they have.
Implementation/DBA Data:	AMV.AMV_U_ACCESS

Primary Key: AMV_U_ACCESS_PK

1. ACCESS_ID

Primary Key: AMV_U_ACCESS_UK1

1. ACCESS_TO_TABLE_RECORD_ID
2. USER_OR_GROUP_TYPE
3. ACCESS_TO_TABLE_CODE
4. USER_OR_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMV_U_ACCESS		JTF_RS_RESOURCE_EXTNS	AMV_U_ACCESS.USER_OR_GROUP_ID
AMV_U_ACCESS		JTF_RS_GROUPS_B	AMV_U_ACCESS.USER_OR_GROUP_ID
AMV_U_ACCESS		AMV_C_CHANNELS_B	AMV_U_ACCESS.ACCESS_TO_TABLE_RECORD_ID
AMV_U_ACCESS		FND_APPLICATION	AMV_U_ACCESS.ACCESS_TO_TABLE_RECORD_ID
AMV_U_ACCESS		JTF_AMV_ITEMS_B	AMV_U_ACCESS.ACCESS_TO_TABLE_RECORD_ID
AMV_U_ACCESS		AMV_C_CATEGORIES_B	AMV_U_ACCESS.ACCESS_TO_TABLE_RECORD_ID