[Home] [Help]
[Dependency Information]
Object Name: | OZF_ACTIVITY_PRODUCTS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
OZF_ACTIVITY_PRODUCTS_TEMP is used as temporary table to store the denormalized product eligibility for Offer and Campaign Schedules till the concurrent program to populate the tables finishes processing.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_ACTIVITY_PRODUCTS_TEMP_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() |
OZF_ACTIVITY_PRODUCTS_T_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_PRODUCT_ID | NUMBER | Unique Identifier | ||
OBJECT_ID | NUMBER | Object Id | ||
OBJECT_CLASS | VARCHAR2 | (30) | Object Class | |
OBJECT_TYPE | VARCHAR2 | (30) | Object Type | |
OBJECT_DESC | VARCHAR2 | (2000) | Object Desc | |
OBJECT_STATUS | VARCHAR2 | (30) | Object Status | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
PARENT_ID | NUMBER | Parent Id | ||
PARENT_DESC | VARCHAR2 | (250) | Parent Desc | |
PARENT_CLASS | VARCHAR2 | (30) | Parent Class | |
PARENT_TYPE | VARCHAR2 | (30) | Parent Type | |
PARENT_STATUS | VARCHAR2 | (30) | Parent Status | |
OWNER_ID | NUMBER | Owner Id | ||
ITEM | NUMBER | Item | ||
ITEM_TYPE | VARCHAR2 | (30) | Item Type | |
ITEMS_CATEGORY | NUMBER | Not Used | ||
SOURCE_CODE | VARCHAR2 | (30) | Source Code | |
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Activity Type Code | |
ACTIVITY_ID | NUMBER | Activity Id | ||
MARKETING_MEDIUM_ID | NUMBER | Marketing Medium Id | ||
CURRENCY_CODE | VARCHAR2 | (10) | Currency Code | |
OFFER_CODE | VARCHAR2 | (30) | Offer Code | |
ASK_FOR_FLAG | VARCHAR2 | (1) | Ask For Flag | |
ACTIVE_FLAG | VARCHAR2 | (1) | Active Flag | |
ACTUAL_UNITS | NUMBER | Actual Units | ||
ACTUAL_REVENUE | NUMBER | Actual Revenue | ||
ACTUAL_COSTS | NUMBER | Actual Costs | ||
ACTUAL_ROI | NUMBER | Actual Roi | ||
FORECAST_UNITS | NUMBER | Forecast Units | ||
FORECAST_REVENUE | NUMBER | Forecast Revenue | ||
FORECAST_COSTS | NUMBER | Forecast Costs | ||
FORECAST_ROI | NUMBER | Forecast Roi | ||
ACTUAL_PRODUCT_UNITS | NUMBER | Actual Product Units | ||
ACTUAL_PRODUCT_REVENUE | NUMBER | Actual Product Revenue | ||
ACTUAL_PRODUCT_COSTS | NUMBER | Actual Product Costs | ||
ACTUAL_PRODUCT_ROI | NUMBER | Actual Product Roi | ||
FORECAST_PRODUCT_UNITS | NUMBER | Forecast Product Units | ||
FORECAST_PRODUCT_REVENUE | NUMBER | Forecast Product Revenue | ||
FORECAST_PRODUCT_COSTS | NUMBER | Forecast Product Costs | ||
FORECAST_PRODUCT_ROI | NUMBER | Forecast Product Roi | ||
LIST_PRICE | NUMBER | List Price | ||
CONFIDENTIAL_FLAG | VARCHAR2 | (1) | Confidential Flag | |
CUSTOM_SETUP_ID | NUMBER | Custom Setup Id | ||
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) | Cust Indicator | |
ACTUAL_UOM | VARCHAR2 | (3) | Actual Uom | |
FORECAST_UOM | VARCHAR2 | (3) | Forecast 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_TEMP;
OZF.OZF_ACTIVITY_PRODUCTS_TEMP does not reference any database object
OZF.OZF_ACTIVITY_PRODUCTS_TEMP is referenced by following:
|
|
|