VIEW: APPS.AMS_CAMPAIGNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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