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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AMS.AMS_ACT_OFFERS

Object Details

Object Name:	AMS_ACT_OFFERS
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_ACT_OFFERS
Subobject Name:
Status:	VALID

AMS_ACT_OFFERS_B describes the bundling of promotional components for a Campaign. All the details are stored in pricing tables. This table stores a reference to that.
An example offer could be 'Internet access for 1$ a month for the first 3 months if signing a two year contract'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_OFFERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_OFFER_ID
AMS_ACT_OFFERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARC_ACT_OFFER_USED_BY ACT_OFFER_USED_BY_ID
AMS_ACT_OFFERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QP_LIST_HEADER_ID
AMS_ACT_OFFERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
AMS_ACT_OFFERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFER_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_OFFER_ID	NUMBER		Yes	Unique Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes.
ACT_OFFER_USED_BY_ID	NUMBER		Yes	Id of the Activity using this offer .For example Campaign Id.
ARC_ACT_OFFER_USED_BY	VARCHAR2	(30)	Yes	Indicates whether the Activity is used by Campaigns or Events.
PRIMARY_OFFER_FLAG	VARCHAR2	(1)	Yes	Indicates whether this Offer is the Primary offer of this Activity. There can be only one Primary Offer per activity.
OFFER_TYPE	VARCHAR2	(30)		Indicates whether the offer is a Simple discount or Accrual or Order Value discount, Promotional Goods or Lumpsum Discount
OFFER_CODE	VARCHAR2	(30)		Unique code given for the offer.
QP_LIST_HEADER_ID	NUMBER		Yes	List header id of the QP_LIST_HEADERS_VL
ACTIVE_PERIOD_SET	VARCHAR2	(240)		Refers to General Ledger period sets. Example values are Accounting, fiscal.
ACTIVE_PERIOD	VARCHAR2	(30)		Refers to General Ledger periods. Used in conjunction with the period set to denote if it is a financial quarter, fiscal month and like.
START_DATE	DATE			Date offer is valid from
END_DATE	DATE			Date the ofer is valid till.
ORDER_DATE_FROM	DATE			Start of the order dates the offer is valid from
ORDER_DATE_TO	DATE			Endind order date the offer is valid till.
SHIP_DATE_FROM	DATE			Offer will be valid if the order is shipped from this date
SHIP_DATE_TO	DATE			Offer will be valid if the order is shipped before this date
PERF_DATE_FROM	DATE			Performance measurement dates for the retailer
PERF_DATE_TO	DATE			Performance measurement dates for the retailer
STATUS_CODE	VARCHAR2	(30)		Status of the offer
STATUS_DATE	DATE			Date of the last status change
OFFER_AMOUNT	NUMBER	(15)		Lumpsum offer amount, Used for Offer Type - Lumpsum
LUMPSUM_PAYMENT_TYPE	VARCHAR2	(30)		The lumpsum payment type
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
CUSTOM_SETUP_ID	NUMBER			Denotes the custom setup used to create this offer.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACTIVITY_OFFER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ACT_OFFER_USED_BY_ID
,      ARC_ACT_OFFER_USED_BY
,      PRIMARY_OFFER_FLAG
,      OFFER_TYPE
,      OFFER_CODE
,      QP_LIST_HEADER_ID
,      ACTIVE_PERIOD_SET
,      ACTIVE_PERIOD
,      START_DATE
,      END_DATE
,      ORDER_DATE_FROM
,      ORDER_DATE_TO
,      SHIP_DATE_FROM
,      SHIP_DATE_TO
,      PERF_DATE_FROM
,      PERF_DATE_TO
,      STATUS_CODE
,      STATUS_DATE
,      OFFER_AMOUNT
,      LUMPSUM_PAYMENT_TYPE
,      SECURITY_GROUP_ID
,      CUSTOM_SETUP_ID
FROM AMS.AMS_ACT_OFFERS;

Dependencies

[top of page]

AMS.AMS_ACT_OFFERS does not reference any database object

AMS.AMS_ACT_OFFERS is referenced by following:

APPS: AMS_ACT_OFFERS