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: EDW_BIM_MDCH_CHANNELS_LCV

Product:	BIM - Marketing Intelligence(Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ACH.CHANNEL_ID || '-' || INST.INSTANCE_CODE || '-CHANNEL' CHANNEL_PK
, 'ALL' ALL_FK
, ACH.CHANNEL_NAME CHANNEL_DP
, ACH.CHANNEL_NAME NAME
, ACH.CHANNEL_ID CHANNEL_ID
, ACH.CHANNEL_TYPE_CODE CHANNEL_TYPE_CODE
, ACH.CHANNEL_TYPE CHANNEL_TYPE
, ACH.INBOUND_FLAG INBOUND_FLAG
, ACH.OUTBOUND_FLAG OUTBOUND_FLAG
, ACH.RATING RATING
, ACH.PREFERRED_VENDOR_ID PREFERRED_VENDOR_ID
, ACH.PARTY_ID PARTY_ID
, ACH.MANAGED_BY_PERSON_ID MANAGED_BY_PERSON_ID
, ACH.ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, ACH.ACTIVE_TO_DATE ACTIVE_TO_DATE
, ACH.CHANNEL_NAME CHANNEL_NAME
, ACH.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, ACH.CREATION_DATE CREATION_DATE
, ACH.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_CHANNELS_VL ACH
, EDW_LOCAL_INSTANCE INST

Columns

Name
CHANNEL_PK
ALL_FK
CHANNEL_DP
NAME
CHANNEL_ID
CHANNEL_TYPE_CODE
CHANNEL_TYPE
INBOUND_FLAG
OUTBOUND_FLAG
RATING
PREFERRED_VENDOR_ID
PARTY_ID
MANAGED_BY_PERSON_ID
ACTIVE_FROM_DATE
ACTIVE_TO_DATE
CHANNEL_NAME
DESCRIPTION
INSTANCE
CREATION_DATE
LAST_UPDATE_DATE