VIEW: OZF.OZF_NA_CUSTOMERS_TEMP#

Source

View Text - Preformatted

select 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, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID, SITE_USE_ID SITE_USE_ID, SITE_USE_CODE SITE_USE_CODE, QUALIFIER_CONTEXT QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE QUALIFIER_ATTRIBUTE, OWNER_ID OWNER_ID, 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, 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, PROD_INDICATOR PROD_INDICATOR from "OZF"."OZF_NA_CUSTOMERS_TEMP"

View Text - HTML Formatted

SELECT 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
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, SITE_USE_ID SITE_USE_ID
, SITE_USE_CODE SITE_USE_CODE
, QUALIFIER_CONTEXT QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE QUALIFIER_ATTRIBUTE
, OWNER_ID OWNER_ID
, 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
, 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
, PROD_INDICATOR PROD_INDICATOR
FROM "OZF"."OZF_NA_CUSTOMERS_TEMP"