Results for “list_source_type_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AMS_DLG_IDENTIFY_ITEMS table is a Marketing (AMS) module data object within the Oracle E-Business Suite, validated and owned by the AMS schema. Its documented purpose is to store the fields that are associated with identification rules. Identification rules are used by Oracle Marketing and its list-source processing framework to determine how records from external or internal list sources are recognized, matched, and de-duplicated when building target groups and campaigns. Each row in this table effectively represents a single field-level participation entry tied to a parent identification rule.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. In practical terms, this suggests the table behaves as a descriptive, attribute-bearing child that hangs off a parent entity (the identification rule), rather than acting as an independent hub of business keys or a pure associative link between two hubs. The strongest parentage signal is the foreign key from RULE_ID to AMS_DLG_IDENTIFY_RULES_B, which anchors the descriptive rows to their controlling rule.

Key Information Stored

The table contains thirteen documented columns. The most significant are described below.

• ITEM_ID — The surrogate primary key. It is the single-column primary key and is also enforced by the unique index AMS_DLG_IDENTIFY_ITEMS_U1, making it the definitive row identifier.
• RULE_ID — The foreign key to AMS_DLG_IDENTIFY_RULES_B. This column identifies the parent identification rule to which the item belongs and is the primary join path for grouping items under a rule.
• LIST_SOURCE_TYPE_ID — Foreign key to AMS_LIST_SRC_TYPES, indicating the type of list source from which the identified field originates.
• LIST_SOURCE_FIELD_ID — Foreign key to AMS_LIST_SRC_FIELDS, pointing to the specific field definition within a list source that participates in the identification logic.
• SOURCE_TYPE_CODE — A coded value describing the source type, used to qualify how the field is sourced.
• SOURCE_COLUMN_NAME — The physical or logical column name of the source field, used to map identification logic to concrete data.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org and security-group data isolation typical of EBS.
• OBJECT_VERSION_NUMBER — The optimistic locking version column used by the EBS framework to detect concurrent updates.

Standard EBS audit columns are present: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN. The business-key candidate documented is ITEM_ID via the unique index; no alternative composite business key is documented.

Common Use Cases and Queries

Typical usage centers on retrieving the field set that defines an identification rule, auditing which source fields drive matching, and joining to list-source metadata for reporting.

• Listing all fields for a rule: SELECT i.ITEM_ID, i.SOURCE_COLUMN_NAME, i.SOURCE_TYPE_CODE FROM AMS.AMS_DLG_IDENTIFY_ITEMS i WHERE i.RULE_ID = :rule_id;
• Resolving source context: join LIST_SOURCE_TYPE_ID and LIST_SOURCE_FIELD_ID to AMS_LIST_SRC_TYPES and AMS_LIST_SRC_FIELDS to obtain human-readable field and type names.
• Security-scoped reporting: filter by SECURITY_GROUP_ID to honor the active responsibility's security group.
• Concurrency and change tracking: inspect OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, and LAST_UPDATED_BY for audit and integration reconciliation.

Related Objects

• AMS_DLG_IDENTIFY_RULES_B — Parent rule table; joined on AMS_DLG_IDENTIFY_ITEMS.RULE_ID = AMS_DLG_IDENTIFY_RULES_B.RULE_ID.
• AMS_LIST_SRC_TYPES — List source type reference; joined on LIST_SOURCE_TYPE_ID.
• AMS_LIST_SRC_FIELDS — List source field reference; joined on LIST_SOURCE_FIELD_ID.
• FND_SECURITY_GROUPS — Security group reference; joined on SECURITY_GROUP_ID.

These relationships make AMS_DLG_IDENTIFY_ITEMS a descriptive child of the identification rule entity and a key participant in Oracle Marketing list-source and target-group processing.