VIEW: BIM.BIM_R_CAMP_DIM_SUM_MV#

Source

View Text - Preformatted

select CAMPAIGN_AREA2 CAMPAIGN_AREA2, CAMPAIGN_COUNTRY CAMPAIGN_COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, RESOURCE_ID RESOURCE_ID, SCHEDULE_ACTIVITY_TYPE SCHEDULE_ACTIVITY_TYPE, SCHEDULE_ACTIVITY SCHEDULE_ACTIVITY, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, SCHEDULE_COUNT SCHEDULE_COUNT, LEADS_QUALIFIED LEADS_QUALIFIED, LEADS_QUALIFIED_AMT LEADS_QUALIFIED_AMT, LEADS_UNQUALIFIED LEADS_UNQUALIFIED, LEADS_UNQUALIFIED_AMT LEADS_UNQUALIFIED_AMT, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITY_AMT OPPORTUNITY_AMT, ORDERS_ACTIVE ORDERS_ACTIVE, ORDERS_CANCELLED ORDERS_CANCELLED, ORDERS_ACTIVE_AMT ORDERS_ACTIVE_AMT, ORDERS_CANCELLED_AMT ORDERS_CANCELLED_AMT, FORECASTED_COST FORECASTED_COST, ACTUAL_COST ACTUAL_COST, REVENUE REVENUE, TARGETED_CUSTOMERS TARGETED_CUSTOMERS, BUDGET_REQUESTED BUDGET_REQUESTED, BUDGET_APPROVED BUDGET_APPROVED, LEADS_OPEN LEADS_OPEN, LEADS_OPEN_AMT LEADS_OPEN_AMT, LEADS_CLOSED LEADS_CLOSED, LEADS_CLOSED_AMT LEADS_CLOSED_AMT, LEADS_NEW LEADS_NEW, LEADS_NEW_AMT LEADS_NEW_AMT, LEADS_HOT LEADS_HOT, LEADS_CONVERTED LEADS_CONVERTED, POSITIVE_RESPONSES POSITIVE_RESPONSES, ACTUAL_REVENUE ACTUAL_REVENUE, FORECASTED_REVENUE FORECASTED_REVENUE, FORECASTED_RESPONSES FORECASTED_RESPONSES, ORDERS_BOOKED ORDERS_BOOKED, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT, DISPLAY_TYPE DISPLAY_TYPE from "BIM"."BIM_R_CAMP_DIM_SUM_MV"

View Text - HTML Formatted

SELECT CAMPAIGN_AREA2 CAMPAIGN_AREA2
, CAMPAIGN_COUNTRY CAMPAIGN_COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, RESOURCE_ID RESOURCE_ID
, SCHEDULE_ACTIVITY_TYPE SCHEDULE_ACTIVITY_TYPE
, SCHEDULE_ACTIVITY SCHEDULE_ACTIVITY
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, SCHEDULE_COUNT SCHEDULE_COUNT
, LEADS_QUALIFIED LEADS_QUALIFIED
, LEADS_QUALIFIED_AMT LEADS_QUALIFIED_AMT
, LEADS_UNQUALIFIED LEADS_UNQUALIFIED
, LEADS_UNQUALIFIED_AMT LEADS_UNQUALIFIED_AMT
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, ORDERS_ACTIVE ORDERS_ACTIVE
, ORDERS_CANCELLED ORDERS_CANCELLED
, ORDERS_ACTIVE_AMT ORDERS_ACTIVE_AMT
, ORDERS_CANCELLED_AMT ORDERS_CANCELLED_AMT
, FORECASTED_COST FORECASTED_COST
, ACTUAL_COST ACTUAL_COST
, REVENUE REVENUE
, TARGETED_CUSTOMERS TARGETED_CUSTOMERS
, BUDGET_REQUESTED BUDGET_REQUESTED
, BUDGET_APPROVED BUDGET_APPROVED
, LEADS_OPEN LEADS_OPEN
, LEADS_OPEN_AMT LEADS_OPEN_AMT
, LEADS_CLOSED LEADS_CLOSED
, LEADS_CLOSED_AMT LEADS_CLOSED_AMT
, LEADS_NEW LEADS_NEW
, LEADS_NEW_AMT LEADS_NEW_AMT
, LEADS_HOT LEADS_HOT
, LEADS_CONVERTED LEADS_CONVERTED
, POSITIVE_RESPONSES POSITIVE_RESPONSES
, ACTUAL_REVENUE ACTUAL_REVENUE
, FORECASTED_REVENUE FORECASTED_REVENUE
, FORECASTED_RESPONSES FORECASTED_RESPONSES
, ORDERS_BOOKED ORDERS_BOOKED
, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT
, DISPLAY_TYPE DISPLAY_TYPE
FROM "BIM"."BIM_R_CAMP_DIM_SUM_MV"