Results for “amv_d_simple_rule_items”
24 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AMV_D_SIMPLE_RULE_ITEMS is a transactional table in the AMV (Marketing Encyclopedia System) schema of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. The table stores the association between a rule condition and the individual items that satisfy or are governed by that condition. In the ETRM rule framework, a simple rule is composed of one or more conditions, and each condition can be bound to specific content items held in the Marketing Encyclopedia. AMV_D_SIMPLE_RULE_ITEMS is the physical intersection that records those bound items, allowing a rule condition to be evaluated against a discrete set of catalog, media, or knowledge items rather than against the entire item master.
From a heuristic Data Vault modeling perspective, the mined key structure classifies this object as a link. It carries no descriptive business attributes beyond status and security, and its unique index AMV_D_SIMPLE_RULE_ITEMS_U2 (RULE_CONDITION_ID, ITEM_ID) is a classic many-to-many join key connecting two independent hubs — the rule condition and the Marketing Encyclopedia item. No satellite classification is suggested by the documented column set.
Key Information Stored
The table contains eleven documented columns. The surrogate primary key, enforced by AMV_D_SIMPLE_RULE_ITEMS_PK, is SIMPLE_RULE_ITEM_ID, also exposed as unique index U1. The operational business key is the pair RULE_CONDITION_ID and ITEM_ID, enforced by unique index U2; this guarantees that a given item is associated with a given rule condition only once. RULE_CONDITION_ID is a foreign key to AMV_D_RULE_CONDITIONS, identifying the parent condition. ITEM_ID is a foreign key to JTF_AMV_ITEMS_B, identifying the Marketing Encyclopedia item bound to that condition. STATUS records the disposition of the association and is the principal controlling attribute for filtering active versus inactive bindings. SECURITY_GROUP_ID, a foreign key to FND_SECURITY_GROUPS, supports Multi-Org and data-security partitioning. The remaining columns — OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — are standard EBS WHO columns used for optimistic locking, concurrency control, and audit tracing, and are not semantically meaningful to the rule itself.
Common Use Cases and Queries
Typical reporting and integration scenarios include listing all items bound to a given rule condition, identifying orphaned or duplicated item bindings, and validating that active rules reference only active items. The canonical join pattern resolves the condition-to-item path:
- Select SIMPLE_RULE_ITEM_ID, RULE_CONDITION_ID, and ITEM_ID from AMV_D_SIMPLE_RULE_ITEMS ordered by RULE_CONDITION_ID to inventory all bindings.
- Join AMV_D_SIMPLE_RULE_ITEMS to JTF_AMV_ITEMS_B on ITEM_ID to retrieve item titles, display names, and publishing flags for reporting.
- Join to AMV_D_RULE_CONDITIONS on RULE_CONDITION_ID to walk from a rule header through its conditions to the item level.
- Query by SECURITY_GROUP_ID to enforce data partition isolation, or filter on STATUS to exclude retired associations.
When purging or versioning rules, delete or deactivate rows in this table first to preserve referential integrity with AMV_D_RULE_CONDITIONS and JTF_AMV_ITEMS_B.
Related Objects
The most significant related objects are those directly referenced by its foreign keys and unique constraints:
- AMV_D_RULE_CONDITIONS — parent condition header; joined on AMV_D_SIMPLE_RULE_ITEMS.RULE_CONDITION_ID.
- JTF_AMV_ITEMS_B — Marketing Encyclopedia item base table; joined on AMV_D_SIMPLE_RULE_ITEMS.ITEM_ID.
- FND_SECURITY_GROUPS — security partitioning reference; joined on AMV_D_SIMPLE_RULE_ITEMS.SECURITY_GROUP_ID.
- AMV_D_SIMPLE_RULES — rule definition header that owns the conditions above.
- JTF_AMV_ITEMS_TL — translated item attributes for multilingual reporting.
- AMV_D_RULE_CONDITIONS_PK / U1 — supporting unique constraints on the parent condition table.
Together these objects form the rule-to-item resolution chain used by the Marketing Encyclopedia rule engine and by any custom reporting on rule-based content selection.
-
Stores what items have been associated with a rule condition.
-
Stores what items have been associated with a rule condition.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
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.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
-
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.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1