Search Results ams_media_b

Overview

The AMS_MEDIA_B table is a core master data table within the Oracle E-Business Suite Marketing (AMS) module, specifically for releases 12.1.1 and 12.2.2. It functions as the primary repository for defining and storing all distinct media types or channels that can be utilized by marketing activities. In essence, it serves as a reference lookup for the various communication channels available to marketers, such as email, direct mail, web, social media, telemarketing, or events. Its central role is to provide a standardized, reusable list of media options that can be associated with campaigns, offers, delivery methods, and other marketing execution objects, ensuring consistency in channel definition and reporting across the application.

Key Information Stored

While the provided metadata does not list all columns, the structure indicates the table's primary purpose is to maintain a unique identifier and associated attributes for each media type. The key column is MEDIA_ID, which serves as the primary key (AMS_MEDIA_B_PK). This numeric identifier is the foreign key referenced by numerous other tables in the schema. Typical columns in such a base table would include system-controlled fields like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and ENABLED_FLAG (to activate or deactivate a media record). The descriptive, user-facing name for each MEDIA_ID is stored in the corresponding translation table, AMS_MEDIA_TL, which supports multiple languages.

Common Use Cases and Queries

The primary use case is the administration and selection of marketing channels during campaign and activity setup. Common operational and reporting queries involve listing available media, analyzing campaign distribution by channel, or validating media usage. Sample SQL patterns include fetching all active media for a list of values (LOV):

SELECT media_id, name FROM ams_media_vl WHERE enabled_flag = 'Y' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE) ORDER BY name;

Or, joining to campaign data for reporting:

SELECT c.campaign_name, m.name AS media_channel FROM ams_campaigns_all_b c, ams_media_vl m WHERE c.media_id = m.media_id;

Developers may also query this table to understand valid media IDs when customizing integrations or data feeds that populate related marketing tables.

Related Objects

As indicated by the extensive foreign key relationships, AMS_MEDIA_B is a critical hub table referenced across the Marketing module and into related areas like Trade Management (OZF). Key dependent objects include:

AMS_MEDIA_TL: The translation table that stores the language-specific names.
AMS_CAMPAIGNS_ALL_B: Campaigns are linked to a primary media type.
AMS_ACT_DELIVERY_METHODS & AMS_OFFERS: Define the delivery channel for activities and offers.
AMS_CAMPAIGN_SCHEDULES_B & AMS_CAT_ACTIVITIES: Associate specific activities with a media type.
AMS_TCOP_CONTACTS & AMS_TCOP_CHANNEL_SUMMARY: Used in Telemarketing (TCOP) for contact and channel performance reporting.
OZF_OFFERS: Demonstrates integration with the Trade Management module for offer media.

This wide network of foreign keys underscores the table's fundamental role in classifying and tracking the channel dimension for virtually all marketing execution entities.

Table: AMS_MEDIA_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_MEDIA_B, object_name:AMS_MEDIA_B, status:VALID, product: AMS - Marketing , description: Specifies all different media that can be used by an activity. , implementation_dba_data: AMS.AMS_MEDIA_B ,
Table: AMS_MEDIA_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_MEDIA_B, object_name:AMS_MEDIA_B, status:VALID, product: AMS - Marketing , description: Specifies all different media that can be used by an activity. , implementation_dba_data: AMS.AMS_MEDIA_B ,
Table: AMS_MEDIA_TL 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_MEDIA_TL, object_name:AMS_MEDIA_TL, status:VALID, product: AMS - Marketing , description: Stores all translated columns. , implementation_dba_data: AMS.AMS_MEDIA_TL ,
Table: AMS_TCOP_CHANNEL_SUMMARY 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TCOP_CHANNEL_SUMMARY, object_name:AMS_TCOP_CHANNEL_SUMMARY, status:VALID, product: AMS - Marketing , description: This table captures summarized contact information per channel , implementation_dba_data: AMS.AMS_TCOP_CHANNEL_SUMMARY ,
Table: AMS_MEDIA_CHANNELS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_MEDIA_CHANNELS, object_name:AMS_MEDIA_CHANNELS, status:VALID, product: AMS - Marketing , description: Stores what channel can handle what kind of media. , implementation_dba_data: AMS.AMS_MEDIA_CHANNELS ,
Table: AMS_MEDIA_TL 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_MEDIA_TL, object_name:AMS_MEDIA_TL, status:VALID, product: AMS - Marketing , description: Stores all translated columns. , implementation_dba_data: AMS.AMS_MEDIA_TL ,
Table: AMS_ACT_DELIVERY_METHODS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_DELIVERY_METHODS, object_name:AMS_ACT_DELIVERY_METHODS, status:VALID, product: AMS - Marketing , description: Stores information for the various activity delivery methods , implementation_dba_data: AMS.AMS_ACT_DELIVERY_METHODS ,
Table: AMS_TCOP_CONTACTS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TCOP_CONTACTS, object_name:AMS_TCOP_CONTACTS, status:VALID, product: AMS - Marketing , description: This table keeps track of the contacts made through fatiguing schedules , implementation_dba_data: AMS.AMS_TCOP_CONTACTS ,
Table: AMS_ACT_DELIVERY_METHODS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_ACT_DELIVERY_METHODS, object_name:AMS_ACT_DELIVERY_METHODS, status:VALID, product: AMS - Marketing , description: Stores information for the various activity delivery methods , implementation_dba_data: AMS.AMS_ACT_DELIVERY_METHODS ,
Table: AMS_CAT_ACTIVITIES 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAT_ACTIVITIES, object_name:AMS_CAT_ACTIVITIES, status:VALID, product: AMS - Marketing , description: This table stores the activities associated with a category if the category is being created for budgets. , implementation_dba_data: AMS.AMS_CAT_ACTIVITIES ,
Table: AMS_TCOP_CHANNEL_SUMMARY 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TCOP_CHANNEL_SUMMARY, object_name:AMS_TCOP_CHANNEL_SUMMARY, status:VALID, product: AMS - Marketing , description: This table captures summarized contact information per channel , implementation_dba_data: AMS.AMS_TCOP_CHANNEL_SUMMARY ,
Table: AMS_TCOP_CONTACTS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TCOP_CONTACTS, object_name:AMS_TCOP_CONTACTS, status:VALID, product: AMS - Marketing , description: This table keeps track of the contacts made through fatiguing schedules , implementation_dba_data: AMS.AMS_TCOP_CONTACTS ,
Table: AMS_MEDIA_CHANNELS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_MEDIA_CHANNELS, object_name:AMS_MEDIA_CHANNELS, status:VALID, product: AMS - Marketing , description: Stores what channel can handle what kind of media. , implementation_dba_data: AMS.AMS_MEDIA_CHANNELS ,
Table: AMS_TCOP_FR_RULES_SETUP 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TCOP_FR_RULES_SETUP, object_name:AMS_TCOP_FR_RULES_SETUP, status:VALID, product: AMS - Marketing , description: This table stores the definition of Fatigue Rules to be used by the Rules Engine. , implementation_dba_data: AMS.AMS_TCOP_FR_RULES_SETUP ,
Table: AMS_TCOP_FR_RULES_SETUP 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_TCOP_FR_RULES_SETUP, object_name:AMS_TCOP_FR_RULES_SETUP, status:VALID, product: AMS - Marketing , description: This table stores the definition of Fatigue Rules to be used by the Rules Engine. , implementation_dba_data: AMS.AMS_TCOP_FR_RULES_SETUP ,
Table: AMS_CAT_ACTIVITIES 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAT_ACTIVITIES, object_name:AMS_CAT_ACTIVITIES, status:VALID, product: AMS - Marketing , description: This table stores the activities associated with a category if the category is being created for budgets. , implementation_dba_data: AMS.AMS_CAT_ACTIVITIES ,
Table: AMS_CUSTOM_SETUPS_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CUSTOM_SETUPS_B, object_name:AMS_CUSTOM_SETUPS_B, status:VALID, product: AMS - Marketing , description: Stores all the custom setups. , implementation_dba_data: AMS.AMS_CUSTOM_SETUPS_B ,
Table: AMS_CAMPAIGN_SCHEDULES_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES_B, object_name:AMS_CAMPAIGN_SCHEDULES_B, status:VALID, product: AMS - Marketing , description: Stores all Campaign Schedules , implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES_B ,
Table: AMS_CUSTOM_SETUPS_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CUSTOM_SETUPS_B, object_name:AMS_CUSTOM_SETUPS_B, status:VALID, product: AMS - Marketing , description: Stores all the custom setups. , implementation_dba_data: AMS.AMS_CUSTOM_SETUPS_B ,
Table: AMS_OFFERS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_OFFERS, object_name:AMS_OFFERS, status:VALID, product: AMS - Marketing , description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. , implementation_dba_data: AMS.AMS_OFFERS ,
Table: AMS_EVENT_REGISTRATIONS 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_EVENT_REGISTRATIONS, object_name:AMS_EVENT_REGISTRATIONS, status:VALID, product: AMS - Marketing , description: Stores all enrollment information for an event, who got registered, who will be attending and their status. , implementation_dba_data: AMS.AMS_EVENT_REGISTRATIONS ,
Table: AMS_EVENT_REGISTRATIONS 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_EVENT_REGISTRATIONS, object_name:AMS_EVENT_REGISTRATIONS, status:VALID, product: AMS - Marketing , description: Stores all enrollment information for an event, who got registered, who will be attending and their status. , implementation_dba_data: AMS.AMS_EVENT_REGISTRATIONS ,
Table: AMS_OFFERS 12.2.2
product: AMS - Marketing , description: This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. , implementation_dba_data: Not implemented in this database ,
Table: AMS_CAMPAIGN_SCHEDULES_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGN_SCHEDULES_B, object_name:AMS_CAMPAIGN_SCHEDULES_B, status:VALID, product: AMS - Marketing , description: Stores all Campaign Schedules , implementation_dba_data: AMS.AMS_CAMPAIGN_SCHEDULES_B ,
View: AMS_MEDIA_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_MEDIA_VL, object_name:AMS_MEDIA_VL, status:VALID, product: AMS - Marketing , description: This view returns all media that can be used by an activity. , implementation_dba_data: APPS.AMS_MEDIA_VL ,
View: AMS_MEDIA_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:AMS.AMS_MEDIA_VL, object_name:AMS_MEDIA_VL, status:VALID, product: AMS - Marketing , description: This view returns all media that can be used by an activity. , implementation_dba_data: APPS.AMS_MEDIA_VL ,
Table: AMS_CAMPAIGNS_ALL_B 12.2.2
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B, object_name:AMS_CAMPAIGNS_ALL_B, status:VALID, product: AMS - Marketing , description: Base table to store the details of a campaign. , implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B ,
Table: AMS_CAMPAIGNS_ALL_B 12.1.1
owner:AMS, object_type:TABLE, fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B, object_name:AMS_CAMPAIGNS_ALL_B, status:VALID, product: AMS - Marketing , description: Base table to store the details of a campaign. , implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B ,