VIEW: BIM.EDW_BIM_MDCH_CHANNELS_LTC#

Source

View Text - Preformatted

select CHANNEL_PK CHANNEL_PK, CHANNEL_PK_KEY CHANNEL_PK_KEY, ALL_FK ALL_FK, ALL_FK_KEY ALL_FK_KEY, CHANNEL_DP CHANNEL_DP, NAME NAME, CHANNEL_ID CHANNEL_ID, CHANNEL_TYPE_CODE CHANNEL_TYPE_CODE, CHANNEL_TYPE CHANNEL_TYPE, INBOUND_FLAG INBOUND_FLAG, OUTBOUND_FLAG OUTBOUND_FLAG, RATING RATING, PREFERRED_VENDOR_ID PREFERRED_VENDOR_ID, PARTY_ID PARTY_ID, MANAGED_BY_PERSON_ID MANAGED_BY_PERSON_ID, ACTIVE_FROM_DATE ACTIVE_FROM_DATE, ACTIVE_TO_DATE ACTIVE_TO_DATE, CHANNEL_NAME CHANNEL_NAME, DESCRIPTION DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_MDCH_CHANNELS_LTC"

View Text - HTML Formatted

SELECT CHANNEL_PK CHANNEL_PK
, CHANNEL_PK_KEY CHANNEL_PK_KEY
, ALL_FK ALL_FK
, ALL_FK_KEY ALL_FK_KEY
, CHANNEL_DP CHANNEL_DP
, NAME NAME
, CHANNEL_ID CHANNEL_ID
, CHANNEL_TYPE_CODE CHANNEL_TYPE_CODE
, CHANNEL_TYPE CHANNEL_TYPE
, INBOUND_FLAG INBOUND_FLAG
, OUTBOUND_FLAG OUTBOUND_FLAG
, RATING RATING
, PREFERRED_VENDOR_ID PREFERRED_VENDOR_ID
, PARTY_ID PARTY_ID
, MANAGED_BY_PERSON_ID MANAGED_BY_PERSON_ID
, ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, ACTIVE_TO_DATE ACTIVE_TO_DATE
, CHANNEL_NAME CHANNEL_NAME
, DESCRIPTION DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_MDCH_CHANNELS_LTC"