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

TABLE: OZF.OZF_ACTIVITY_PRODUCTS

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


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

Dependencies

[top of page]

OZF.OZF_ACTIVITY_PRODUCTS does not reference any database object

OZF.OZF_ACTIVITY_PRODUCTS is referenced by following:

SchemaOZF
ViewOZF_ACTIVITY_PRODUCTS#