Search Results ams_list_src_types

Overview

The AMS_LIST_SRC_TYPES table is a core reference data table within the Oracle E-Business Suite Marketing (AMS) module. Its primary function is to define and store the master list of all available source types that can be utilized for generating marketing lists. In the context of Oracle EBS 12.1.1 and 12.2.2, this table acts as a foundational lookup, enabling the system to categorize and manage the diverse origins of customer and prospect data used in targeted marketing campaigns. The integrity of this reference data is critical, as it is extensively referenced by numerous transactional and setup tables across the Marketing module, governing how list data is sourced, imported, and processed.

Key Information Stored

The table's structure is designed to uniquely identify and describe each list source type. The primary identifier is the LIST_SOURCE_TYPE_ID column, which serves as the system-generated primary key (AMS_LIST_SRC_TYPES_PK). For application logic and validation, the table enforces a unique constraint (AMS_LIST_SRC_TYPES_UK2) on the combination of LIST_SOURCE_TYPE and SOURCE_TYPE_CODE. This ensures that each logical source type, coupled with its classification code, is distinct. The LIST_SOURCE_NAME column provides a descriptive label for the source type, making it recognizable to end-users and within application interfaces. While the exact values are installation-specific, typical examples might include source types like 'Web Form Submission', 'Trade Show Attendee', 'Purchased List', or 'Customer Master'.

Common Use Cases and Queries

This table is central to setup and reporting activities. Administrators query it to review or maintain the configured source types available for list creation. A common operational query involves joining this table to transactional headers to report on the distribution of marketing contacts by their origin. For instance, to analyze list imports by their source type, one might execute a query joining AMS_IMP_LIST_HEADERS_ALL to AMS_LIST_SRC_TYPES on LIST_SOURCE_TYPE_ID. Developers and integrators reference this table when building custom list generation logic or data imports to ensure alignment with the system's defined source taxonomy. A fundamental query to retrieve all active source types would follow the pattern: SELECT list_source_type_id, list_source_type, source_type_code, list_source_name FROM ams.ams_list_src_types ORDER BY list_source_type;

Related Objects

As indicated by the foreign key relationships, AMS_LIST_SRC_TYPES is a pivotal parent table for a significant portion of the Marketing module's data model. Key dependent objects include:

• AMS_IMP_LIST_HEADERS_ALL: References via LIST_SOURCE_TYPE_ID to classify the source of imported list data.
• AMS_LIST_SRC_FIELDS: References via LIST_SOURCE_TYPE_ID to define the field mappings and attributes specific to a source type.
• AMS_LIST_SRC_TYPE_ASSOCS: References the table twice, via MASTER_SOURCE_TYPE_ID and SUB_SOURCE_TYPE_ID, to manage hierarchical relationships between different source types.
• AMS_DM_TARGETS_B: References via both DATA_SOURCE_ID and TARGET_SOURCE_ID, linking targets to their underlying data sources.
• AMS_DM_TARGET_SOURCES: References via DATA_SOURCE_ID for target marketing source definitions.
• AMS_IMP_DEFAULT_MAPPING: References via LIST_SOURCE_TYPE_ID to store default import mappings per source type.
• AMS_PARTY_SOURCES: References via LIST_SOURCE_TYPE_ID to track the origin of party records.