[Home] [Help]
View: EDW_BIM_LEAD_LEADLINES_LCV
Product: | BIM - Marketing Intelligence |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ASLL.SALES_LEAD_LINE_ID || '-' || INST.INSTANCE_CODE LEADLINE_PK
, ASL.SALES_LEAD_ID || '-' || INST.INSTANCE_CODE LEAD_FK
, ASLL.SALES_LEAD_LINE_ID || '-' || INST.INSTANCE_CODE LEADLINE_DP
, ASLL.SALES_LEAD_LINE_ID || '-' || INST.INSTANCE_CODE NAME
, ASLL.SALES_LEAD_LINE_ID SALES_LEAD_LINE_ID
, INST.INSTANCE_CODE INSTANCE
, GREATEST(ASLL.LAST_UPDATE_DATE
, ASL.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, ASLL.CREATION_DATE CREATION_DATE
FROM AS_SALES_LEAD_LINES ASLL
, AS_SALES_LEADS ASL
, EDW_LOCAL_INSTANCE INST
WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_ID
AND ( (ASL.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD') ) OR (ASLL.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD') ) )
AND ( ASL.DELETED_FLAG IS NULL OR ASL.DELETED_FLAG <> 'Y' ) WITH READ ONLY
Columns
Name |
LEADLINE_PK |
LEAD_FK |
LEADLINE_DP |
NAME |
SALES_LEAD_LINE_ID |
INSTANCE |
LAST_UPDATE_DATE |
CREATION_DATE |