AMV — Marketing Encyclopedia System
33 documented tables · 6 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
AMV_C_CATEGORIES_B |
Base Table AMV_C_CATEGORIES_B stores categories and sub-categories. | hub |
AMV_C_CHANNELS_B |
Base Table AMV_C_CHANNELS_B stores all channels that exist in the system. | hub |
AMV_D_ENTITIES_B |
Base Table AMV_D_ENTITIES_B stores all tables that could be part of a rule condition or search engine. | hub-leaning |
AMV_D_ATTRIB_OPERATORS |
Stores what operators can be applied to a certain attribute within an entity | satellite-leaning |
AMV_D_ENT_ATTRIBUTES_B |
Base Table AMV_D_ENT_ATTRIBUTES_B stores all attributes within an entity that can be part of a rule condition | satellite-leaning |
AMV_I_CONTENT_TYPES_B |
Base Table AMV_I_CONTENT_TYPES_B stores all content types which one can be used by an item or channel. | hub-leaning |
AMV_D_RULE_CONDITIONS |
Stores all rule conditions within MES | satellite-leaning |
AMV_C_CHL_ITEM_MATCH |
Stores to what channels an item is published | link |
AMV_D_ENTITIES_TL |
Translation table for AMV_D_ENTITIES_B. It is used to store all columns and data that are needed for Multi-Lan | satellite-leaning |
AMV_D_SIMPLE_RULE_ITEMS |
Stores what items have been associated with a rule condition. | link |
AMV_U_ACCESS |
Stores what user or group have access to a channel or an application or an item and what kind of access they h | link |
AMV_D_ENT_ATTRIBUTES_TL |
Translation table for AMV_D_ENT_ATTRIBUTES_B. It is used to store all columns and data that are needed for Mul | satellite-leaning |
AMV_I_CONTENT_TYPES_TL |
Translation table for AMV_I_CONTENT_TYPES_B. It is used to store all columns and data that are needed for Mult | satellite-leaning |
AMV_C_CATEGORIES_TL |
Translation table for AMV_C_CATEGORIES_B. It is used to store all columns and data that are needed for Multi-L | satellite-leaning |
AMV_C_AUTHORS |
Stores one to many authors for a specific channel. | satellite-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AMV_SEARCH_GRP |
GRP | 3 | 3 packages |
AMV_ITEM_PUB |
PUB | 26 | 3 packages |
AMV_CHANNEL_GRP |
GRP | 19 | 3 packages |
AMV_MYCHANNEL_GRP |
GRP | 2 | 2 packages |
AMV_CATEGORY_GRP |
GRP | 14 | 2 packages |
AMV_UTILITY_PUB |
PUB | 0 | 0 packages |
AMV_IMT_PUB |
PUB | 2 | 0 packages |