Product: | BIM - Marketing Intelligence(Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
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