View: BIM_DIMV_CHANNELS

Product:	BIM - Marketing Intelligence
Description:	Shows all marketing channels which includes media channels, events and event offerings.
Implementation/DBA Data:	APPS.BIM_DIMV_CHANNELS

View Text

SELECT 'CHLS' || TO_CHAR(AMC.CHANNEL_ID) ID
, SUBSTR(AMC.CHANNEL_NAME
, 1
, 80) VALUE
, 'CHLS' || TO_CHAR( AMC.CHANNEL_ID) CHANNEL_ID
, AMC.CHANNEL_TYPE_CODE CHANNEL_TYPE_CODE
, AMC.CHANNEL_TYPE CHANNEL_TYPE
, AMC.INBOUND_FLAG INBOUND_FLAG
, AMC.OUTBOUND_FLAG OUTBOUND_FLAG
, AMC.ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, AMC.ACTIVE_TO_DATE ACTIVE_TO_DATE
, AMC.CHANNEL_NAME CHANNEL_NAME
, AMC.DESCRIPTION DESCRIPTION
FROM AMS_CHANNELS_VL AMC UNION ALL SELECT 'EVEH' || TO_CHAR(AEH.EVENT_HEADER_ID) ID
, SUBSTR(AEH.EVENT_HEADER_NAME
, 1
, 80) VALUE
, 'EVEH' || TO_CHAR(AEH.EVENT_HEADER_ID) CHANNEL_ID
, AEH.EVENT_TYPE_CODE CHANNEL_TYPE_CODE
, AML.MEANING CHANNEL_TYPE
, NULL INBOUND_FLAG
, NULL OUTBOUND_FLAG
, AEH.ACTIVE_FROM_DATE ACTIVE_FROM_DATE
, AEH.ACTIVE_TO_DATE ACTIVE_TO_DATE
, AEH.EVENT_HEADER_NAME CHANNEL_NAME
, AEH.DESCRIPTION DESCRIPTION
FROM AMS_EVENT_HEADERS_VL AEH
, AMS_LOOKUPS AML
WHERE AEH.EVENT_TYPE_CODE = AML.LOOKUP_CODE
AND AML.LOOKUP_TYPE = 'AMS_EVENT_TYPE'
AND AEH.EVENT_LEVEL = 'MAIN' UNION ALL SELECT 'EVEO' || TO_CHAR(AEO.EVENT_OFFER_ID) ID
, SUBSTR(AEO.EVENT_OFFER_NAME
, 1
, 80) VALUE
, 'EVEO' || TO_CHAR(AEO.EVENT_OFFER_ID) CHANNEL_ID
, AEO.EVENT_TYPE_CODE CHANNEL_TYPE_CODE
, AML.MEANING CHANNEL_TYPE
, NULL INBOUND_FLAG
, NULL OUTBOUND_FLAG
, AEO.EVENT_START_DATE ACTIVE_FROM_DATE
, AEO.EVENT_END_DATE ACTIVE_TO_DATE
, AEO.EVENT_OFFER_NAME CHANNEL_NAME
, AEO.DESCRIPTION DESCRIPTION
FROM AMS_EVENT_OFFERS_VL AEO
, AMS_LOOKUPS AML
WHERE AEO.EVENT_TYPE_CODE = AML.LOOKUP_CODE
AND AML.LOOKUP_TYPE = 'AMS_EVENT_TYPE'
AND AEO.EVENT_LEVEL = 'MAIN' UNION ALL SELECT '-999'
, MEANING
, '-999'
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY

Columns