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_OFFERS

Object Details

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

This is a surrogate table to QP_LIST_HEADERS_B for Offers related information. QP_LIST_HEADER_ID is the foreign key to QP_LIST_HEADERS_B. This table will capture status, peformance dates and lumpsum related offer types. Qualifier_id and Qualifier_type, customer_reference are added for deal type of Offers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_OFFERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
AMS_OFFERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUYING_GROUP_CONTACT_ID
AMS_OFFERS_UK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFER_ID
AMS_OFFERS_UK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QP_LIST_HEADER_ID
AMS_OFFERS_UK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFER_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
OFFER_ID	NUMBER		Yes	Unique Identifier for an offer
QP_LIST_HEADER_ID	NUMBER		Yes	Refers to the list header id in qp list headers table.
OFFER_TYPE	VARCHAR2	(30)	Yes	Indicates the Type of the Offer
OFFER_CODE	VARCHAR2	(30)	Yes	Unique Source Code generated for the Offer. This will be the Modifier Name in Advanced Pricing
REUSABLE	VARCHAR2	(1)		Indicates If the Offer is a reusable offer across campaigns
CUSTOM_SETUP_ID	NUMBER		Yes	Indicates the custom setup used to create the offer.
USER_STATUS_ID	NUMBER		Yes	User defined status for the offer
OWNER_ID	NUMBER			Owner of the Offer
WF_ITEM_KEY	NUMBER			A unique identifier of the workflow approval process for the offer
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes
CUSTOMER_REFERENCE	VARCHAR2	(240)		Any customer related references for deal type of offers
BUYING_GROUP_CONTACT_ID	NUMBER			Buying Group contact. Only used for deal type of offers
PERF_DATE_FROM	DATE			Performance Dates from
PERF_DATE_TO	DATE			Performance Date to
STATUS_CODE	VARCHAR2	(30)		System Status Code for the user_status_id
STATUS_DATE	DATE			The date on which the status is assigned
ORDER_VALUE_DISCOUNT_TYPE	VARCHAR2	(30)		Indicates the type of discount for order value type of discounts
MODIFIER_LEVEL_CODE	VARCHAR2	(30)		Indicates the level at which the offer will be qualified.
OFFER_AMOUNT	NUMBER			This is the committed amount for the offer
LUMPSUM_AMOUNT	NUMBER			This could hold either percentage, quantity and amount based on the distribution type.
LUMPSUM_PAYMENT_TYPE	VARCHAR2	(30)		Indicates how the lumpsum amount will be paid. Possible values are check, credit.
SECURITY_GROUP_ID	NUMBER			Used for hosted environments
DISTRIBUTION_TYPE	VARCHAR2	(30)		Indicates how the lumpsum amount will be distributed for all the products.
BUDGET_AMOUNT_FC	NUMBER			Total estimated amount in Functional Currency
BUDGET_AMOUNT_TC	NUMBER			Total estimated amount in Transactional Currency
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)		Transactional Currency Code
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Functional Currency Code
ACCOUNT_CLOSED_FLAG	VARCHAR2	(1)		Used for budgeting purposes
ACTIVITY_MEDIA_ID	NUMBER			Indicates the activity associated with the offer. e.g. Store display.
QUALIFIER_ID	NUMBER			Associated Identifier for the qualifier type.
QUALIFIER_TYPE	VARCHAR2	(30)		This column is only used for Lumpsum and Trade Deal offer types. Indicates if the customer is a list,segment,buying group or a customer
BUDGET_OFFER_YN	VARCHAR2	(1)		Flag indicating that the offer is created from a fully accrued budget
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
QUALIFIER_DELETED	VARCHAR2	(1)		Flag to indicate that qualifiers are deleted after the AMS Web Execution: Refresh Offer parties and products is run
BREAK_TYPE	VARCHAR2	(30)		This column is for promotional Goods offers only.
VOLUME_OFFER_TYPE	VARCHAR2	(30)		Type of volume offer lines
CONFIDENTIAL_FLAG	VARCHAR2	(1)		The flag that indicats if the offer is visible to the public.
BUDGET_SOURCE_TYPE	VARCHAR2	(30)		The type of budget source.
BUDGET_SOURCE_ID	NUMBER			Identifier of budget source
RETROACTIVE	VARCHAR2	(1)		Applies only for offers of type Volume Offers. Indicates if the discount are retroactive.
SOURCE_FROM_PARENT	VARCHAR2	(1)		Budget source from parent object flag.
LAST_RECAL_DATE	DATE			Last date of budget recalculation.
BUYER_NAME	VARCHAR2	(240)		Free Format Buyer Name
DATE_QUALIFIER_PROFILE_VALUE	VARCHAR2	(1)		Profile value that indicates if store dates in qualifer.

Query Text

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


SELECT OFFER_ID
,      QP_LIST_HEADER_ID
,      OFFER_TYPE
,      OFFER_CODE
,      REUSABLE
,      CUSTOM_SETUP_ID
,      USER_STATUS_ID
,      OWNER_ID
,      WF_ITEM_KEY
,      OBJECT_VERSION_NUMBER
,      CUSTOMER_REFERENCE
,      BUYING_GROUP_CONTACT_ID
,      PERF_DATE_FROM
,      PERF_DATE_TO
,      STATUS_CODE
,      STATUS_DATE
,      ORDER_VALUE_DISCOUNT_TYPE
,      MODIFIER_LEVEL_CODE
,      OFFER_AMOUNT
,      LUMPSUM_AMOUNT
,      LUMPSUM_PAYMENT_TYPE
,      SECURITY_GROUP_ID
,      DISTRIBUTION_TYPE
,      BUDGET_AMOUNT_FC
,      BUDGET_AMOUNT_TC
,      TRANSACTION_CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      ACCOUNT_CLOSED_FLAG
,      ACTIVITY_MEDIA_ID
,      QUALIFIER_ID
,      QUALIFIER_TYPE
,      BUDGET_OFFER_YN
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      QUALIFIER_DELETED
,      BREAK_TYPE
,      VOLUME_OFFER_TYPE
,      CONFIDENTIAL_FLAG
,      BUDGET_SOURCE_TYPE
,      BUDGET_SOURCE_ID
,      RETROACTIVE
,      SOURCE_FROM_PARENT
,      LAST_RECAL_DATE
,      BUYER_NAME
,      DATE_QUALIFIER_PROFILE_VALUE
FROM AMS.AMS_OFFERS;

Dependencies

[top of page]

AMS.AMS_OFFERS does not reference any database object

AMS.AMS_OFFERS is referenced by following:

APPS: AMS_OFFERS