VIEW: APPS.BIM_DIMV_CHANNELS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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