[Home] [Help] [Dependency Information]
Object Name: | OZF_ACTIVITY_PRODUCTS_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_PRODUCT_ID | NUMBER | |||
OBJECT_ID | NUMBER | |||
OBJECT_CLASS | VARCHAR2 | (30) | ||
OBJECT_TYPE | VARCHAR2 | (30) | ||
OBJECT_DESC | VARCHAR2 | (2000) | ||
OBJECT_STATUS | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
PARENT_ID | NUMBER | |||
PARENT_DESC | VARCHAR2 | (250) | ||
PARENT_CLASS | VARCHAR2 | (30) | ||
PARENT_TYPE | VARCHAR2 | (30) | ||
PARENT_STATUS | VARCHAR2 | (30) | ||
OWNER_ID | NUMBER | |||
ITEM | NUMBER | |||
ITEM_TYPE | VARCHAR2 | (30) | ||
ITEMS_CATEGORY | NUMBER | |||
SOURCE_CODE | VARCHAR2 | (30) | ||
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | ||
ACTIVITY_ID | NUMBER | |||
MARKETING_MEDIUM_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (10) | ||
OFFER_CODE | VARCHAR2 | (30) | ||
ASK_FOR_FLAG | VARCHAR2 | (1) | ||
ACTIVE_FLAG | VARCHAR2 | (1) | ||
ACTUAL_UNITS | NUMBER | |||
ACTUAL_REVENUE | NUMBER | |||
ACTUAL_COSTS | NUMBER | |||
ACTUAL_ROI | NUMBER | |||
FORECAST_UNITS | NUMBER | |||
FORECAST_REVENUE | NUMBER | |||
FORECAST_COSTS | NUMBER | |||
FORECAST_ROI | NUMBER | |||
ACTUAL_PRODUCT_UNITS | NUMBER | |||
ACTUAL_PRODUCT_REVENUE | NUMBER | |||
ACTUAL_PRODUCT_COSTS | NUMBER | |||
ACTUAL_PRODUCT_ROI | NUMBER | |||
FORECAST_PRODUCT_UNITS | NUMBER | |||
FORECAST_PRODUCT_REVENUE | NUMBER | |||
FORECAST_PRODUCT_COSTS | NUMBER | |||
FORECAST_PRODUCT_ROI | NUMBER | |||
LIST_PRICE | NUMBER | |||
CONFIDENTIAL_FLAG | VARCHAR2 | (1) | ||
CUSTOM_SETUP_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CUST_INDICATOR | VARCHAR2 | (20) | ||
ACTUAL_UOM | VARCHAR2 | (3) | ||
FORECAST_UOM | VARCHAR2 | (3) | ||
DISCOUNT | NUMBER |
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#;
|
|
|