VIEW: BIM.BIM_R_LEAD_GEN_SUM_MV#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, GROUP_NAME GROUP_NAME, REGION REGION, COUNTRY COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, DISPLAY_TYPE DISPLAY_TYPE, LEADS_TOTAL LEADS_TOTAL, LEADS_OPEN LEADS_OPEN, LEADS_CLOSED LEADS_CLOSED, LEADS_NEW LEADS_NEW, LEADS_DEAD LEADS_DEAD, LEADS_CHANGED LEADS_CHANGED, LEADS_UNCHANGED LEADS_UNCHANGED, LEADS_ASSIGNED LEADS_ASSIGNED, OPPS_TOTAL OPPS_TOTAL, OPPS_OPEN OPPS_OPEN, QUOTES_TOTAL QUOTES_TOTAL, QUOTES_OPEN QUOTES_OPEN, ORDERS ORDERS, SLEADS_TOTAL SLEADS_TOTAL, SLEADS_OPEN SLEADS_OPEN, SLEADS_CLOSED SLEADS_CLOSED, SLEADS_NEW SLEADS_NEW, SLEADS_DEAD SLEADS_DEAD, SLEADS_CHANGED SLEADS_CHANGED, SLEADS_UNCHANGED SLEADS_UNCHANGED, SLEADS_ASSIGNED SLEADS_ASSIGNED, SOPPS_TOTAL SOPPS_TOTAL, SOPPS_OPEN SOPPS_OPEN, SQUOTES_TOTAL SQUOTES_TOTAL, SQUOTES_OPEN SQUOTES_OPEN, SORDERS SORDERS from "BIM"."BIM_R_LEAD_GEN_SUM_MV"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, GROUP_NAME GROUP_NAME
, REGION REGION
, COUNTRY COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, DISPLAY_TYPE DISPLAY_TYPE
, LEADS_TOTAL LEADS_TOTAL
, LEADS_OPEN LEADS_OPEN
, LEADS_CLOSED LEADS_CLOSED
, LEADS_NEW LEADS_NEW
, LEADS_DEAD LEADS_DEAD
, LEADS_CHANGED LEADS_CHANGED
, LEADS_UNCHANGED LEADS_UNCHANGED
, LEADS_ASSIGNED LEADS_ASSIGNED
, OPPS_TOTAL OPPS_TOTAL
, OPPS_OPEN OPPS_OPEN
, QUOTES_TOTAL QUOTES_TOTAL
, QUOTES_OPEN QUOTES_OPEN
, ORDERS ORDERS
, SLEADS_TOTAL SLEADS_TOTAL
, SLEADS_OPEN SLEADS_OPEN
, SLEADS_CLOSED SLEADS_CLOSED
, SLEADS_NEW SLEADS_NEW
, SLEADS_DEAD SLEADS_DEAD
, SLEADS_CHANGED SLEADS_CHANGED
, SLEADS_UNCHANGED SLEADS_UNCHANGED
, SLEADS_ASSIGNED SLEADS_ASSIGNED
, SOPPS_TOTAL SOPPS_TOTAL
, SOPPS_OPEN SOPPS_OPEN
, SQUOTES_TOTAL SQUOTES_TOTAL
, SQUOTES_OPEN SQUOTES_OPEN
, SORDERS SORDERS
FROM "BIM"."BIM_R_LEAD_GEN_SUM_MV"