eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIM.EDW_BIM_MDCHN_M#

Source

View Text - Preformatted


select L4_MDCHNL_PK_KEY L4_MDCHNL_PK_KEY, L3_CHANNEL_PK_KEY L3_CHANNEL_PK_KEY, L2_MEDIA_PK_KEY L2_MEDIA_PK_KEY, L1_MEDIA_TYPE_PK_KEY L1_MEDIA_TYPE_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_MEDIA_TYPE_PK L1_MEDIA_TYPE_PK, L1_MEDIA_TYPE_DP L1_MEDIA_TYPE_DP, L1_NAME L1_NAME, L1_MEDIA_TYPE_CODE L1_MEDIA_TYPE_CODE, L1_ENABLED_FLAG L1_ENABLED_FLAG, L1_START_DATE_ACTIVE L1_START_DATE_ACTIVE, L1_END_DATE_ACTIVE L1_END_DATE_ACTIVE, L1_MEDIA_TYPE_NAME L1_MEDIA_TYPE_NAME, 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, L2_MEDIA_PK L2_MEDIA_PK, L2_MEDIA_DP L2_MEDIA_DP, L2_NAME L2_NAME, L2_MEDIA_ID L2_MEDIA_ID, L2_INBOUND_FLAG L2_INBOUND_FLAG, L2_ENABLED_FLAG L2_ENABLED_FLAG, L2_MEDIA_NAME L2_MEDIA_NAME, L2_DESCRIPTION L2_DESCRIPTION, L2_INSTANCE L2_INSTANCE, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5, L3_CHANNEL_PK L3_CHANNEL_PK, L3_CHANNEL_DP L3_CHANNEL_DP, L3_NAME L3_NAME, L3_CHANNEL_ID L3_CHANNEL_ID, L3_CHANNEL_TYPE_CODE L3_CHANNEL_TYPE_CODE, L3_CHANNEL_TYPE L3_CHANNEL_TYPE, L3_INBOUND_FLAG L3_INBOUND_FLAG, L3_OUTBOUND_FLAG L3_OUTBOUND_FLAG, L3_RATING L3_RATING, L3_PREFERRED_VENDOR_ID L3_PREFERRED_VENDOR_ID, L3_PARTY_ID L3_PARTY_ID, L3_MANAGED_BY_PERSON_ID L3_MANAGED_BY_PERSON_ID, L3_ACTIVE_FROM_DATE L3_ACTIVE_FROM_DATE, L3_ACTIVE_TO_DATE L3_ACTIVE_TO_DATE, L3_CHANNEL_NAME L3_CHANNEL_NAME, L3_DESCRIPTION L3_DESCRIPTION, L3_INSTANCE L3_INSTANCE, L3_USER_ATTRIBUTE1 L3_USER_ATTRIBUTE1, L3_USER_ATTRIBUTE2 L3_USER_ATTRIBUTE2, L3_USER_ATTRIBUTE3 L3_USER_ATTRIBUTE3, L3_USER_ATTRIBUTE4 L3_USER_ATTRIBUTE4, L3_USER_ATTRIBUTE5 L3_USER_ATTRIBUTE5, L4_MDCHNL_PK L4_MDCHNL_PK, L4_MDCHNL_DP L4_MDCHNL_DP, L4_NAME L4_NAME, L4_LEVEL_NAME L4_LEVEL_NAME, L4_MEDIA_CHANNEL_ID L4_MEDIA_CHANNEL_ID, L4_ACTIVE_FROM_DATE L4_ACTIVE_FROM_DATE, L4_ACTIVE_TO_DATE L4_ACTIVE_TO_DATE, L4_INSTANCE L4_INSTANCE, L4_USER_ATTRIBUTE1 L4_USER_ATTRIBUTE1, L4_USER_ATTRIBUTE2 L4_USER_ATTRIBUTE2, L4_USER_ATTRIBUTE3 L4_USER_ATTRIBUTE3, L4_USER_ATTRIBUTE4 L4_USER_ATTRIBUTE4, L4_USER_ATTRIBUTE5 L4_USER_ATTRIBUTE5, L4_LAST_UPDATE_DATE L4_LAST_UPDATE_DATE, L4_CREATION_DATE L4_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_MDCHN_M"

View Text - HTML Formatted

SELECT L4_MDCHNL_PK_KEY L4_MDCHNL_PK_KEY
, L3_CHANNEL_PK_KEY L3_CHANNEL_PK_KEY
, L2_MEDIA_PK_KEY L2_MEDIA_PK_KEY
, L1_MEDIA_TYPE_PK_KEY L1_MEDIA_TYPE_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_MEDIA_TYPE_PK L1_MEDIA_TYPE_PK
, L1_MEDIA_TYPE_DP L1_MEDIA_TYPE_DP
, L1_NAME L1_NAME
, L1_MEDIA_TYPE_CODE L1_MEDIA_TYPE_CODE
, L1_ENABLED_FLAG L1_ENABLED_FLAG
, L1_START_DATE_ACTIVE L1_START_DATE_ACTIVE
, L1_END_DATE_ACTIVE L1_END_DATE_ACTIVE
, L1_MEDIA_TYPE_NAME L1_MEDIA_TYPE_NAME
, 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
, L2_MEDIA_PK L2_MEDIA_PK
, L2_MEDIA_DP L2_MEDIA_DP
, L2_NAME L2_NAME
, L2_MEDIA_ID L2_MEDIA_ID
, L2_INBOUND_FLAG L2_INBOUND_FLAG
, L2_ENABLED_FLAG L2_ENABLED_FLAG
, L2_MEDIA_NAME L2_MEDIA_NAME
, L2_DESCRIPTION L2_DESCRIPTION
, L2_INSTANCE L2_INSTANCE
, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1
, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2
, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3
, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4
, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5
, L3_CHANNEL_PK L3_CHANNEL_PK
, L3_CHANNEL_DP L3_CHANNEL_DP
, L3_NAME L3_NAME
, L3_CHANNEL_ID L3_CHANNEL_ID
, L3_CHANNEL_TYPE_CODE L3_CHANNEL_TYPE_CODE
, L3_CHANNEL_TYPE L3_CHANNEL_TYPE
, L3_INBOUND_FLAG L3_INBOUND_FLAG
, L3_OUTBOUND_FLAG L3_OUTBOUND_FLAG
, L3_RATING L3_RATING
, L3_PREFERRED_VENDOR_ID L3_PREFERRED_VENDOR_ID
, L3_PARTY_ID L3_PARTY_ID
, L3_MANAGED_BY_PERSON_ID L3_MANAGED_BY_PERSON_ID
, L3_ACTIVE_FROM_DATE L3_ACTIVE_FROM_DATE
, L3_ACTIVE_TO_DATE L3_ACTIVE_TO_DATE
, L3_CHANNEL_NAME L3_CHANNEL_NAME
, L3_DESCRIPTION L3_DESCRIPTION
, L3_INSTANCE L3_INSTANCE
, L3_USER_ATTRIBUTE1 L3_USER_ATTRIBUTE1
, L3_USER_ATTRIBUTE2 L3_USER_ATTRIBUTE2
, L3_USER_ATTRIBUTE3 L3_USER_ATTRIBUTE3
, L3_USER_ATTRIBUTE4 L3_USER_ATTRIBUTE4
, L3_USER_ATTRIBUTE5 L3_USER_ATTRIBUTE5
, L4_MDCHNL_PK L4_MDCHNL_PK
, L4_MDCHNL_DP L4_MDCHNL_DP
, L4_NAME L4_NAME
, L4_LEVEL_NAME L4_LEVEL_NAME
, L4_MEDIA_CHANNEL_ID L4_MEDIA_CHANNEL_ID
, L4_ACTIVE_FROM_DATE L4_ACTIVE_FROM_DATE
, L4_ACTIVE_TO_DATE L4_ACTIVE_TO_DATE
, L4_INSTANCE L4_INSTANCE
, L4_USER_ATTRIBUTE1 L4_USER_ATTRIBUTE1
, L4_USER_ATTRIBUTE2 L4_USER_ATTRIBUTE2
, L4_USER_ATTRIBUTE3 L4_USER_ATTRIBUTE3
, L4_USER_ATTRIBUTE4 L4_USER_ATTRIBUTE4
, L4_USER_ATTRIBUTE5 L4_USER_ATTRIBUTE5
, L4_LAST_UPDATE_DATE L4_LAST_UPDATE_DATE
, L4_CREATION_DATE L4_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_MDCHN_M"