VIEW: OZF.OZF_ACTIVITY_PRODUCTS_TEMP#

Source

View Text - Preformatted

select ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID, OBJECT_ID OBJECT_ID, OBJECT_CLASS OBJECT_CLASS, OBJECT_TYPE OBJECT_TYPE, OBJECT_DESC OBJECT_DESC, OBJECT_STATUS OBJECT_STATUS, START_DATE START_DATE, END_DATE END_DATE, PARENT_ID PARENT_ID, PARENT_DESC PARENT_DESC, PARENT_CLASS PARENT_CLASS, PARENT_TYPE PARENT_TYPE, PARENT_STATUS PARENT_STATUS, OWNER_ID OWNER_ID, ITEM ITEM, ITEM_TYPE ITEM_TYPE, ITEMS_CATEGORY ITEMS_CATEGORY, SOURCE_CODE SOURCE_CODE, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, ACTIVITY_ID ACTIVITY_ID, MARKETING_MEDIUM_ID MARKETING_MEDIUM_ID, CURRENCY_CODE CURRENCY_CODE, OFFER_CODE OFFER_CODE, ASK_FOR_FLAG ASK_FOR_FLAG, ACTIVE_FLAG ACTIVE_FLAG, ACTUAL_UNITS ACTUAL_UNITS, ACTUAL_REVENUE ACTUAL_REVENUE, ACTUAL_COSTS ACTUAL_COSTS, ACTUAL_ROI ACTUAL_ROI, FORECAST_UNITS FORECAST_UNITS, FORECAST_REVENUE FORECAST_REVENUE, FORECAST_COSTS FORECAST_COSTS, FORECAST_ROI FORECAST_ROI, ACTUAL_PRODUCT_UNITS ACTUAL_PRODUCT_UNITS, ACTUAL_PRODUCT_REVENUE ACTUAL_PRODUCT_REVENUE, ACTUAL_PRODUCT_COSTS ACTUAL_PRODUCT_COSTS, ACTUAL_PRODUCT_ROI ACTUAL_PRODUCT_ROI, FORECAST_PRODUCT_UNITS FORECAST_PRODUCT_UNITS, FORECAST_PRODUCT_REVENUE FORECAST_PRODUCT_REVENUE, FORECAST_PRODUCT_COSTS FORECAST_PRODUCT_COSTS, FORECAST_PRODUCT_ROI FORECAST_PRODUCT_ROI, LIST_PRICE LIST_PRICE, CONFIDENTIAL_FLAG CONFIDENTIAL_FLAG, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUST_INDICATOR CUST_INDICATOR, ACTUAL_UOM ACTUAL_UOM, FORECAST_UOM FORECAST_UOM, DISCOUNT DISCOUNT from "OZF"."OZF_ACTIVITY_PRODUCTS_TEMP"

View Text - HTML Formatted

SELECT ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID
, OBJECT_ID OBJECT_ID
, OBJECT_CLASS OBJECT_CLASS
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_DESC OBJECT_DESC
, OBJECT_STATUS OBJECT_STATUS
, START_DATE START_DATE
, END_DATE END_DATE
, PARENT_ID PARENT_ID
, PARENT_DESC PARENT_DESC
, PARENT_CLASS PARENT_CLASS
, PARENT_TYPE PARENT_TYPE
, PARENT_STATUS PARENT_STATUS
, OWNER_ID OWNER_ID
, ITEM ITEM
, ITEM_TYPE ITEM_TYPE
, ITEMS_CATEGORY ITEMS_CATEGORY
, SOURCE_CODE SOURCE_CODE
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, ACTIVITY_ID ACTIVITY_ID
, MARKETING_MEDIUM_ID MARKETING_MEDIUM_ID
, CURRENCY_CODE CURRENCY_CODE
, OFFER_CODE OFFER_CODE
, ASK_FOR_FLAG ASK_FOR_FLAG
, ACTIVE_FLAG ACTIVE_FLAG
, ACTUAL_UNITS ACTUAL_UNITS
, ACTUAL_REVENUE ACTUAL_REVENUE
, ACTUAL_COSTS ACTUAL_COSTS
, ACTUAL_ROI ACTUAL_ROI
, FORECAST_UNITS FORECAST_UNITS
, FORECAST_REVENUE FORECAST_REVENUE
, FORECAST_COSTS FORECAST_COSTS
, FORECAST_ROI FORECAST_ROI
, ACTUAL_PRODUCT_UNITS ACTUAL_PRODUCT_UNITS
, ACTUAL_PRODUCT_REVENUE ACTUAL_PRODUCT_REVENUE
, ACTUAL_PRODUCT_COSTS ACTUAL_PRODUCT_COSTS
, ACTUAL_PRODUCT_ROI ACTUAL_PRODUCT_ROI
, FORECAST_PRODUCT_UNITS FORECAST_PRODUCT_UNITS
, FORECAST_PRODUCT_REVENUE FORECAST_PRODUCT_REVENUE
, FORECAST_PRODUCT_COSTS FORECAST_PRODUCT_COSTS
, FORECAST_PRODUCT_ROI FORECAST_PRODUCT_ROI
, LIST_PRICE LIST_PRICE
, CONFIDENTIAL_FLAG CONFIDENTIAL_FLAG
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUST_INDICATOR CUST_INDICATOR
, ACTUAL_UOM ACTUAL_UOM
, FORECAST_UOM FORECAST_UOM
, DISCOUNT DISCOUNT
FROM "OZF"."OZF_ACTIVITY_PRODUCTS_TEMP"