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: EDW_BIM_LEAD_LEADS_LCV

Product:	BIM - Marketing Intelligence
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ASL.SALES_LEAD_ID || '-' || INST.INSTANCE_CODE LEAD_PK
, 'ALL' ALL_FK
, ASL.DESCRIPTION LEAD_DP
, ASL.DESCRIPTION NAME
, ASL.SALES_LEAD_ID SALES_LEAD_ID
, ASL.LEAD_NUMBER LEAD_NUMBER
, ASL.DESCRIPTION LEAD_DESCRIPTION
, ASL.PARENT_PROJECT PARENT_PROJECT
, ASL.BUDGET_AMOUNT BUDGET_AMOUNT
, ASL.CURRENCY_CODE CURRENCY_CODE
, ASL.TOTAL_SCORE TOTAL_SCORE
, ASL.VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, ASL.DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE
, ASL.BUDGET_STATUS_CODE BUDGET_STATUS_CODE
, ASL.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, ASL.DELETED_FLAG DELETED_FLAG
, INST.INSTANCE_CODE INSTANCE
, ASL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ASL.CREATION_DATE CREATION_DATE
FROM AS_SALES_LEADS ASL
, EDW_LOCAL_INSTANCE INST
WHERE DELETED_FLAG IS NULL OR DELETED_FLAG <> 'Y' WITH READ ONLY

Columns

Name
LEAD_PK
ALL_FK
LEAD_DP
NAME
SALES_LEAD_ID
LEAD_NUMBER
LEAD_DESCRIPTION
PARENT_PROJECT
BUDGET_AMOUNT
CURRENCY_CODE
TOTAL_SCORE
VEHICLE_RESPONSE_CODE
DECISION_TIMEFRAME_CODE
BUDGET_STATUS_CODE
ORIG_SYSTEM_REFERENCE
DELETED_FLAG
INSTANCE
LAST_UPDATE_DATE
CREATION_DATE