VIEW: BIM.BIM_I_MARKETING_FACTS_STG#

Source

View Text - Preformatted

select CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, METRIC_TYPE METRIC_TYPE, LEAD_ID LEAD_ID, SOURCE_CODE_ID SOURCE_CODE_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, CHILD_OBJECT_TYPE CHILD_OBJECT_TYPE, CHILD_OBJECT_ID CHILD_OBJECT_ID, OBJECT_COUNTRY OBJECT_COUNTRY, LEAD_RANK_ID LEAD_RANK_ID, OBJECT_REGION OBJECT_REGION, CHILD_OBJECT_COUNTRY CHILD_OBJECT_COUNTRY, CHILD_OBJECT_REGION CHILD_OBJECT_REGION, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, START_DATE START_DATE, END_DATE END_DATE, OBJECT_STATUS OBJECT_STATUS, CHILD_OBJECT_STATUS CHILD_OBJECT_STATUS, OBJECT_PURPOSE OBJECT_PURPOSE, CHILD_OBJECT_PURPOSE CHILD_OBJECT_PURPOSE, ACTIVITY_ID ACTIVITY_ID, CATEGORY_ID CATEGORY_ID, FROM_CURRENCY FROM_CURRENCY, CONVERSION_RATE CONVERSION_RATE, CONVERSION_RATE_S CONVERSION_RATE_S, LEADS LEADS, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITY_AMT OPPORTUNITY_AMT, OPPORTUNITY_AMT_S OPPORTUNITY_AMT_S, OPPORTUNITIES_OPEN OPPORTUNITIES_OPEN, ACTIVITY_TYPE ACTIVITY_TYPE, ORDERS_BOOKED ORDERS_BOOKED, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT, ORDERS_BOOKED_AMT_S ORDERS_BOOKED_AMT_S, REVENUE_FORECASTED REVENUE_FORECASTED, REVENUE_FORECASTED_S REVENUE_FORECASTED_S, REVENUE_ACTUAL REVENUE_ACTUAL, REVENUE_ACTUAL_S REVENUE_ACTUAL_S, COST_ACTUAL COST_ACTUAL, COST_ACTUAL_S COST_ACTUAL_S, BUDGET_APPROVED BUDGET_APPROVED, BUDGET_APPROVED_S BUDGET_APPROVED_S, BUDGET_REQUESTED BUDGET_REQUESTED, BUDGET_REQUESTED_S BUDGET_REQUESTED_S, RESPONSES_FORECASTED RESPONSES_FORECASTED, RESPONSES_POSITIVE RESPONSES_POSITIVE, CUSTOMERS_NEW CUSTOMERS_NEW, CUSTOMERS_TARGETED CUSTOMERS_TARGETED, COST_FORECASTED COST_FORECASTED, COST_FORECASTED_S COST_FORECASTED_S, REGISTRATIONS REGISTRATIONS, CANCELLATIONS CANCELLATIONS, ATTENDANCE ATTENDANCE, METRIC1 METRIC1, METRIC2 METRIC2, METRIC3 METRIC3, METRIC4 METRIC4, METRIC5 METRIC5, METRIC6 METRIC6, METRIC7 METRIC7, METRIC8 METRIC8, METRIC9 METRIC9, METRIC10 METRIC10, METRIC11 METRIC11, METRIC12 METRIC12, METRIC13 METRIC13, METRIC14 METRIC14, METRIC15 METRIC15, SECURITY_GROUP_ID SECURITY_GROUP_ID from "BIM"."BIM_I_MARKETING_FACTS_STG"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, METRIC_TYPE METRIC_TYPE
, LEAD_ID LEAD_ID
, SOURCE_CODE_ID SOURCE_CODE_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, CHILD_OBJECT_TYPE CHILD_OBJECT_TYPE
, CHILD_OBJECT_ID CHILD_OBJECT_ID
, OBJECT_COUNTRY OBJECT_COUNTRY
, LEAD_RANK_ID LEAD_RANK_ID
, OBJECT_REGION OBJECT_REGION
, CHILD_OBJECT_COUNTRY CHILD_OBJECT_COUNTRY
, CHILD_OBJECT_REGION CHILD_OBJECT_REGION
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, START_DATE START_DATE
, END_DATE END_DATE
, OBJECT_STATUS OBJECT_STATUS
, CHILD_OBJECT_STATUS CHILD_OBJECT_STATUS
, OBJECT_PURPOSE OBJECT_PURPOSE
, CHILD_OBJECT_PURPOSE CHILD_OBJECT_PURPOSE
, ACTIVITY_ID ACTIVITY_ID
, CATEGORY_ID CATEGORY_ID
, FROM_CURRENCY FROM_CURRENCY
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_RATE_S CONVERSION_RATE_S
, LEADS LEADS
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, OPPORTUNITY_AMT_S OPPORTUNITY_AMT_S
, OPPORTUNITIES_OPEN OPPORTUNITIES_OPEN
, ACTIVITY_TYPE ACTIVITY_TYPE
, ORDERS_BOOKED ORDERS_BOOKED
, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT
, ORDERS_BOOKED_AMT_S ORDERS_BOOKED_AMT_S
, REVENUE_FORECASTED REVENUE_FORECASTED
, REVENUE_FORECASTED_S REVENUE_FORECASTED_S
, REVENUE_ACTUAL REVENUE_ACTUAL
, REVENUE_ACTUAL_S REVENUE_ACTUAL_S
, COST_ACTUAL COST_ACTUAL
, COST_ACTUAL_S COST_ACTUAL_S
, BUDGET_APPROVED BUDGET_APPROVED
, BUDGET_APPROVED_S BUDGET_APPROVED_S
, BUDGET_REQUESTED BUDGET_REQUESTED
, BUDGET_REQUESTED_S BUDGET_REQUESTED_S
, RESPONSES_FORECASTED RESPONSES_FORECASTED
, RESPONSES_POSITIVE RESPONSES_POSITIVE
, CUSTOMERS_NEW CUSTOMERS_NEW
, CUSTOMERS_TARGETED CUSTOMERS_TARGETED
, COST_FORECASTED COST_FORECASTED
, COST_FORECASTED_S COST_FORECASTED_S
, REGISTRATIONS REGISTRATIONS
, CANCELLATIONS CANCELLATIONS
, ATTENDANCE ATTENDANCE
, METRIC1 METRIC1
, METRIC2 METRIC2
, METRIC3 METRIC3
, METRIC4 METRIC4
, METRIC5 METRIC5
, METRIC6 METRIC6
, METRIC7 METRIC7
, METRIC8 METRIC8
, METRIC9 METRIC9
, METRIC10 METRIC10
, METRIC11 METRIC11
, METRIC12 METRIC12
, METRIC13 METRIC13
, METRIC14 METRIC14
, METRIC15 METRIC15
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "BIM"."BIM_I_MARKETING_FACTS_STG"