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: OZF.OZF_OFFERS

Object Details

Object Name:	OZF_OFFERS
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_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
OZF_OFFERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OFFER_ID
OZF_OFFERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	QP_LIST_HEADER_ID
OZF_OFFERS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	OFFER_CODE
OZF_OFFERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
OZF_OFFERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUYING_GROUP_CONTACT_ID

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	VARCHAR2	(120)		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.
AUTOPAY_FLAG	VARCHAR2	(1)		Indicated if the Offer can be paid automatically
AUTOPAY_DAYS	NUMBER			Specifies the number of days after the offer completion should Auto Pay occur
AUTOPAY_METHOD	VARCHAR2	(30)		Method of Automatic Payment
AUTOPAY_PARTY_ATTR	VARCHAR2	(30)		Party Attribute for Auto Pay
AUTOPAY_PARTY_ID	NUMBER			Party Identifier for Auto Pay
TIER_LEVEL	VARCHAR2	(30)		Tier level for the Offer
NA_RULE_HEADER_ID	NUMBER			Net Accrual Rule Set Identifier
BENEFICIARY_ACCOUNT_ID	NUMBER			Customer Account Identifier of the beneficiary party
LATEST_NA_COMPLETION_DATE	DATE			Last date on which the Net Accrual Engine processed this Offer
SALES_METHOD_FLAG	VARCHAR2	(1)		indicates if the offer is for direct, indirect sales or both.
ORG_ID	NUMBER			Identifier of Operating Unit
FUND_REQUEST_CURR_CODE	VARCHAR2	(30)		The currency code used in budget request
RESALE_LINE_ID_PROCESSED	NUMBER			Identifier of the lagest resale line that processed in volume accumulation
START_DATE	DATE			Date that offer takes effect

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
,      AUTOPAY_FLAG
,      AUTOPAY_DAYS
,      AUTOPAY_METHOD
,      AUTOPAY_PARTY_ATTR
,      AUTOPAY_PARTY_ID
,      TIER_LEVEL
,      NA_RULE_HEADER_ID
,      BENEFICIARY_ACCOUNT_ID
,      LATEST_NA_COMPLETION_DATE
,      SALES_METHOD_FLAG
,      ORG_ID
,      FUND_REQUEST_CURR_CODE
,      RESALE_LINE_ID_PROCESSED
,      START_DATE
FROM OZF.OZF_OFFERS;

Dependencies

[top of page]

OZF.OZF_OFFERS does not reference any database object

OZF.OZF_OFFERS is referenced by following:

APPS: OZF_EARNING_SUMMARY_MV; OZF_OFFERS