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.

VIEW: APPS.BIM_DIMV_MEDIA_CHANNELS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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