VIEW: BIM.EDW_BIM_IH_OUTCM_M#

Source

View Text - Preformatted

select OTCM_INTRCTN_OUTCOME_PK_KEY OTCM_INTRCTN_OUTCOME_PK_KEY, ALL_ALL_PK_KEY ALL_ALL_PK_KEY, ALL_ALL_PK ALL_ALL_PK, ALL_NAME ALL_NAME, OTCM_INTRCTN_OUTCOME_PK OTCM_INTRCTN_OUTCOME_PK, OTCM_OUTCOME_DP OTCM_OUTCOME_DP, OTCM_NAME OTCM_NAME, OTCM_OUTCOME_CODE OTCM_OUTCOME_CODE, OTCM_POSITIVE_OUTCOME_FLAG OTCM_POSITIVE_OUTCOME_FLAG, OTCM_SHORT_DESCRIPTION OTCM_SHORT_DESCRIPTION, OTCM_LONG_DESCRIPTION OTCM_LONG_DESCRIPTION, OTCM_INSTANCE OTCM_INSTANCE, OTCM_USER_ATTRIBUTE1 OTCM_USER_ATTRIBUTE1, OTCM_USER_ATTRIBUTE2 OTCM_USER_ATTRIBUTE2, OTCM_USER_ATTRIBUTE3 OTCM_USER_ATTRIBUTE3, OTCM_USER_ATTRIBUTE4 OTCM_USER_ATTRIBUTE4, OTCM_USER_ATTRIBUTE5 OTCM_USER_ATTRIBUTE5, OTCM_LAST_UPDATE_DATE OTCM_LAST_UPDATE_DATE, OTCM_CREATION_DATE OTCM_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_IH_OUTCM_M"

View Text - HTML Formatted

SELECT OTCM_INTRCTN_OUTCOME_PK_KEY OTCM_INTRCTN_OUTCOME_PK_KEY
, ALL_ALL_PK_KEY ALL_ALL_PK_KEY
, ALL_ALL_PK ALL_ALL_PK
, ALL_NAME ALL_NAME
, OTCM_INTRCTN_OUTCOME_PK OTCM_INTRCTN_OUTCOME_PK
, OTCM_OUTCOME_DP OTCM_OUTCOME_DP
, OTCM_NAME OTCM_NAME
, OTCM_OUTCOME_CODE OTCM_OUTCOME_CODE
, OTCM_POSITIVE_OUTCOME_FLAG OTCM_POSITIVE_OUTCOME_FLAG
, OTCM_SHORT_DESCRIPTION OTCM_SHORT_DESCRIPTION
, OTCM_LONG_DESCRIPTION OTCM_LONG_DESCRIPTION
, OTCM_INSTANCE OTCM_INSTANCE
, OTCM_USER_ATTRIBUTE1 OTCM_USER_ATTRIBUTE1
, OTCM_USER_ATTRIBUTE2 OTCM_USER_ATTRIBUTE2
, OTCM_USER_ATTRIBUTE3 OTCM_USER_ATTRIBUTE3
, OTCM_USER_ATTRIBUTE4 OTCM_USER_ATTRIBUTE4
, OTCM_USER_ATTRIBUTE5 OTCM_USER_ATTRIBUTE5
, OTCM_LAST_UPDATE_DATE OTCM_LAST_UPDATE_DATE
, OTCM_CREATION_DATE OTCM_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_IH_OUTCM_M"