VIEW: BIM.EDW_BIM_IH_MEDIA_M#

Source

View Text - Preformatted

select MDIA_INTRCTN_MEDIA_PK_KEY MDIA_INTRCTN_MEDIA_PK_KEY, ALL_ALL_PK_KEY ALL_ALL_PK_KEY, ALL_ALL_PK ALL_ALL_PK, ALL_NAME ALL_NAME, MDIA_INTRCTN_MEDIA_PK MDIA_INTRCTN_MEDIA_PK, MDIA_INTRCTN_MEDIA_DP MDIA_INTRCTN_MEDIA_DP, MDIA_NAME MDIA_NAME, MDIA_INTRCTN_MEDIA_CODE MDIA_INTRCTN_MEDIA_CODE, MDIA_MEDIA_DIRECTION MDIA_MEDIA_DIRECTION, MDIA_INTRCTN_MEDIA_NAME MDIA_INTRCTN_MEDIA_NAME, MDIA_DESCRIPTION MDIA_DESCRIPTION, MDIA_INSTANCE MDIA_INSTANCE, MDIA_USER_ATTRIBUTE1 MDIA_USER_ATTRIBUTE1, MDIA_USER_ATTRIBUTE2 MDIA_USER_ATTRIBUTE2, MDIA_USER_ATTRIBUTE3 MDIA_USER_ATTRIBUTE3, MDIA_USER_ATTRIBUTE4 MDIA_USER_ATTRIBUTE4, MDIA_USER_ATTRIBUTE5 MDIA_USER_ATTRIBUTE5, MDIA_LAST_UPDATE_DATE MDIA_LAST_UPDATE_DATE, MDIA_CREATION_DATE MDIA_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_IH_MEDIA_M"

View Text - HTML Formatted

SELECT MDIA_INTRCTN_MEDIA_PK_KEY MDIA_INTRCTN_MEDIA_PK_KEY
, ALL_ALL_PK_KEY ALL_ALL_PK_KEY
, ALL_ALL_PK ALL_ALL_PK
, ALL_NAME ALL_NAME
, MDIA_INTRCTN_MEDIA_PK MDIA_INTRCTN_MEDIA_PK
, MDIA_INTRCTN_MEDIA_DP MDIA_INTRCTN_MEDIA_DP
, MDIA_NAME MDIA_NAME
, MDIA_INTRCTN_MEDIA_CODE MDIA_INTRCTN_MEDIA_CODE
, MDIA_MEDIA_DIRECTION MDIA_MEDIA_DIRECTION
, MDIA_INTRCTN_MEDIA_NAME MDIA_INTRCTN_MEDIA_NAME
, MDIA_DESCRIPTION MDIA_DESCRIPTION
, MDIA_INSTANCE MDIA_INSTANCE
, MDIA_USER_ATTRIBUTE1 MDIA_USER_ATTRIBUTE1
, MDIA_USER_ATTRIBUTE2 MDIA_USER_ATTRIBUTE2
, MDIA_USER_ATTRIBUTE3 MDIA_USER_ATTRIBUTE3
, MDIA_USER_ATTRIBUTE4 MDIA_USER_ATTRIBUTE4
, MDIA_USER_ATTRIBUTE5 MDIA_USER_ATTRIBUTE5
, MDIA_LAST_UPDATE_DATE MDIA_LAST_UPDATE_DATE
, MDIA_CREATION_DATE MDIA_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_IH_MEDIA_M"