FND Design Data [Home] [Help]

Table: AMS_MEDIA_B

Product: AMS - Marketing
Description: Specifies all different media that can be used by an activity.
Implementation/DBA Data: TableAMS.AMS_MEDIA_B
Primary Key: AMS_MEDIA_B_PK
  1. ColumnMEDIA_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableAMS_ACT_DELIVERY_METHODS FK Joins to AMS_MEDIA_B AMS_ACT_DELIVERY_METHODS.ACT_DELIVERY_METHOD_USED_BY_ID
TableAMS_CAMPAIGNS_ALL_B FK Joins to AMS_MEDIA_B AMS_CAMPAIGNS_ALL_B.MEDIA_ID
TableAMS_CAMPAIGN_SCHEDULES_B FK Joins to AMS_MEDIA_B AMS_CAMPAIGN_SCHEDULES_B.ACTIVITY_ID
TableAMS_CAT_ACTIVITIES FK Joins to AMS_MEDIA_B AMS_CAT_ACTIVITIES.ACTIVITY_ID
TableAMS_CUSTOM_SETUPS_B FK Joins to AMS_MEDIA_B AMS_CUSTOM_SETUPS_B.MEDIA_ID
TableAMS_EVENT_REGISTRATIONS FK Joins to AMS_MEDIA_B AMS_EVENT_REGISTRATIONS.INBOUND_MEDIA_ID
TableAMS_MEDIA_CHANNELS FK Joins to AMS_MEDIA_B AMS_MEDIA_CHANNELS.MEDIA_ID
TableAMS_MEDIA_TL FK Joins to AMS_MEDIA_B AMS_MEDIA_TL.MEDIA_ID
TableAMS_OFFERS FK Joins to AMS_MEDIA_B AMS_OFFERS.ACTIVITY_MEDIA_ID
TableAMS_TCOP_CHANNEL_SUMMARY FK Joins to AMS_MEDIA_B AMS_TCOP_CHANNEL_SUMMARY.MEDIA_ID
TableAMS_TCOP_CONTACTS FK Joins to AMS_MEDIA_B AMS_TCOP_CONTACTS.MEDIA_ID
TableAMS_TCOP_FR_RULES_SETUP FK Joins to AMS_MEDIA_B AMS_TCOP_FR_RULES_SETUP.CHANNEL_ID
TableOZF_OFFERS FK Joins to AMS_MEDIA_B OZF_OFFERS.ACTIVITY_MEDIA_ID