[Home] [Help]
View: EDW_BIM_LEAD_LEADLINES_LCV
| Product: | BIM - Marketing Intelligence(Obsolete) |
|---|
| 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 |