Results for “complex_rule_item_id”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The AMV_D_COMPL_RULE_ITEMS table is a core configuration object within the Oracle E-Business Suite Marketing Encyclopedia System (AMV) module. It stores the individual rule conditions that, when combined, build up a complex distribution rule governing how marketing encyclopedia content items are distributed or targeted. Each row represents a single condition (or item) belonging to a broader complex rule, which is identified through the COMPLEX_RULE_ID column. This table therefore acts as a detail-level repository that decomposes a complex, multi-condition distribution rule into its constituent atomic building blocks.
From a data-modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This suggests the table functions primarily as an associative entity that connects a complex rule to the conditions and items it references, rather than acting as a standalone hub or a descriptive satellite. Analysts should treat it as a relationship-bearing table that resolves the many-to-many style associations underpinning distribution logic.
Key Information Stored
The documented physical schema contains 12 columns. The most significant of these are:
- COMPLEX_RULE_ITEM_ID — The surrogate primary key, backed by the AMV_D_COMPL_RULE_ITEMS_PK constraint and also by the unique index AMV_D_COMPL_RULE_ITEMS_U1. This uniquely identifies each rule-condition item.
- COMPLEX_RULE_ID — Identifies the parent complex distribution rule to which this item belongs; the primary grouping key for assembling a complete rule.
- RULE_CONDITION_ID — References the specific rule condition applied by this item; a documented foreign key column.
- ITEM_ID — References the marketing encyclopedia item (via JTF_AMV_ITEMS_B) that the condition is evaluated against or applies to.
- STATUS — Indicates the active/inactive or lifecycle state of the rule item.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enabling multi-tenant or organization-level data partitioning.
- OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the record and when.
The business-key candidate documented is the unique index on COMPLEX_RULE_ITEM_ID; the parent-child association between COMPLEX_RULE_ID and RULE_CONDITION_ID forms the semantic business relationship.
Common Use Cases and Queries
Typical use cases include auditing which conditions make up a given complex distribution rule, reporting on rules that reference particular content items, and troubleshooting distribution behavior. A common query pattern joins the table to JTF_AMV_ITEMS_B to resolve item names:
- Retrieve all conditions for a rule:
SELECT * FROM AMV.AMV_D_COMPL_RULE_ITEMS WHERE COMPLEX_RULE_ID = :rule_id; - Join to items:
SELECT i.ITEM_ID, i.NAME FROM AMV.AMV_D_COMPL_RULE_ITEMS r, JTF_AMV_ITEMS_B i WHERE r.ITEM_ID = i.ITEM_ID AND r.COMPLEX_RULE_ID = :rule_id; - Filter by security group for organization-scoped reporting on SECURITY_GROUP_ID.
Reporting use cases include impact analysis (which rules a given item participates in) and validating that every complex rule has an adequate set of active conditions.
Related Objects
- JTF_AMV_ITEMS_B — referenced via AMV_D_COMPL_RULE_ITEMS.ITEM_ID; resolves the content item each rule item targets.
- FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; controls data access partitioning.
- AMV_D_COMPL_RULE_ITEMS (self/rule-condition relationship) — the RULE_CONDITION_ID association links to condition definitions.
- AMV_D_COMPL_RULE_ITEMS_PK / _U1 — primary key and unique index enforcing COMPLEX_RULE_ITEM_ID integrity.
- Parent complex rule header table implied by COMPLEX_RULE_ID, and AMV distribution rule APIs that read these items during content delivery.
-
Stores what rule conditions that together build up a complex distribution rule.
-
Stores what rule conditions that together build up a complex distribution rule.
-
eTRM - AMV Tables and Views 12.1.1
Stores the key id of each vendor (content provider) for all the stocks in amv_stocks.
-
eTRM - AMV Tables and Views 12.2.2
Stores the key id of each vendor (content provider) for all the stocks in amv_stocks.
-
eTRM - AMV Tables and Views 12.1.1
Stores the key id of each vendor (content provider) for all the stocks in amv_stocks.
-
eTRM - AMV Tables and Views 12.2.2
Stores the key id of each vendor (content provider) for all the stocks in amv_stocks.