[Home] [Help]
View: BIM_DIMV_MEDIA_CHANNELS
Product: | BIM - Marketing Intelligence |
Description: | Shows the relationship between media and the channels.. |
Implementation/DBA Data: |
APPS.BIM_DIMV_MEDIA_CHANNELS
|
View Text
SELECT AMC.MEDIA_ID MEDIA_ID
, AME.MEDIA_NAME MEDIA_NAME
, AME.MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, AME.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, 'CHLS' || TO_CHAR(AMC.CHANNEL_ID) CHANNEL_ID
, ACH.CHANNEL_TYPE_CODE CHANNEL_TYPE_CODE
, ACH.CHANNEL_TYPE CHANNEL_TYPE
, ACH.CHANNEL_NAME CHANNEL_NAME
FROM AMS_CHANNELS_VL ACH
, AMS_MEDIA_CHANNELS AMC
, AMS_MEDIA_VL AME
WHERE AMC.MEDIA_ID = AME.MEDIA_ID
AND AMC.CHANNEL_ID = ACH.CHANNEL_ID UNION ALL SELECT AME.MEDIA_ID
, AME.MEDIA_NAME
, AME.MEDIA_TYPE_CODE
, AME.MEDIA_TYPE_NAME
, '-999'
, '-999'
, MEANING
, MEANING
FROM AMS_MEDIA_VL AME
, FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' UNION ALL SELECT -999 MEDIA_ID
, FND.MEANING MEDIA_NAME
, '-999' MEDIA_TYPE_CODE
, FND.MEANING MEDIA_TYPE_NAME
, 'EVEH' || TO_CHAR( AEH.EVENT_HEADER_ID) CHANNEL_ID
, AEH.EVENT_TYPE_CODE CHANNEL_TYPE_CODE
, AML.MEANING CHANNEL_TYPE
, AEH.EVENT_HEADER_NAME CHANNEL_NAME
FROM AMS_EVENT_HEADERS_VL AEH
, AMS_LOOKUPS AML
, FND_LOOKUPS FND
WHERE AEH.EVENT_TYPE_CODE = AML.LOOKUP_CODE
AND AML.LOOKUP_TYPE = 'AMS_EVENT_TYPE'
AND AEH.EVENT_LEVEL = 'MAIN'
AND FND.LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND FND.LOOKUP_CODE = '-999' UNION ALL SELECT -999 MEDIA_ID
, FND.MEANING MEDIA_NAME
, '-999' MEDIA_TYPE_CODE
, FND.MEANING MEDIA_TYPE_NAME
, 'EVEO' || TO_CHAR(AEO.EVENT_OFFER_ID) CHANNEL_ID
, AEO.EVENT_TYPE_CODE CHANNEL_TYPE_CODE
, AML.MEANING CHANNEL_TYPE
, AEO.EVENT_OFFER_NAME CHANNEL_NAME
FROM AMS_EVENT_OFFERS_VL AEO
, AMS_LOOKUPS AML
, FND_LOOKUPS FND
WHERE AEO.EVENT_TYPE_CODE = AML.LOOKUP_CODE
AND AML.LOOKUP_TYPE = 'AMS_EVENT_TYPE'
AND AEO.EVENT_LEVEL = 'MAIN'
AND FND.LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND FND.LOOKUP_CODE = '-999' UNION ALL SELECT -999
, MEANING
, '-999'
, MEANING
, '-999'
, '-999'
, MEANING
, MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY
Columns
Name |
MEDIA_ID |
MEDIA_NAME |
MEDIA_TYPE_CODE |
MEDIA_TYPE_NAME |
CHANNEL_ID |
CHANNEL_TYPE_CODE |
CHANNEL_TYPE |
CHANNEL_NAME |