eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AMS_CAMPAIGNS_ALL_B

Product:	AMS - Marketing
Description:	Base table to store the details of a campaign.
Implementation/DBA Data:	AMS.AMS_CAMPAIGNS_ALL_B

Primary Key: AMS_CAMPAIGNS_ALL_B_PK

CAMPAIGN_ID

Primary Key: AMS_CAMPAIGNS_ALL_B_UK1

SOURCE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGNS_ALL_B.PARENT_CAMPAIGN_ID
AMS_CAMPAIGNS_ALL_B	JTF_TASKS_B	AMS_CAMPAIGNS_ALL_B.TASK_ID
AMS_CAMPAIGNS_ALL_B	JTF_LOC_HIERARCHIES_B	AMS_CAMPAIGNS_ALL_B.CITY_ID
AMS_CAMPAIGNS_ALL_B	AMS_MEDIA_B	AMS_CAMPAIGNS_ALL_B.MEDIA_ID
AMS_CAMPAIGNS_ALL_B	AMS_MEDIA_CHANNELS	AMS_CAMPAIGNS_ALL_B.CHANNEL_ID
AMS_CAMPAIGNS_ALL_B	FND_APPLICATION	AMS_CAMPAIGNS_ALL_B.APPLICATION_ID
AMS_CAMPAIGNS_ALL_B	OZF_FUNDS_ALL_B	AMS_CAMPAIGNS_ALL_B.FUND_SOURCE_ID
AMS_CAMPAIGNS_ALL_B	JTF_RS_RESOURCE_EXTNS	AMS_CAMPAIGNS_ALL_B.OWNER_USER_ID
AMS_CAMPAIGNS_ALL_B	AMS_EVENT_OFFERS_ALL_B	AMS_CAMPAIGNS_ALL_B.CHANNEL_ID
AMS_CAMPAIGNS_ALL_B	AMS_EVENT_HEADERS_ALL_B	AMS_CAMPAIGNS_ALL_B.CHANNEL_ID
AMS_CAMPAIGNS_ALL_B	AMS_USER_STATUSES_B	AMS_CAMPAIGNS_ALL_B.USER_STATUS_ID
AMS_ACT_ACCESS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_ACCESS.ACT_ACCESS_TO_OBJECT_ID
AMS_ACT_BUDGETS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID
AMS_ACT_BUDGETS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_BUDGETS.BUDGET_SOURCE_ID
AMS_ACT_FORECASTS_ALL	AMS_CAMPAIGNS_ALL_B	AMS_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID
AMS_ACT_GEO_AREAS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_GEO_AREAS.ACT_GEO_AREA_USED_BY_ID
AMS_ACT_MARKET_SEGMENTS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_MARKET_SEGMENTS.ACT_MARKET_SEGMENT_USED_BY_ID
AMS_ACT_MESSAGES	AMS_CAMPAIGNS_ALL_B	AMS_ACT_MESSAGES.MESSAGE_USED_BY_ID
AMS_ACT_METRICS_ALL	AMS_CAMPAIGNS_ALL_B	AMS_ACT_METRICS_ALL.ACT_METRIC_USED_BY_ID
AMS_ACT_METRIC_FACTS_ALL	AMS_CAMPAIGNS_ALL_B	AMS_ACT_METRIC_FACTS_ALL.ACT_METRIC_USED_BY_ID
AMS_ACT_OBJECTIVES	AMS_CAMPAIGNS_ALL_B	AMS_ACT_OBJECTIVES.ACT_OBJECTIVE_USED_BY_ID
AMS_ACT_OFFERS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_OFFERS.ACT_OFFER_USED_BY_ID
AMS_ACT_PARTNERS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_PARTNERS.ACT_PARTNER_USED_BY_ID
AMS_ACT_PRODUCTS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_PRODUCTS.ACT_PRODUCT_USED_BY_ID
AMS_ACT_SCRIPTS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_SCRIPTS.ACT_SCRIPT_USED_BY_ID
AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGNS_ALL_B.PARENT_CAMPAIGN_ID
AMS_CAMPAIGNS_ALL_TL	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGNS_ALL_TL.CAMPAIGN_ID
AMS_CAMPAIGN_RELATIONS	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGN_RELATIONS.CHILD_CAMPAIGN_ID
AMS_CAMPAIGN_RELATIONS	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGN_RELATIONS.PARENT_CAMPAIGN_ID
AMS_CAMPAIGN_SCHEDULES_B	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGN_SCHEDULES_B.CAMPAIGN_ID
AMS_CAMPAIGN_SCHEDULES	AMS_CAMPAIGNS_ALL_B	AMS_CAMPAIGN_SCHEDULES.CAMPAIGN_ID
AMS_DIALOGS_ALL_B	AMS_CAMPAIGNS_ALL_B	AMS_DIALOGS_ALL_B.PROGRAM_ID
AMS_EVENT_HEADERS_ALL_B	AMS_CAMPAIGNS_ALL_B	AMS_EVENT_HEADERS_ALL_B.FUND_SOURCE_ID
AMS_EVENT_OFFERS_ALL_B	AMS_CAMPAIGNS_ALL_B	AMS_EVENT_OFFERS_ALL_B.FUND_SOURCE_ID
AMS_IBA_CAMPAIGN_RULES	AMS_CAMPAIGNS_ALL_B	AMS_IBA_CAMPAIGN_RULES.CAMPAIGN_ID
AMS_IBA_CAMP_POSTINGS	AMS_CAMPAIGNS_ALL_B	AMS_IBA_CAMP_POSTINGS.OBJECT_ID
AMS_LIST_ENTRY_USAGES	AMS_CAMPAIGNS_ALL_B	AMS_LIST_ENTRY_USAGES.CAMPAIGN_ID
AMS_OBJECT_ASSOCIATIONS	AMS_CAMPAIGNS_ALL_B	AMS_OBJECT_ASSOCIATIONS.MASTER_OBJECT_ID
AMS_OBJECT_ASSOCIATIONS	AMS_CAMPAIGNS_ALL_B	AMS_OBJECT_ASSOCIATIONS.USING_OBJECT_ID
AMS_OBJECT_ATTRIBUTES	AMS_CAMPAIGNS_ALL_B	AMS_OBJECT_ATTRIBUTES.OBJECT_ID
AMS_TRIGGERS	AMS_CAMPAIGNS_ALL_B	AMS_TRIGGERS.TRIGGER_CREATED_FOR_ID
AST_GRP_CAMPAIGNS	AMS_CAMPAIGNS_ALL_B	AST_GRP_CAMPAIGNS.CAMPAIGN_ID
OZF_ACTIVITY_HL_DENORM	AMS_CAMPAIGNS_ALL_B	OZF_ACTIVITY_HL_DENORM.CAMPAIGN_ID
OZF_ACT_BUDGETS	AMS_CAMPAIGNS_ALL_B	OZF_ACT_BUDGETS.ACT_BUDGET_USED_BY_ID
OZF_ACT_BUDGETS	AMS_CAMPAIGNS_ALL_B	OZF_ACT_BUDGETS.BUDGET_SOURCE_ID
OZF_ACT_FORECASTS_ALL	AMS_CAMPAIGNS_ALL_B	OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID
OZF_ACT_OFFERS	AMS_CAMPAIGNS_ALL_B	OZF_ACT_OFFERS.ACT_OFFER_USED_BY_ID
OZF_OBJECT_FUND_SUMMARY	AMS_CAMPAIGNS_ALL_B	OZF_OBJECT_FUND_SUMMARY.OBJECT_ID
AST_RS_CAMPAIGNS	AMS_CAMPAIGNS_ALL_B	AST_RS_CAMPAIGNS.CAMPAIGN_ID