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

Product:	OZF - Trade Management
Description:	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.
Implementation/DBA Data:	OZF.OZF_OFFERS

Primary Key: OZF_OFFERS_PK

OFFER_ID

Primary Key: OZF_OFFERS_UK1

OFFER_CODE

Primary Key: OZF_OFFERS_UK2

QP_LIST_HEADER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OZF_OFFERS	AMS_USER_STATUSES_B	OZF_OFFERS.USER_STATUS_ID
OZF_OFFERS	AMS_CUSTOM_SETUPS_B	OZF_OFFERS.CUSTOM_SETUP_ID
OZF_OFFERS	AMS_MEDIA_B	OZF_OFFERS.ACTIVITY_MEDIA_ID
OZF_OFFERS	JTF_RS_RESOURCE_EXTNS	OZF_OFFERS.OWNER_ID
OZF_OFFERS	HZ_PARTIES	OZF_OFFERS.BUYING_GROUP_CONTACT_ID
OZF_OFFERS	QP_LIST_HEADERS_B	OZF_OFFERS.QP_LIST_HEADER_ID
OZF_OFFERS	OZF_FUNDS_ALL_B	OZF_OFFERS.BUDGET_SOURCE_ID
OZF_OFFERS	OZF_NA_RULE_HEADERS_B	OZF_OFFERS.NA_RULE_HEADER_ID
OZF_ACTIVITY_CUSTOMERS	OZF_OFFERS	OZF_ACTIVITY_CUSTOMERS.OBJECT_ID
OZF_ACTIVITY_PRODUCTS	OZF_OFFERS	OZF_ACTIVITY_PRODUCTS.OBJECT_ID
OZF_ACT_FORECASTS_ALL	OZF_OFFERS	OZF_ACT_FORECASTS_ALL.ACT_FCAST_USED_BY_ID
OZF_ACT_OFFERS	OZF_OFFERS	OZF_ACT_OFFERS.QP_LIST_HEADER_ID
OZF_FORECAST_CUSTOMERS	OZF_OFFERS	OZF_FORECAST_CUSTOMERS.OBJ_ID
OZF_FORECAST_DIMENTIONS	OZF_OFFERS	OZF_FORECAST_DIMENTIONS.OBJ_ID
OZF_FORECAST_PERIODS	OZF_OFFERS	OZF_FORECAST_PERIODS.OBJ_ID
OZF_FORECAST_PRODUCTS	OZF_OFFERS	OZF_FORECAST_PRODUCTS.OBJ_ID
OZF_FORECAST_PROD_EXCLUSIONS	OZF_OFFERS	OZF_FORECAST_PROD_EXCLUSIONS.OBJ_ID
OZF_OFFER_ADJUSTMENTS_B	OZF_OFFERS	OZF_OFFER_ADJUSTMENTS_B.LIST_HEADER_ID
OZF_OFFER_DISCOUNT_LINES	OZF_OFFERS	OZF_OFFER_DISCOUNT_LINES.OFFER_ID
OZF_OFFER_DISCOUNT_PRODUCTS	OZF_OFFERS	OZF_OFFER_DISCOUNT_PRODUCTS.OFFER_ID
OZF_OFFER_PERFORMANCES	OZF_OFFERS	OZF_OFFER_PERFORMANCES.USED_BY_ID
OZF_OFFER_QUALIFIERS	OZF_OFFERS	OZF_OFFER_QUALIFIERS.OFFER_ID
OZF_PRICE_LIST_ATTRIBUTES	OZF_OFFERS	OZF_PRICE_LIST_ATTRIBUTES.QP_LIST_HEADER_ID
OZF_RELATED_DEAL_LINES	OZF_OFFERS	OZF_RELATED_DEAL_LINES.QP_LIST_HEADER_ID
OZF_REQUEST_HEADERS_ALL_B	OZF_OFFERS	OZF_REQUEST_HEADERS_ALL_B.OFFER_ID
OZF_VOLUME_OFFER_TIERS	OZF_OFFERS	OZF_VOLUME_OFFER_TIERS.QP_LIST_HEADER_ID