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]

VIEW: APPS.OZF_P_CAMPAIGN_OFFERS_V

Object Details

Object Name:	OZF_P_CAMPAIGN_OFFERS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view is created for the general information about the offers associated with marketing campaigns.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_OFFER_ID	NUMBER		Yes	Unique Identifier
CAMPAIGN_ID	NUMBER		Yes	Identifier of the campaign
CAMPAIGN_NAME	VARCHAR2	(240)	Yes	Name of the campaign
CAMPAIGN_START_DATE	DATE			Actual execution start date for the campaign
CAMPAIGN_END_DATE	DATE			Actual execution end date for the campaign
CAMPAIGN_SOURCE_CODE	VARCHAR2	(30)	Yes	Campaign source code
CAMPAIGN_STATUS_CODE	VARCHAR2	(30)	Yes	System status code for campaign
OFFER_NAME	VARCHAR2	(240)	Yes	Name of the offer
OFFER_CODE	VARCHAR2	(30)	Yes	Offer source code
OFFER_TYPE	VARCHAR2	(4000)		Offer type
OFFER_CURRENCY_CODE	VARCHAR2	(30)		Currency code for Offer
START_DATE_EFFECTIVE	DATE			Offer start date
END_DATE_EFFECTIVE	DATE			Offer end date
AUTOMATIC_FLAG	VARCHAR2	(1)		Flag that indicates if the offer is automatic
PRIMARY_OFFER_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the the offer is the primary offer of the campaign
QP_LIST_HEADER_ID	NUMBER		Yes	Identifier of the price list header
ORDER_DATE_FROM	DATE			Start of the order dates the offer is valid from
ORDER_DATE_TO	DATE			End of the order dates the offer is valid from
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 till 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 code of the offer
STATUS_DATE	DATE			Date of the last status change
OFFER_AMOUNT	NUMBER			Offer Amount
LUMPSUM_PAYMENT_TYPE	VARCHAR2	(30)		Lumpsum Payment type
REUSABLE	VARCHAR2	(1)		Flag to indicate if the offer is reusable.
LUMPSUM_AMOUNT	NUMBER			Lumpsum Amount. could be percent, amount or quantity.

Query Text

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


SELECT ACTIVITY_OFFER_ID
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      CAMPAIGN_START_DATE
,      CAMPAIGN_END_DATE
,      CAMPAIGN_SOURCE_CODE
,      CAMPAIGN_STATUS_CODE
,      OFFER_NAME
,      OFFER_CODE
,      OFFER_TYPE
,      OFFER_CURRENCY_CODE
,      START_DATE_EFFECTIVE
,      END_DATE_EFFECTIVE
,      AUTOMATIC_FLAG
,      PRIMARY_OFFER_FLAG
,      QP_LIST_HEADER_ID
,      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
,      REUSABLE
,      LUMPSUM_AMOUNT
FROM APPS.OZF_P_CAMPAIGN_OFFERS_V;

Dependencies

[top of page]

APPS.OZF_P_CAMPAIGN_OFFERS_V references the following:

APPS: AMS_CAMPAIGNS_VL; AMS_UTILITY_PVT - show dependent code; OZF_ACT_OFFERS; OZF_OFFERS; QP_LIST_HEADERS_VL

APPS.OZF_P_CAMPAIGN_OFFERS_V is not referenced by any database object