Product: | AMS - Marketing |
---|---|
Description: | This public view returns all marketing campaigns and related information. |
Implementation/DBA Data: | APPS.AMS_P_CAMPAIGNS_V |
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'