View: EDW_BIM_OPPR_OPPLINES_LCV

View Text

SELECT OPL.LEAD_LINE_ID || '-' || INST.INSTANCE_CODE OPPLINE_PK
, OPH.LEAD_ID || '-' || INST.INSTANCE_CODE OPPORTUNITY_FK
, OPL.LEAD_LINE_ID || '-' || INST.INSTANCE_CODE OPPLINE_DP
, OPL.LEAD_LINE_ID || '-' || INST.INSTANCE_CODE NAME
, OPL.LEAD_LINE_ID OPP_LEAD_LINE_ID
, OPH.LEAD_ID LEAD_ID
, INST.INSTANCE_CODE INSTANCE
, GREATEST(OPL.LAST_UPDATE_DATE
, OPH.LAST_UPDATE_DATE ) LAST_UPDATE_DATE
, OPL.CREATION_DATE CREATION_DATE
FROM AS_LEAD_LINES_ALL OPL
, AS_LEADS_ALL OPH
, EDW_LOCAL_INSTANCE INST
WHERE OPH.LEAD_ID = OPL.LEAD_ID
AND ( (OPH.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD')) OR (OPL.LAST_UPDATE_DATE > TO_DATE('1000/01/01'
, 'YYYY/MM/DD')) )
AND ( OPH.DELETED_FLAG IS NULL OR OPH.DELETED_FLAG <> 'Y' ) WITH READ ONLY

Columns