View: EDW_BIM_OSTA_OPPSTATUS_LCV

View Text

SELECT AST.STATUS_CODE || '-' || INST.INSTANCE_CODE OPPSTATUS_PK
, 'ALL' ALL_FK
, AST.MEANING OPPSTATUS_DP
, AST.MEANING NAME
, AST.STATUS_CODE STATUS_CODE
, AST.MEANING MEANING
, AST.DESCRIPTION DESCRIPTION
, AST.OPP_OPEN_STATUS_FLAG OPEN_STATUS_FLAG
, AST.FORECAST_ROLLUP_FLAG FORECAST_ROLLUP_FLAG
, NULL WIN_LOSS_INDICATOR
, INST.INSTANCE_CODE INSTANCE
, AST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AST.CREATION_DATE CREATION_DATE
FROM AS_STATUSES_VL AST
, EDW_LOCAL_INSTANCE INST
WHERE AST.OPP_FLAG = 'Y'
AND AST.ENABLED_FLAG = 'Y' WITH READ ONLY

Columns