DBA Data[Home] [Help] [Dependency Information]

TABLE: OZF.OZF_ACTIVITY_PRODUCTS_TEMP

Object Details
Object Name: OZF_ACTIVITY_PRODUCTS_TEMP
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_ACTIVITY_PRODUCTS_TEMP
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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_ACTIVITY_PRODUCTS_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_CLASS
OZF_ACTIVITY_PRODUCTS_T_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_CLASS
ColumnITEM
ColumnITEM_TYPE
Columns
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
Query Text

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;

Dependencies

[top of page]

OZF.OZF_ACTIVITY_PRODUCTS_TEMP does not reference any database object

OZF.OZF_ACTIVITY_PRODUCTS_TEMP is referenced by following:

SchemaAPPS
SynonymOZF_ACTIVITY_PRODUCTS_TEMP