Search Results amv_c_keywords

Overview

AMV_C_KEYWORDS is a table in the AMV (Marketing Encyclopedia System) product module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores all keywords associated with a specific channel that may be used as part of a matching criterion. In the Oracle Marketing and iStore context, channels represent groupings used to target, match, or route marketing content, and the keywords attached to each channel drive keyword-based matching logic. From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification, meaning the table primarily serves as a descriptive attribute container orbiting a parent hub-like entity (AMV_C_CHANNELS_B) rather than acting as an independent hub or an associative link.

Key Information Stored

The table contains 10 documented columns. The surrogate primary key is CHANNEL_KEYWORD_ID, defined by AMV_C_KEYWORDS_PK (and mirrored by unique index AMV_C_KEYWORDS_U1). The business-key candidate is the composite unique index AMV_C_KEYWORDS_UK1 / AMV_C_KEYWORDS_U2 on (CHANNEL_ID, KEYWORD), which enforces that a given keyword appears only once per channel.

CHANNEL_KEYWORD_ID — Surrogate primary key uniquely identifying each keyword row.
CHANNEL_ID — Foreign key to AMV_C_CHANNELS_B, tying the keyword to its parent channel.
KEYWORD — The actual keyword text used in channel matching criteria.
SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-org/security-group access.
OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF framework.
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS WHO columns capturing audit and user context.

Common Use Cases and Queries

Typical use cases include reporting on the keyword set assigned to each channel, validating that matching criteria are populated before campaign activation, and diagnosing why a channel fails to match intended content. A common query lists all keywords for a channel:

SELECT k.keyword FROM amv.amv_c_keywords k WHERE k.channel_id = :channel_id;
Joining to the channel base table to retrieve channel names alongside keywords: SELECT c.channel_id, c.name, k.keyword FROM amv.amv_c_keywords k JOIN amv.amv_c_channels_b c ON c.channel_id = k.channel_id;
Identifying duplicate keyword assignments across channels via GROUP BY on KEYWORD.
Security-group-filtered reporting for multi-org environments using SECURITY_GROUP_ID.

Related Objects

AMV_C_KEYWORDS depends on and is referenced by the following significant objects:

AMV_C_CHANNELS_B — Parent table; joined via AMV_C_KEYWORDS.CHANNEL_ID = AMV_C_CHANNELS_B.CHANNEL_ID.
AMV_C_CHANNELS_TL — Translated channel names for reporting.
FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access control.
FND_USER / FND_LOGINS — Implicitly referenced through the WHO columns (CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN).
AMV channel and content matching APIs that consume keyword rows at runtime.

Together these objects support the marketing encyclopedia keyword matching framework, with AMV_C_KEYWORDS acting as the attribute satellite supplying match terms for each channel.

Table: AMV_C_KEYWORDS 12.2.2
owner:AMV, object_type:TABLE, fnd_design_data:AMV.AMV_C_KEYWORDS, object_name:AMV_C_KEYWORDS, status:VALID, product: AMV - Marketing Encyclopedia System , description: Stores all keywords associated with a specific channel which could be part of a matching criteria. , implementation_dba_data: AMV.AMV_C_KEYWORDS ,
Table: AMV_C_KEYWORDS 12.1.1
owner:AMV, object_type:TABLE, fnd_design_data:AMV.AMV_C_KEYWORDS, object_name:AMV_C_KEYWORDS, status:VALID, product: AMV - Marketing Encyclopedia System , description: Stores all keywords associated with a specific channel which could be part of a matching criteria. , implementation_dba_data: AMV.AMV_C_KEYWORDS ,
VIEW: AMV.AMV_C_KEYWORDS# 12.2.2
owner:AMV, object_type:VIEW, object_name:AMV_C_KEYWORDS#, status:VALID,
TABLE: AMV.AMV_C_KEYWORDS 12.2.2
owner:AMV, object_type:TABLE, fnd_design_data:AMV.AMV_C_KEYWORDS, object_name:AMV_C_KEYWORDS, status:VALID,
SYNONYM: APPS.AMV_C_KEYWORDS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AMV_C_KEYWORDS, status:VALID,
SYNONYM: APPS.AMV_C_KEYWORDS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AMV_C_KEYWORDS, status:VALID,
VIEW: AMV.AMV_C_KEYWORDS# 12.2.2
TABLE: AMV.AMV_C_KEYWORDS 12.1.1
owner:AMV, object_type:TABLE, fnd_design_data:AMV.AMV_C_KEYWORDS, object_name:AMV_C_KEYWORDS, status:VALID,
12.1.1 FND Design Data 12.1.1
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.AMV_MATCH_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_MATCH_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
Table: AMV_C_CHANNELS_B 12.2.2
owner:AMV, object_type:TABLE, fnd_design_data:AMV.AMV_C_CHANNELS_B, object_name:AMV_C_CHANNELS_B, status:VALID, product: AMV - Marketing Encyclopedia System , description: Base Table AMV_C_CHANNELS_B stores all channels that exist in the system. , implementation_dba_data: AMV.AMV_C_CHANNELS_B ,
12.1.1 DBA Data 12.1.1
Table: AMV_C_CHANNELS_B 12.1.1
owner:AMV, object_type:TABLE, fnd_design_data:AMV.AMV_C_CHANNELS_B, object_name:AMV_C_CHANNELS_B, status:VALID, product: AMV - Marketing Encyclopedia System , description: Base Table AMV_C_CHANNELS_B stores all channels that exist in the system. , implementation_dba_data: AMV.AMV_C_CHANNELS_B ,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.AMV_CHANNEL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_CHANNEL_PVT, status:VALID,
PACKAGE BODY: APPS.AMV_CHANNEL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_CHANNEL_PVT, status:VALID,
PACKAGE BODY: APPS.AMV_CATEGORY_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_CATEGORY_PVT, status:VALID,
PACKAGE BODY: APPS.AMV_MATCH_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_MATCH_PVT, status:VALID,
PACKAGE BODY: APPS.AMV_CATEGORY_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AMV_CATEGORY_PVT, status:VALID,
APPS.AMV_MATCH_PVT SQL Statements 12.1.1
APPS.AMV_MATCH_PVT SQL Statements 12.2.2
APPS.AMV_CHANNEL_PVT SQL Statements 12.2.2
APPS.AMV_CHANNEL_PVT SQL Statements 12.1.1
APPS.AMV_CATEGORY_PVT SQL Statements 12.2.2
eTRM - AMV Tables and Views 12.2.2
description: Stores the key id of each vendor (content provider) for all the stocks in amv_stocks. ,
eTRM - AMV Tables and Views 12.1.1
description: Stores the key id of each vendor (content provider) for all the stocks in amv_stocks. ,
APPS.AMV_CHANNEL_PVT dependencies on AMV_C_KEYWORDS 12.2.2
APPS.AMV_CATEGORY_PVT SQL Statements 12.1.1
APPS.AMV_CHANNEL_PVT dependencies on AMV_C_KEYWORDS 12.1.1
APPS.AMV_MATCH_PVT dependencies on AMV_C_KEYWORDS 12.2.2
APPS.AMV_CATEGORY_PVT dependencies on AMV_C_KEYWORDS 12.1.1
APPS.AMV_MATCH_PVT dependencies on AMV_C_KEYWORDS 12.1.1
APPS.AMV_CATEGORY_PVT dependencies on AMV_C_KEYWORDS 12.2.2
APPS.AMV_MATCH_PVT dependencies on JTF_AMV_ITEM_KEYWORDS 12.1.1
APPS.AMV_MATCH_PVT dependencies on JTF_AMV_ITEM_KEYWORDS 12.2.2
eTRM - AMV Tables and Views 12.2.2
description: Stores the key id of each vendor (content provider) for all the stocks in amv_stocks. ,
eTRM - AMV Tables and Views 12.1.1
description: Stores the key id of each vendor (content provider) for all the stocks in amv_stocks. ,
APPS.AMV_CATEGORY_PVT dependencies on AMV_C_AUTHORS 12.2.2
APPS.AMV_CATEGORY_PVT dependencies on AMV_C_AUTHORS 12.1.1
APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CONTENT_TYPES 12.1.1
APPS.AMV_CATEGORY_PVT dependencies on AMV_C_CONTENT_TYPES 12.2.2
PACKAGE BODY: APPS.AMV_MATCH_PVT 12.2.2
PACKAGE BODY: APPS.AMV_MATCH_PVT 12.1.1