[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_ACTIVITY_PRODUCTS |
|---|---|
| Object Type: | TABLE |
| Owner: | OZF |
| FND Design Data: |  OZF.OZF_ACTIVITY_PRODUCTS
|
| Subobject Name: | |
| Status: | VALID |
OZF_ACTIVITY_PRODUCTS stores the denormalized product eligibility for an Offer and a Campaign Schedule of type Deal or Trade Promotion.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OZF_ACTIVITY_PRODUCTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 ITEM_TYPE
ITEM
|
| OZF_ACTIVITY_PRODUCTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OBJECT_CLASS
OBJECT_ID
ITEM_TYPE
ITEM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACTIVITY_PRODUCT_ID | NUMBER | Yes | Unique Identifier | |
| OBJECT_ID | NUMBER | Yes | Unique identifier of the object specified in Object Type | |
| OBJECT_CLASS | VARCHAR2 | (30) | Type of Schedule or Offer specified in Object Type | |
| OBJECT_TYPE | VARCHAR2 | (30) | Type of Object. Valid values are CSCH for Schedule and OFFR for offer | |
| OBJECT_DESC | VARCHAR2 | (2000) | Object Description | |
| OBJECT_STATUS | VARCHAR2 | (30) | Object Status | |
| START_DATE | DATE | Start Date | ||
| END_DATE | DATE | End Date | ||
| PARENT_ID | NUMBER | Identifier of the Parent Object specified in PARRENT_TYPE | ||
| PARENT_DESC | VARCHAR2 | (250) | Parent Object Description | |
| PARENT_CLASS | VARCHAR2 | (30) | Parent Object Classification | |
| PARENT_TYPE | VARCHAR2 | (30) | Parent Object Type | |
| PARENT_STATUS | VARCHAR2 | (30) | Parent Object Status | |
| OWNER_ID | NUMBER | Object Owner | ||
| ITEM | NUMBER | Item Type Identifier, Valid values are inventory_item _id and category_id | ||
| ITEM_TYPE | VARCHAR2 | (30) | Type of Item. Valid Values are PRODUCT and FAMILY | |
| ITEMS_CATEGORY | NUMBER | Not Used | ||
| SOURCE_CODE | VARCHAR2 | (30) | Source Code of the Object | |
| ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Activity Type Code of the object | |
| ACTIVITY_ID | NUMBER | Activity Identifier | ||
| MARKETING_MEDIUM_ID | NUMBER | Marketing Medium Identifier | ||
| CURRENCY_CODE | VARCHAR2 | (10) | Currency Code | |
| OFFER_CODE | VARCHAR2 | (30) | Offer Code | |
| ASK_FOR_FLAG | VARCHAR2 | (1) | As for flag | |
| ACTIVE_FLAG | VARCHAR2 | (1) | Active Flag | |
| ACTUAL_UNITS | NUMBER | Actual Units sold for the offer | ||
| ACTUAL_REVENUE | NUMBER | Actual revenu earned for the offer | ||
| ACTUAL_COSTS | NUMBER | Actual Costs for the Offer | ||
| ACTUAL_ROI | NUMBER | Actual ROI for the offer | ||
| FORECAST_UNITS | NUMBER | Forecasted Units for the offer | ||
| FORECAST_REVENUE | NUMBER | Forecasted Revenue for the offer | ||
| FORECAST_COSTS | NUMBER | Forecasted Costs for the offer | ||
| FORECAST_ROI | NUMBER | Forecasted ROI for the offer | ||
| ACTUAL_PRODUCT_UNITS | NUMBER | Actual Units sales for the product | ||
| ACTUAL_PRODUCT_REVENUE | NUMBER | Actual revenue for the product | ||
| ACTUAL_PRODUCT_COSTS | NUMBER | Actual Costs for the product | ||
| ACTUAL_PRODUCT_ROI | NUMBER | Actual ROI for the product | ||
| FORECAST_PRODUCT_UNITS | NUMBER | Forecasted product units | ||
| FORECAST_PRODUCT_REVENUE | NUMBER | Forecasted product revenue | ||
| FORECAST_PRODUCT_COSTS | NUMBER | Forecasted product costs | ||
| FORECAST_PRODUCT_ROI | NUMBER | Forecasted product ROI | ||
| LIST_PRICE | NUMBER | List Price | ||
| CONFIDENTIAL_FLAG | VARCHAR2 | (1) | Confidential Flag | |
| CUSTOM_SETUP_ID | NUMBER | Custom Setup Identifier | ||
| LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
| LAST_UPDATED_BY | NUMBER | Standard WHO Column | ||
| CREATION_DATE | DATE | Standard WHO Column | ||
| CREATED_BY | NUMBER | Standard WHO Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
| CUST_INDICATOR | VARCHAR2 | (20) | Indicates if the Offer has customers | |
| ACTUAL_UOM | VARCHAR2 | (3) | Actual UOM | |
| FORECAST_UOM | VARCHAR2 | (3) | Forecasted UOM | |
| DISCOUNT | NUMBER | Discount of the item |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_PRODUCT_ID
, OBJECT_ID
, OBJECT_CLASS
, OBJECT_TYPE
, OBJECT_DESC
, OBJECT_STATUS
, START_DATE
, END_DATE
, PARENT_ID
, PARENT_DESC
, PARENT_CLASS
, PARENT_TYPE
, PARENT_STATUS
, OWNER_ID
, ITEM
, ITEM_TYPE
, ITEMS_CATEGORY
, SOURCE_CODE
, ACTIVITY_TYPE_CODE
, ACTIVITY_ID
, MARKETING_MEDIUM_ID
, CURRENCY_CODE
, OFFER_CODE
, ASK_FOR_FLAG
, ACTIVE_FLAG
, ACTUAL_UNITS
, ACTUAL_REVENUE
, ACTUAL_COSTS
, ACTUAL_ROI
, FORECAST_UNITS
, FORECAST_REVENUE
, FORECAST_COSTS
, FORECAST_ROI
, ACTUAL_PRODUCT_UNITS
, ACTUAL_PRODUCT_REVENUE
, ACTUAL_PRODUCT_COSTS
, ACTUAL_PRODUCT_ROI
, FORECAST_PRODUCT_UNITS
, FORECAST_PRODUCT_REVENUE
, FORECAST_PRODUCT_COSTS
, FORECAST_PRODUCT_ROI
, LIST_PRICE
, CONFIDENTIAL_FLAG
, CUSTOM_SETUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CUST_INDICATOR
, ACTUAL_UOM
, FORECAST_UOM
, DISCOUNT
FROM OZF.OZF_ACTIVITY_PRODUCTS;
OZF.OZF_ACTIVITY_PRODUCTS does not reference any database object
OZF.OZF_ACTIVITY_PRODUCTS is referenced by following:
APPS
OZF_ACTIVITY_PRODUCTS
|
|
|
|