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.

[Home] [Help]

VIEW: BIM.BIM_I_LEAD_FACTS_STG#

Source

View Text - Preformatted


select LEAD_ID LEAD_ID, LEAD_LINE_ID LEAD_LINE_ID, 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, 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, LEAD_COUNTRY LEAD_COUNTRY, SOURCE_CODE_ID SOURCE_CODE_ID, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, ITEM_ID ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID, 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, CURRENCY_CODE CURRENCY_CODE, FROM_CURRENCY FROM_CURRENCY, CONVERSION_RATE CONVERSION_RATE, 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_STG"

View Text - HTML Formatted

SELECT LEAD_ID LEAD_ID
, LEAD_LINE_ID LEAD_LINE_ID
, 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
, 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
, LEAD_COUNTRY LEAD_COUNTRY
, SOURCE_CODE_ID SOURCE_CODE_ID
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, ITEM_ID ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PRODUCT_CATEGORY_ID PRODUCT_CATEGORY_ID
, 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
, CURRENCY_CODE CURRENCY_CODE
, FROM_CURRENCY FROM_CURRENCY
, CONVERSION_RATE CONVERSION_RATE
, 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_STG"