[Home] [Help]
View: EDW_BIM_MDCH_MEDIA_LCV
Product: | BIM - Marketing Intelligence(Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AME.MEDIA_ID || '-' || INST.INSTANCE_CODE || '-MEDIA' MEDIA_PK
, AME.MEDIA_TYPE_CODE || '-' || INST.INSTANCE_CODE MEDIA_TYPE_FK
, AME.MEDIA_NAME MEDIA_DP
, AME.MEDIA_NAME NAME
, AME.MEDIA_ID MEDIA_ID
, AME.INBOUND_FLAG INBOUND_FLAG
, AME.ENABLED_FLAG ENABLED_FLAG
, AME.MEDIA_NAME MEDIA_NAME
, AME.DESCRIPTION DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, AME.CREATION_DATE CREATION_DATE
, AME.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM AMS_MEDIA_VL AME
, EDW_LOCAL_INSTANCE INST
Columns
Name |
MEDIA_PK |
MEDIA_TYPE_FK |
MEDIA_DP |
NAME |
MEDIA_ID |
INBOUND_FLAG |
ENABLED_FLAG |
MEDIA_NAME |
DESCRIPTION |
INSTANCE |
CREATION_DATE |
LAST_UPDATE_DATE |