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_ACT_OFFERS

Product:	AMS - Marketing
Description:	Holds the high level details of promotional offers related to a campaign
Implementation/DBA Data:	Not implemented in this database

Primary Key: AMS_ACT_OFFERS_PK

ACTIVITY_OFFER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_ACT_OFFERS	AMS_CAMPAIGNS_ALL_B	AMS_ACT_OFFERS.ACT_OFFER_USED_BY_ID
AMS_ACT_OFFERS	QP_LIST_HEADERS_B	AMS_ACT_OFFERS.QP_LIST_HEADER_ID
AMS_CAMPAIGN_SCHEDULES	AMS_ACT_OFFERS	AMS_CAMPAIGN_SCHEDULES.ACTIVITY_OFFER_ID
AMS_IBA_CAMPAIGN_RULES	AMS_ACT_OFFERS	AMS_IBA_CAMPAIGN_RULES.ACTIVITY_OFFER_ID
AMS_TRIGGER_ACTIONS	AMS_ACT_OFFERS	AMS_TRIGGER_ACTIONS.ACTIVITY_OFFER_ID
AMS_TRIGGER_ACTIONS	AMS_ACT_OFFERS	AMS_TRIGGER_ACTIONS.ACTIVITY_OFFER_ID
AS_LEAD_LINES_ALL	AMS_ACT_OFFERS	AS_LEAD_LINES_ALL.OFFER_ID
AS_SALES_LEADS	AMS_ACT_OFFERS	AS_SALES_LEADS.OFFER_ID
AS_SALES_LEAD_LINES	AMS_ACT_OFFERS	AS_SALES_LEAD_LINES.OFFER_ID