View: EDW_BIM_LEAD_LEADLINES_LCV

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