VIEW: BIM.BIM_R_LEAD_SUM_FACTS#

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, GROUP_ID GROUP_ID, RESOURCE_ID RESOURCE_ID, LEAD_RANK_ID LEAD_RANK_ID, LEAD_SOURCE LEAD_SOURCE, LEAD_STATUS LEAD_STATUS, OPEN_FLAG OPEN_FLAG, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, REGION REGION, COUNTRY COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, YEAR YEAR, QTR QTR, MONTH MONTH, 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, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITIES_OPEN OPPORTUNITIES_OPEN, QUOTES QUOTES, QUOTES_OPEN QUOTES_OPEN, ORDERS ORDERS, 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, SOPPORTUNITIES SOPPORTUNITIES, SOPPORTUNITIES_OPEN SOPPORTUNITIES_OPEN, SQUOTES SQUOTES, SQUOTES_OPEN SQUOTES_OPEN, SORDERS SORDERS, 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_R_LEAD_SUM_FACTS"

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
, GROUP_ID GROUP_ID
, RESOURCE_ID RESOURCE_ID
, LEAD_RANK_ID LEAD_RANK_ID
, LEAD_SOURCE LEAD_SOURCE
, LEAD_STATUS LEAD_STATUS
, OPEN_FLAG OPEN_FLAG
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, REGION REGION
, COUNTRY COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, 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
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITIES_OPEN OPPORTUNITIES_OPEN
, QUOTES QUOTES
, QUOTES_OPEN QUOTES_OPEN
, ORDERS ORDERS
, 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
, SOPPORTUNITIES SOPPORTUNITIES
, SOPPORTUNITIES_OPEN SOPPORTUNITIES_OPEN
, SQUOTES SQUOTES
, SQUOTES_OPEN SQUOTES_OPEN
, SORDERS SORDERS
, 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_R_LEAD_SUM_FACTS"