Product: | AMS - Marketing |
---|---|
Description: | This view returns all marketing campaigns and related information. |
Implementation/DBA Data: | APPS.AMS_CAMPAIGNS_V |
SELECT CAM.ROW_ID ROW_ID
, CAM.CAMPAIGN_ID
, CAM.LAST_UPDATE_DATE
, CAM.LAST_UPDATED_BY
, CAM.CREATION_DATE
, CAM.CREATED_BY
, CAM.LAST_UPDATE_LOGIN
, CAM.OBJECT_VERSION_NUMBER
, CAM.OWNER_USER_ID
, CAM.USER_STATUS_ID
, STAT.NAME USER_STATUS
, CAM.STATUS_CODE
, CAM.STATUS_DATE
, CAM.ACTIVE_FLAG
, CAM.PRIVATE_FLAG
, CAM.PARTNER_FLAG
, CAM.TEMPLATE_FLAG
, CAM.CASCADE_SOURCE_CODE_FLAG
, CAM.INHERIT_ATTRIBUTES_FLAG
, CAM.SOURCE_CODE
, CAM.ROLLUP_TYPE
, CAM.CAMPAIGN_TYPE CAMPAIGN_PURPOSE_CODE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_CAMPAIGN_PURPOSE'
, CAM.CAMPAIGN_TYPE)
, CAM.MEDIA_TYPE_CODE
, AMS_UTILITY_PVT.GET_LOOKUP_MEANING('AMS_MEDIA_TYPE'
, CAM.MEDIA_TYPE_CODE)
, CAM.PRIORITY
, CAM.FUND_SOURCE_TYPE
, CAM.FUND_SOURCE_ID
, CAM.PARENT_CAMPAIGN_ID
, CTL.CAMPAIGN_NAME PARENT_NAME
, CAM.APPLICATION_ID
, CAM.QP_LIST_HEADER_ID
, CAM.MEDIA_ID
, NULL MEDIA_NAME
, CAM.CHANNEL_ID
, CAM.EVENT_TYPE
, CAM.ARC_CHANNEL_FROM
, CAM.DSCRIPT_NAME
, CAM.TRANSACTION_CURRENCY_CODE
, CAM.FUNCTIONAL_CURRENCY_CODE
, CAM.BUDGET_AMOUNT_TC
, CAM.BUDGET_AMOUNT_FC
, CAM.FORECASTED_PLAN_START_DATE
, CAM.FORECASTED_PLAN_END_DATE
, CAM.FORECASTED_EXEC_START_DATE
, CAM.FORECASTED_EXEC_END_DATE
, CAM.ACTUAL_PLAN_START_DATE
, CAM.ACTUAL_PLAN_END_DATE
, CAM.ACTUAL_EXEC_START_DATE
, CAM.ACTUAL_EXEC_END_DATE
, CAM.INBOUND_URL
, CAM.INBOUND_EMAIL_ID
, CAM.INBOUND_PHONE_NO
, CAM.DURATION
, CAM.DURATION_UOM_CODE
, CAM.FF_PRIORITY
, CAM.FF_OVERRIDE_COVER_LETTER
, CAM.FF_SHIPPING_METHOD
, CAM.FF_CARRIER
, CAM.CONTENT_SOURCE
, CAM.CC_CALL_STRATEGY
, CAM.CC_MANAGER_USER_ID
, CAM.FORECASTED_REVENUE
, CAM.ACTUAL_REVENUE
, CAM.FORECASTED_COST
, CAM.ACTUAL_COST
, CAM.FORECASTED_RESPONSE
, CAM.ACTUAL_RESPONSE
, CAM.TARGET_RESPONSE
, CAM.COUNTRY_CODE
, CAM.LANGUAGE_CODE
, CAM.ATTRIBUTE_CATEGORY
, CAM.ATTRIBUTE1
, CAM.ATTRIBUTE2
, CAM.ATTRIBUTE3
, CAM.ATTRIBUTE4
, CAM.ATTRIBUTE5
, CAM.ATTRIBUTE6
, CAM.ATTRIBUTE7
, CAM.ATTRIBUTE8
, CAM.ATTRIBUTE9
, CAM.ATTRIBUTE10
, CAM.ATTRIBUTE11
, CAM.ATTRIBUTE12
, CAM.ATTRIBUTE14
, CAM.ATTRIBUTE13
, CAM.ATTRIBUTE15
, CAM.CAMPAIGN_NAME
, CAM.CAMPAIGN_THEME
, CAM.DESCRIPTION
, 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.SHOW_CAMPAIGN_FLAG
, CAM.BUSINESS_UNIT_ID
, CAM.ACCOUNTS_CLOSED_FLAG
, CAM.TASK_ID
, CAM.RELATED_EVENT_FROM
, CAM.RELATED_EVENT_ID
, CAM.PROGRAM_ATTRIBUTE_CATEGORY
, CAM.PROGRAM_ATTRIBUTE1
, CAM.PROGRAM_ATTRIBUTE2
, CAM.PROGRAM_ATTRIBUTE3
, CAM.PROGRAM_ATTRIBUTE4
, CAM.PROGRAM_ATTRIBUTE5
, CAM.PROGRAM_ATTRIBUTE6
, CAM.PROGRAM_ATTRIBUTE7
, CAM.PROGRAM_ATTRIBUTE8
, CAM.PROGRAM_ATTRIBUTE9
, CAM.PROGRAM_ATTRIBUTE10
, CAM.PROGRAM_ATTRIBUTE11
, CAM.PROGRAM_ATTRIBUTE12
, CAM.PROGRAM_ATTRIBUTE13
, CAM.PROGRAM_ATTRIBUTE14
, CAM.PROGRAM_ATTRIBUTE15
FROM AMS_CAMPAIGNS_VL CAM
, AMS_CAMPAIGNS_ALL_TL CTL
, AMS_USER_STATUSES_VL STAT
WHERE CAM.PARENT_CAMPAIGN_ID = CTL.CAMPAIGN_ID(+)
AND CTL.LANGUAGE(+) = USERENV('LANG')
AND STAT.USER_STATUS_ID = CAM.USER_STATUS_ID