Table: AMV_C_CHL_ITEM_MATCH

Product:	AMV - Marketing Encyclopedia System
Description:	Stores to what channels an item is published
Implementation/DBA Data:	AMV.AMV_C_CHL_ITEM_MATCH

Primary Key: AMV_C_CHL_ITEM_MATCH_PK

1. CHANNEL_ITEM_ID

Primary Key: AMV_C_CHL_ITEM_MATCH_UK1

1. TABLE_NAME_CODE
2. ITEM_ID
3. CHANNEL_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMV_C_CHL_ITEM_MATCH		AMV_C_CATEGORIES_B	AMV_C_CHL_ITEM_MATCH.CHANNEL_CATEGORY_ID
AMV_C_CHL_ITEM_MATCH		AMV_C_CHANNELS_B	AMV_C_CHL_ITEM_MATCH.CHANNEL_ID
AMV_C_CHL_ITEM_MATCH		JTF_AMV_ITEMS_B	AMV_C_CHL_ITEM_MATCH.ITEM_ID
AMV_C_CHL_ITEM_MATCH		FND_APPLICATION	AMV_C_CHL_ITEM_MATCH.APPLICATION_ID