VIEW: BIM.EDW_BIM_IH_REASN_M#

Source

View Text - Preformatted

select RESN_INTRCTN_REASON_PK_KEY RESN_INTRCTN_REASON_PK_KEY, ALL_ALL_PK_KEY ALL_ALL_PK_KEY, ALL_ALL_PK ALL_ALL_PK, ALL_NAME ALL_NAME, RESN_INTRCTN_REASON_PK RESN_INTRCTN_REASON_PK, RESN_REASON_DP RESN_REASON_DP, RESN_NAME RESN_NAME, RESN_REASON_CODE RESN_REASON_CODE, RESN_SHORT_DESCRIPTION RESN_SHORT_DESCRIPTION, RESN_LONG_DESCRIPTION RESN_LONG_DESCRIPTION, RESN_INSTANCE RESN_INSTANCE, RESN_USER_ATTRIBUTE1 RESN_USER_ATTRIBUTE1, RESN_USER_ATTRIBUTE2 RESN_USER_ATTRIBUTE2, RESN_USER_ATTRIBUTE3 RESN_USER_ATTRIBUTE3, RESN_USER_ATTRIBUTE4 RESN_USER_ATTRIBUTE4, RESN_USER_ATTRIBUTE5 RESN_USER_ATTRIBUTE5, RESN_LAST_UPDATE_DATE RESN_LAST_UPDATE_DATE, RESN_CREATION_DATE RESN_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_IH_REASN_M"

View Text - HTML Formatted

SELECT RESN_INTRCTN_REASON_PK_KEY RESN_INTRCTN_REASON_PK_KEY
, ALL_ALL_PK_KEY ALL_ALL_PK_KEY
, ALL_ALL_PK ALL_ALL_PK
, ALL_NAME ALL_NAME
, RESN_INTRCTN_REASON_PK RESN_INTRCTN_REASON_PK
, RESN_REASON_DP RESN_REASON_DP
, RESN_NAME RESN_NAME
, RESN_REASON_CODE RESN_REASON_CODE
, RESN_SHORT_DESCRIPTION RESN_SHORT_DESCRIPTION
, RESN_LONG_DESCRIPTION RESN_LONG_DESCRIPTION
, RESN_INSTANCE RESN_INSTANCE
, RESN_USER_ATTRIBUTE1 RESN_USER_ATTRIBUTE1
, RESN_USER_ATTRIBUTE2 RESN_USER_ATTRIBUTE2
, RESN_USER_ATTRIBUTE3 RESN_USER_ATTRIBUTE3
, RESN_USER_ATTRIBUTE4 RESN_USER_ATTRIBUTE4
, RESN_USER_ATTRIBUTE5 RESN_USER_ATTRIBUTE5
, RESN_LAST_UPDATE_DATE RESN_LAST_UPDATE_DATE
, RESN_CREATION_DATE RESN_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_IH_REASN_M"