VIEW: BIM.EDW_BIM_OPP_STATUS_M#

Source

View Text - Preformatted

select L1_OPPSTATUS_PK_KEY L1_OPPSTATUS_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_OPPSTATUS_PK L1_OPPSTATUS_PK, L1_OPPSTATUS_DP L1_OPPSTATUS_DP, L1_NAME L1_NAME, L1_STATUS_CODE L1_STATUS_CODE, L1_MEANING L1_MEANING, L1_DESCRIPTION L1_DESCRIPTION, L1_INSTANCE L1_INSTANCE, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE, L1_CREATION_DATE L1_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, L1_OPEN_STATUS_FLAG L1_OPEN_STATUS_FLAG, L1_FORECAST_ROLLUP_FLAG L1_FORECAST_ROLLUP_FLAG, L1_WIN_LOSS_INDICATOR L1_WIN_LOSS_INDICATOR from "BIM"."EDW_BIM_OPP_STATUS_M"

View Text - HTML Formatted

SELECT L1_OPPSTATUS_PK_KEY L1_OPPSTATUS_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_OPPSTATUS_PK L1_OPPSTATUS_PK
, L1_OPPSTATUS_DP L1_OPPSTATUS_DP
, L1_NAME L1_NAME
, L1_STATUS_CODE L1_STATUS_CODE
, L1_MEANING L1_MEANING
, L1_DESCRIPTION L1_DESCRIPTION
, L1_INSTANCE L1_INSTANCE
, L1_USER_ATTRIBUTE1 L1_USER_ATTRIBUTE1
, L1_USER_ATTRIBUTE2 L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE3 L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE4 L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE5 L1_USER_ATTRIBUTE5
, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE
, L1_CREATION_DATE L1_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, L1_OPEN_STATUS_FLAG L1_OPEN_STATUS_FLAG
, L1_FORECAST_ROLLUP_FLAG L1_FORECAST_ROLLUP_FLAG
, L1_WIN_LOSS_INDICATOR L1_WIN_LOSS_INDICATOR
FROM "BIM"."EDW_BIM_OPP_STATUS_M"