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