eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BIM.BIM_R_LEAD_LO_SUM_MV#

Source

View Text - Preformatted


select GROUP_ID GROUP_ID, CAMPAIGN_NAME CAMPAIGN_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 from "BIM"."BIM_R_LEAD_LO_SUM_MV"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, CAMPAIGN_NAME CAMPAIGN_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
FROM "BIM"."BIM_R_LEAD_LO_SUM_MV"