Table: AMS_CAMPAIGN_SCHEDULES_B

Product:	AMS - Marketing
Description:	Stores all Campaign Schedules
Implementation/DBA Data:	AMS.AMS_CAMPAIGN_SCHEDULES_B

Primary Key: AMS_CAMPAIGN_SCHEDULES_B_PK

1. SCHEDULE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_CAMPAIGN_SCHEDULES_B		AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGN_SCHEDULES_B.CAMPAIGN_ID
AMS_CAMPAIGN_SCHEDULES_B		JTF_TASKS_B	AMS_CAMPAIGN_SCHEDULES_B.TASK_ID
AMS_CAMPAIGN_SCHEDULES_B		AMS_MEDIA_B	AMS_CAMPAIGN_SCHEDULES_B.ACTIVITY_ID
AMS_CAMPAIGN_SCHEDULES_B		AMS_TRIGGERS	AMS_CAMPAIGN_SCHEDULES_B.TRIGGER_ID
AMS_CAMPAIGN_SCHEDULES_B		AMS_CHANNELS_B	AMS_CAMPAIGN_SCHEDULES_B.MARKETING_MEDIUM_ID
AMS_CAMPAIGN_SCHEDULES_B		FND_LANGUAGES	AMS_CAMPAIGN_SCHEDULES_B.LANGUAGE_CODE
AMS_CAMPAIGN_SCHEDULES_B		AMS_USER_STATUSES_B	AMS_CAMPAIGN_SCHEDULES_B.USER_STATUS_ID
AMS_CAMPAIGN_SCHEDULES_B		JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGN_SCHEDULES_B.OWNER_USER_ID
AMS_CAMPAIGN_SCHEDULES_B		JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGN_SCHEDULES_B.APPROVER_USER_ID
AMS_CAMPAIGN_SCHEDULES_B		JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGN_SCHEDULES_B.NOTIFY_USER_ID
AMS_ACT_LISTS		AMS_CAMPAIGN_SCHEDULES_B	AMS_ACT_LISTS.LIST_USED_BY_ID
AMS_CAMPAIGN_SCHEDULES_TL		AMS_CAMPAIGN_SCHEDULES_B	AMS_CAMPAIGN_SCHEDULES_TL.SCHEDULE_ID
AMS_DM_OPT_TGT_METRICS		AMS_CAMPAIGN_SCHEDULES_B	AMS_DM_OPT_TGT_METRICS.SCHEDULE_ID
AMS_TCOP_CHANNEL_SUM_DTL		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_CHANNEL_SUM_DTL.SCHEDULE_ID
AMS_TCOP_CONTACTS		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_CONTACTS.SCHEDULE_ID
AMS_TCOP_CONTACT_SUM_DTL		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_CONTACT_SUM_DTL.SCHEDULE_ID
AMS_TCOP_FATIGUED_BY		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_FATIGUED_BY.SCHEDULE_ID
AMS_TCOP_PRVW_CONTACTS		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_PRVW_CONTACTS.SCHEDULE_ID
AMS_TCOP_PRVW_FTG_BY		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_PRVW_FTG_BY.SCHEDULE_ID
AMS_TCOP_REQUESTS		AMS_CAMPAIGN_SCHEDULES_B	AMS_TCOP_REQUESTS.SCHEDULE_ID