Results for “amv_d_compl_rule_items”

26 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:

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.