AMV Tables (33)

AMV - Marketing Encyclopedia System — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
AMV_C_AUTHORS	10	Stores one to many authors for a specific channel.
AMV_C_CATEGORIES_B	13	Base Table AMV_C_CATEGORIES_B stores categories and sub-categories.
AMV_C_CATEGORIES_TL	12	Translation table for AMV_C_CATEGORIES_B. It is used to store all columns and data that are needed for Multi-Language Suport.
AMV_C_CHANNELS_B	48	Base Table AMV_C_CHANNELS_B stores all channels that exist in the system.
AMV_C_CHANNELS_TL	12	Translation table for AMV_C_CHANNELS_B. It is used to store all columns and data that are needed for Multi-Language Suport.
AMV_C_CHL_ITEM_MATCH	18	Stores to what channels an item is published
AMV_C_CHL_PERSPECTIVES	10	Stores all perspectives associated with a specific channel which could be part of a matching criteria.
AMV_C_CONTENT_TYPES	10	Stores all content types associated with a specific channel which could be part of a matching criteria.
AMV_C_ITEM_TYPES	10	Stores all item types associated with a specific channel which could be part of a matching criteria.
AMV_C_KEYWORDS	10	Stores all keywords associated with a specific channel which could be part of a matching criteria.
AMV_D_ATTRIB_OPERATORS	14	Stores what operators can be applied to a certain attribute within an entity
AMV_D_COMPL_RULE_ITEMS	12	Stores what rule conditions that together build up a complex distribution rule.
AMV_D_ENTITIES_B	13	Base Table AMV_D_ENTITIES_B stores all tables that could be part of a rule condition or search engine.
AMV_D_ENTITIES_TL	12	Translation table for AMV_D_ENTITIES_B. It is used to store all columns and data that are needed for Multi-Language Suport.
AMV_D_ENT_ATTRIBUTES_B	18	Base Table AMV_D_ENT_ATTRIBUTES_B stores all attributes within an entity that can be part of a rule condition or search engine.
AMV_D_ENT_ATTRIBUTES_TL	12	Translation table for AMV_D_ENT_ATTRIBUTES_B. It is used to store all columns and data that are needed for Multi-Language Suport.
AMV_D_RULE_CONDITIONS	16	Stores all rule conditions within MES
AMV_D_SIMPLE_RULE_ITEMS	11	Stores what items have been associated with a rule condition.
AMV_I_CONTENT_TYPES_B	9	Base Table AMV_I_CONTENT_TYPES_B stores all content types which one can be used by an item or channel.
AMV_I_CONTENT_TYPES_TL	12	Translation table for AMV_I_CONTENT_TYPES_B. It is used to store all columns and data that are needed for Multi-Language Suport.
AMV_I_ITEM_PERSPECTIVES	10	Stores all the perspective attributes for an item
AMV_I_PERSPECTIVES_B	9	Base Table AMV_I_PERSPECTIVES_B stores perspective attributes that can be used by an item or channel.
AMV_I_PERSPECTIVES_TL	12	Translation table for AMV_I_PERSPECTIVES_B. It is used to store all columns and data that are needed for Multi-Language Suport.
AMV_NEWS	14	Stores news url's from external content providers
AMV_STOCKS	19	Stores the stock information for all companies listed in different stock exchanges.
AMV_STOCK_PRICE	22	Stores stocks price history.
AMV_TEMP_IDS	5
AMV_TEMP_NUMBERS	2
AMV_USER_TICKER	10	Stores the stocks entered by users in user stock profile.
AMV_U_ACCESS	22	Stores what user or group have access to a channel or an application or an item and what kind of access they have.
AMV_U_EXT_SUBSCRIPTIONS	17	Stores the subscriptions made by external users for cahnnels
AMV_U_MY_CHANNELS	17	Stores all channels a user is subscribing to.
AMV_VENDOR_KEYS	14	Stores the key id of each vendor (content provider) for all the stocks in amv_stocks.