VIEW: BIM.BIM_I_LEAD_FACTS#

Source

View Text - Preformatted

select TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, LEAD_CREATION_DATE LEAD_CREATION_DATE, LEAD_TOUCHED_DATE LEAD_TOUCHED_DATE, LEAD_CONVERTED_DATE LEAD_CONVERTED_DATE, LEAD_DEAD_DATE LEAD_DEAD_DATE, LEAD_CLOSED_DATE LEAD_CLOSED_DATE, METRIC_TYPE METRIC_TYPE, LEAD_ID LEAD_ID, LEAD_LINE_ID LEAD_LINE_ID, 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, LEAD_REGION LEAD_REGION, LEAD_COUNTRY LEAD_COUNTRY, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID, ITEM_ID ITEM_ID, ORGANIZATION_ID ORGANIZATION_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_REGION OBJECT_REGION, OBJECT_COUNTRY OBJECT_COUNTRY, OBJECT_STATUS OBJECT_STATUS, OBJECT_PURPOSE OBJECT_PURPOSE, CHILD_OBJECT_REGION CHILD_OBJECT_REGION, CHILD_OBJECT_COUNTRY CHILD_OBJECT_COUNTRY, CHILD_OBJECT_STATUS CHILD_OBJECT_STATUS, CHILD_OBJECT_PURPOSE CHILD_OBJECT_PURPOSE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, OBJECT_CATEGORY_ID OBJECT_CATEGORY_ID, LEADS LEADS, LEADS_OPEN LEADS_OPEN, LEADS_CLOSED LEADS_CLOSED, LEADS_NEW LEADS_NEW, LEADS_DEAD LEADS_DEAD, LEADS_DECLINED LEADS_DECLINED, LEADS_CHANGED LEADS_CHANGED, LEADS_UNCHANGED LEADS_UNCHANGED, LEADS_ASSIGNED LEADS_ASSIGNED, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITIES_OPEN OPPORTUNITIES_OPEN, OPPORTUNITY_AMT OPPORTUNITY_AMT, QUOTES QUOTES, QUOTES_OPEN QUOTES_OPEN, ORDERS_BOOKED ORDERS_BOOKED, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT, 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, 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, QUALIFIED_FLAG QUALIFIED_FLAG, ACCEPT_FLAG ACCEPT_FLAG, CHANNEL_CODE CHANNEL_CODE, CLOSE_REASON CLOSE_REASON, CUST_CATEGORY CUST_CATEGORY, CUSTOMER_FLAG CUSTOMER_FLAG, CUSTOMER_ID CUSTOMER_ID, SOURCE_PRIMARY_REFERENCE SOURCE_PRIMARY_REFERENCE, SOURCE_SECONDARY_REFERENCE SOURCE_SECONDARY_REFERENCE, LEAD_AMOUNT LEAD_AMOUNT, STATUS_OPEN_FLAG STATUS_OPEN_FLAG, LEAD_RANK_SCORE LEAD_RANK_SCORE, EXPIRATION_DATE EXPIRATION_DATE, LEAD_NAME LEAD_NAME from "BIM"."BIM_I_LEAD_FACTS"

View Text - HTML Formatted

SELECT TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, LEAD_CREATION_DATE LEAD_CREATION_DATE
, LEAD_TOUCHED_DATE LEAD_TOUCHED_DATE
, LEAD_CONVERTED_DATE LEAD_CONVERTED_DATE
, LEAD_DEAD_DATE LEAD_DEAD_DATE
, LEAD_CLOSED_DATE LEAD_CLOSED_DATE
, METRIC_TYPE METRIC_TYPE
, LEAD_ID LEAD_ID
, LEAD_LINE_ID LEAD_LINE_ID
, 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
, LEAD_REGION LEAD_REGION
, LEAD_COUNTRY LEAD_COUNTRY
, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID
, ITEM_ID ITEM_ID
, ORGANIZATION_ID ORGANIZATION_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_REGION OBJECT_REGION
, OBJECT_COUNTRY OBJECT_COUNTRY
, OBJECT_STATUS OBJECT_STATUS
, OBJECT_PURPOSE OBJECT_PURPOSE
, CHILD_OBJECT_REGION CHILD_OBJECT_REGION
, CHILD_OBJECT_COUNTRY CHILD_OBJECT_COUNTRY
, CHILD_OBJECT_STATUS CHILD_OBJECT_STATUS
, CHILD_OBJECT_PURPOSE CHILD_OBJECT_PURPOSE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, OBJECT_CATEGORY_ID OBJECT_CATEGORY_ID
, LEADS LEADS
, LEADS_OPEN LEADS_OPEN
, LEADS_CLOSED LEADS_CLOSED
, LEADS_NEW LEADS_NEW
, LEADS_DEAD LEADS_DEAD
, LEADS_DECLINED LEADS_DECLINED
, LEADS_CHANGED LEADS_CHANGED
, LEADS_UNCHANGED LEADS_UNCHANGED
, LEADS_ASSIGNED LEADS_ASSIGNED
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITIES_OPEN OPPORTUNITIES_OPEN
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, QUOTES QUOTES
, QUOTES_OPEN QUOTES_OPEN
, ORDERS_BOOKED ORDERS_BOOKED
, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT
, 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
, 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
, QUALIFIED_FLAG QUALIFIED_FLAG
, ACCEPT_FLAG ACCEPT_FLAG
, CHANNEL_CODE CHANNEL_CODE
, CLOSE_REASON CLOSE_REASON
, CUST_CATEGORY CUST_CATEGORY
, CUSTOMER_FLAG CUSTOMER_FLAG
, CUSTOMER_ID CUSTOMER_ID
, SOURCE_PRIMARY_REFERENCE SOURCE_PRIMARY_REFERENCE
, SOURCE_SECONDARY_REFERENCE SOURCE_SECONDARY_REFERENCE
, LEAD_AMOUNT LEAD_AMOUNT
, STATUS_OPEN_FLAG STATUS_OPEN_FLAG
, LEAD_RANK_SCORE LEAD_RANK_SCORE
, EXPIRATION_DATE EXPIRATION_DATE
, LEAD_NAME LEAD_NAME
FROM "BIM"."BIM_I_LEAD_FACTS"