VIEW: APPS.AMS_P_EVENT_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT e.event_offer_id event_offer_id, e.event_offer_name event_offer_name, e.description event_offer_description, e.event_object_type event_object_type, to_number('') event_header_id, to_char('') event_header_name, c.campaign_id campaign_id, c.campaign_name campaign_name, c.description campaign_description, c.source_code campaign_source_code, to_char('') media_name from ams_event_offers_vl e, ams_campaigns_vl c WHERE c.related_event_id =e.event_offer_id and c.related_event_from in('EVEO','EONE') union all select to_number('') event_offer_id, to_char('') event_offer_name, to_char('') event_offer_description, to_char('') event_object_type, h.event_header_id event_header_id, h.event_header_name event_header_name, c.campaign_id campaign_id, c.campaign_name campaign_name, c.description campaign_description, c.source_code campaign_source_code, to_char('') media_name from ams_event_headers_vl h, ams_campaigns_vl c where c.related_event_id =h.event_header_id and c.related_event_from = 'EVEH'

View Text - HTML Formatted

SELECT E.EVENT_OFFER_ID EVENT_OFFER_ID
, E.EVENT_OFFER_NAME EVENT_OFFER_NAME
, E.DESCRIPTION EVENT_OFFER_DESCRIPTION
, E.EVENT_OBJECT_TYPE EVENT_OBJECT_TYPE
, TO_NUMBER('') EVENT_HEADER_ID
, TO_CHAR('') EVENT_HEADER_NAME
, C.CAMPAIGN_ID CAMPAIGN_ID
, C.CAMPAIGN_NAME CAMPAIGN_NAME
, C.DESCRIPTION CAMPAIGN_DESCRIPTION
, C.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, TO_CHAR('') MEDIA_NAME
FROM AMS_EVENT_OFFERS_VL E
, AMS_CAMPAIGNS_VL C
WHERE C.RELATED_EVENT_ID =E.EVENT_OFFER_ID
AND C.RELATED_EVENT_FROM IN('EVEO'
, 'EONE') UNION ALL SELECT TO_NUMBER('') EVENT_OFFER_ID
, TO_CHAR('') EVENT_OFFER_NAME
, TO_CHAR('') EVENT_OFFER_DESCRIPTION
, TO_CHAR('') EVENT_OBJECT_TYPE
, H.EVENT_HEADER_ID EVENT_HEADER_ID
, H.EVENT_HEADER_NAME EVENT_HEADER_NAME
, C.CAMPAIGN_ID CAMPAIGN_ID
, C.CAMPAIGN_NAME CAMPAIGN_NAME
, C.DESCRIPTION CAMPAIGN_DESCRIPTION
, C.SOURCE_CODE CAMPAIGN_SOURCE_CODE
, TO_CHAR('') MEDIA_NAME
FROM AMS_EVENT_HEADERS_VL H
, AMS_CAMPAIGNS_VL C
WHERE C.RELATED_EVENT_ID =H.EVENT_HEADER_ID
AND C.RELATED_EVENT_FROM = 'EVEH'