VIEW: APPS.AMS_P_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT CAM.CAMPAIGN_ID, CAM.CAMPAIGN_NAME, CAM.DESCRIPTION, CAM.CAMPAIGN_TYPE CAMPAIGN_PURPOSE, CAM.ROLLUP_TYPE, CAM.STATUS_CODE, CAM.STATUS_DATE, CAM.SOURCE_CODE, CAM.OWNER_USER_ID, CAM.CASCADE_SOURCE_CODE_FLAG, CAM.PARTNER_FLAG, CAM.PARENT_CAMPAIGN_ID, CAM.PRIORITY, CAM.DSCRIPT_NAME INBOUND_SCRIPT_NAME, CAM.APPLICATION_ID, CAM.FUND_SOURCE_TYPE, CAM.FUND_SOURCE_ID, CAM.ACTUAL_EXEC_START_DATE, CAM.ACTUAL_EXEC_END_DATE, CAM.MEDIA_ID, NULL MEDIA_NAME, NULL MEDIA_TYPE_CODE, NULL MEDIA_TYPE_NAME, CAM.ARC_CHANNEL_FROM CHANNEL_SOURCE, CAM.CHANNEL_ID, NULL CHANNEL_NAME, NULL CHANNEL_TYPE, NULL CHANNEL_OUTBOUND_FLAG, NULL CHANNEL_INBOUND_FLAG, CAM.INBOUND_URL, CAM.INBOUND_EMAIL_ID, CAM.INBOUND_PHONE_NO, CAM.FF_PRIORITY, CAM.FF_OVERRIDE_COVER_LETTER, CAM.FF_SHIPPING_METHOD, CAM.CONTENT_SOURCE, CAM.CC_CALL_STRATEGY, CAM.CC_MANAGER_USER_ID, CAM.VERSION_NO, CAM.CAMPAIGN_CALENDAR, CAM.START_PERIOD_NAME, CAM.END_PERIOD_NAME, CAM.CITY_ID, CAM.GLOBAL_FLAG, CAM.CUSTOM_SETUP_ID, CAM.BUSINESS_UNIT_ID, CAM.RELATED_EVENT_FROM, CAM.RELATED_EVENT_ID from AMS_CAMPAIGNS_VL CAM WHERE CAM.ROLLUP_TYPE <> 'RCAM' and CAM.PRIVATE_FLAG = 'N' and CAM.TEMPLATE_FLAG = 'N' and CAM.ACTIVE_FLAG = 'Y' and CAM.SHOW_CAMPAIGN_FLAG = 'Y'

View Text - HTML Formatted

SELECT CAM.CAMPAIGN_ID
, CAM.CAMPAIGN_NAME
, CAM.DESCRIPTION
, CAM.CAMPAIGN_TYPE CAMPAIGN_PURPOSE
, CAM.ROLLUP_TYPE
, CAM.STATUS_CODE
, CAM.STATUS_DATE
, CAM.SOURCE_CODE
, CAM.OWNER_USER_ID
, CAM.CASCADE_SOURCE_CODE_FLAG
, CAM.PARTNER_FLAG
, CAM.PARENT_CAMPAIGN_ID
, CAM.PRIORITY
, CAM.DSCRIPT_NAME INBOUND_SCRIPT_NAME
, CAM.APPLICATION_ID
, CAM.FUND_SOURCE_TYPE
, CAM.FUND_SOURCE_ID
, CAM.ACTUAL_EXEC_START_DATE
, CAM.ACTUAL_EXEC_END_DATE
, CAM.MEDIA_ID
, NULL MEDIA_NAME
, NULL MEDIA_TYPE_CODE
, NULL MEDIA_TYPE_NAME
, CAM.ARC_CHANNEL_FROM CHANNEL_SOURCE
, CAM.CHANNEL_ID
, NULL CHANNEL_NAME
, NULL CHANNEL_TYPE
, NULL CHANNEL_OUTBOUND_FLAG
, NULL CHANNEL_INBOUND_FLAG
, CAM.INBOUND_URL
, CAM.INBOUND_EMAIL_ID
, CAM.INBOUND_PHONE_NO
, CAM.FF_PRIORITY
, CAM.FF_OVERRIDE_COVER_LETTER
, CAM.FF_SHIPPING_METHOD
, CAM.CONTENT_SOURCE
, CAM.CC_CALL_STRATEGY
, CAM.CC_MANAGER_USER_ID
, CAM.VERSION_NO
, CAM.CAMPAIGN_CALENDAR
, CAM.START_PERIOD_NAME
, CAM.END_PERIOD_NAME
, CAM.CITY_ID
, CAM.GLOBAL_FLAG
, CAM.CUSTOM_SETUP_ID
, CAM.BUSINESS_UNIT_ID
, CAM.RELATED_EVENT_FROM
, CAM.RELATED_EVENT_ID
FROM AMS_CAMPAIGNS_VL CAM
WHERE CAM.ROLLUP_TYPE <> 'RCAM'
AND CAM.PRIVATE_FLAG = 'N'
AND CAM.TEMPLATE_FLAG = 'N'
AND CAM.ACTIVE_FLAG = 'Y'
AND CAM.SHOW_CAMPAIGN_FLAG = 'Y'