VIEW: AMS.AMS_CAMPAIGNS_ALL_B#

Source

View Text - Preformatted

select CAMPAIGN_ID CAMPAIGN_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, OWNER_USER_ID OWNER_USER_ID, USER_STATUS_ID USER_STATUS_ID, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, ACTIVE_FLAG ACTIVE_FLAG, PRIVATE_FLAG PRIVATE_FLAG, PARTNER_FLAG PARTNER_FLAG, TEMPLATE_FLAG TEMPLATE_FLAG, CASCADE_SOURCE_CODE_FLAG CASCADE_SOURCE_CODE_FLAG, INHERIT_ATTRIBUTES_FLAG INHERIT_ATTRIBUTES_FLAG, SOURCE_CODE SOURCE_CODE, ROLLUP_TYPE ROLLUP_TYPE, CAMPAIGN_TYPE CAMPAIGN_TYPE, MEDIA_TYPE_CODE MEDIA_TYPE_CODE, PRIORITY PRIORITY, FUND_SOURCE_TYPE FUND_SOURCE_TYPE, FUND_SOURCE_ID FUND_SOURCE_ID, PARENT_CAMPAIGN_ID PARENT_CAMPAIGN_ID, APPLICATION_ID APPLICATION_ID, QP_LIST_HEADER_ID QP_LIST_HEADER_ID, ORG_ID ORG_ID, MEDIA_ID MEDIA_ID, CHANNEL_ID CHANNEL_ID, EVENT_TYPE EVENT_TYPE, ARC_CHANNEL_FROM ARC_CHANNEL_FROM, DSCRIPT_NAME DSCRIPT_NAME, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC, FORECASTED_PLAN_START_DATE FORECASTED_PLAN_START_DATE, FORECASTED_PLAN_END_DATE FORECASTED_PLAN_END_DATE, FORECASTED_EXEC_START_DATE FORECASTED_EXEC_START_DATE, FORECASTED_EXEC_END_DATE FORECASTED_EXEC_END_DATE, ACTUAL_PLAN_START_DATE ACTUAL_PLAN_START_DATE, ACTUAL_PLAN_END_DATE ACTUAL_PLAN_END_DATE, ACTUAL_EXEC_START_DATE ACTUAL_EXEC_START_DATE, ACTUAL_EXEC_END_DATE ACTUAL_EXEC_END_DATE, INBOUND_URL INBOUND_URL, INBOUND_EMAIL_ID INBOUND_EMAIL_ID, INBOUND_PHONE_NO INBOUND_PHONE_NO, DURATION DURATION, DURATION_UOM_CODE DURATION_UOM_CODE, FF_PRIORITY FF_PRIORITY, FF_OVERRIDE_COVER_LETTER FF_OVERRIDE_COVER_LETTER, FF_SHIPPING_METHOD FF_SHIPPING_METHOD, FF_CARRIER FF_CARRIER, CONTENT_SOURCE CONTENT_SOURCE, CC_CALL_STRATEGY CC_CALL_STRATEGY, CC_MANAGER_USER_ID CC_MANAGER_USER_ID, FORECASTED_REVENUE FORECASTED_REVENUE, ACTUAL_REVENUE ACTUAL_REVENUE, FORECASTED_COST FORECASTED_COST, ACTUAL_COST ACTUAL_COST, FORECASTED_RESPONSE FORECASTED_RESPONSE, ACTUAL_RESPONSE ACTUAL_RESPONSE, TARGET_RESPONSE TARGET_RESPONSE, COUNTRY_CODE COUNTRY_CODE, LANGUAGE_CODE LANGUAGE_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE15 ATTRIBUTE15, VERSION_NO VERSION_NO, CAMPAIGN_CALENDAR CAMPAIGN_CALENDAR, START_PERIOD_NAME START_PERIOD_NAME, END_PERIOD_NAME END_PERIOD_NAME, CITY_ID CITY_ID, GLOBAL_FLAG GLOBAL_FLAG, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, SHOW_CAMPAIGN_FLAG SHOW_CAMPAIGN_FLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, ACCOUNTS_CLOSED_FLAG ACCOUNTS_CLOSED_FLAG, TASK_ID TASK_ID, RELATED_EVENT_FROM RELATED_EVENT_FROM, RELATED_EVENT_ID RELATED_EVENT_ID, PROGRAM_ATTRIBUTE_CATEGORY PROGRAM_ATTRIBUTE_CATEGORY, PROGRAM_ATTRIBUTE1 PROGRAM_ATTRIBUTE1, PROGRAM_ATTRIBUTE2 PROGRAM_ATTRIBUTE2, PROGRAM_ATTRIBUTE3 PROGRAM_ATTRIBUTE3, PROGRAM_ATTRIBUTE4 PROGRAM_ATTRIBUTE4, PROGRAM_ATTRIBUTE5 PROGRAM_ATTRIBUTE5, PROGRAM_ATTRIBUTE6 PROGRAM_ATTRIBUTE6, PROGRAM_ATTRIBUTE7 PROGRAM_ATTRIBUTE7, PROGRAM_ATTRIBUTE8 PROGRAM_ATTRIBUTE8, PROGRAM_ATTRIBUTE9 PROGRAM_ATTRIBUTE9, PROGRAM_ATTRIBUTE10 PROGRAM_ATTRIBUTE10, PROGRAM_ATTRIBUTE11 PROGRAM_ATTRIBUTE11, PROGRAM_ATTRIBUTE12 PROGRAM_ATTRIBUTE12, PROGRAM_ATTRIBUTE13 PROGRAM_ATTRIBUTE13, PROGRAM_ATTRIBUTE14 PROGRAM_ATTRIBUTE14, PROGRAM_ATTRIBUTE15 PROGRAM_ATTRIBUTE15, ORIG_CUSTOM_SETUP_ID ORIG_CUSTOM_SETUP_ID from "AMS"."AMS_CAMPAIGNS_ALL_B"

View Text - HTML Formatted

SELECT CAMPAIGN_ID CAMPAIGN_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OWNER_USER_ID OWNER_USER_ID
, USER_STATUS_ID USER_STATUS_ID
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, ACTIVE_FLAG ACTIVE_FLAG
, PRIVATE_FLAG PRIVATE_FLAG
, PARTNER_FLAG PARTNER_FLAG
, TEMPLATE_FLAG TEMPLATE_FLAG
, CASCADE_SOURCE_CODE_FLAG CASCADE_SOURCE_CODE_FLAG
, INHERIT_ATTRIBUTES_FLAG INHERIT_ATTRIBUTES_FLAG
, SOURCE_CODE SOURCE_CODE
, ROLLUP_TYPE ROLLUP_TYPE
, CAMPAIGN_TYPE CAMPAIGN_TYPE
, MEDIA_TYPE_CODE MEDIA_TYPE_CODE
, PRIORITY PRIORITY
, FUND_SOURCE_TYPE FUND_SOURCE_TYPE
, FUND_SOURCE_ID FUND_SOURCE_ID
, PARENT_CAMPAIGN_ID PARENT_CAMPAIGN_ID
, APPLICATION_ID APPLICATION_ID
, QP_LIST_HEADER_ID QP_LIST_HEADER_ID
, ORG_ID ORG_ID
, MEDIA_ID MEDIA_ID
, CHANNEL_ID CHANNEL_ID
, EVENT_TYPE EVENT_TYPE
, ARC_CHANNEL_FROM ARC_CHANNEL_FROM
, DSCRIPT_NAME DSCRIPT_NAME
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC
, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC
, FORECASTED_PLAN_START_DATE FORECASTED_PLAN_START_DATE
, FORECASTED_PLAN_END_DATE FORECASTED_PLAN_END_DATE
, FORECASTED_EXEC_START_DATE FORECASTED_EXEC_START_DATE
, FORECASTED_EXEC_END_DATE FORECASTED_EXEC_END_DATE
, ACTUAL_PLAN_START_DATE ACTUAL_PLAN_START_DATE
, ACTUAL_PLAN_END_DATE ACTUAL_PLAN_END_DATE
, ACTUAL_EXEC_START_DATE ACTUAL_EXEC_START_DATE
, ACTUAL_EXEC_END_DATE ACTUAL_EXEC_END_DATE
, INBOUND_URL INBOUND_URL
, INBOUND_EMAIL_ID INBOUND_EMAIL_ID
, INBOUND_PHONE_NO INBOUND_PHONE_NO
, DURATION DURATION
, DURATION_UOM_CODE DURATION_UOM_CODE
, FF_PRIORITY FF_PRIORITY
, FF_OVERRIDE_COVER_LETTER FF_OVERRIDE_COVER_LETTER
, FF_SHIPPING_METHOD FF_SHIPPING_METHOD
, FF_CARRIER FF_CARRIER
, CONTENT_SOURCE CONTENT_SOURCE
, CC_CALL_STRATEGY CC_CALL_STRATEGY
, CC_MANAGER_USER_ID CC_MANAGER_USER_ID
, FORECASTED_REVENUE FORECASTED_REVENUE
, ACTUAL_REVENUE ACTUAL_REVENUE
, FORECASTED_COST FORECASTED_COST
, ACTUAL_COST ACTUAL_COST
, FORECASTED_RESPONSE FORECASTED_RESPONSE
, ACTUAL_RESPONSE ACTUAL_RESPONSE
, TARGET_RESPONSE TARGET_RESPONSE
, COUNTRY_CODE COUNTRY_CODE
, LANGUAGE_CODE LANGUAGE_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE15 ATTRIBUTE15
, VERSION_NO VERSION_NO
, CAMPAIGN_CALENDAR CAMPAIGN_CALENDAR
, START_PERIOD_NAME START_PERIOD_NAME
, END_PERIOD_NAME END_PERIOD_NAME
, CITY_ID CITY_ID
, GLOBAL_FLAG GLOBAL_FLAG
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, SHOW_CAMPAIGN_FLAG SHOW_CAMPAIGN_FLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, ACCOUNTS_CLOSED_FLAG ACCOUNTS_CLOSED_FLAG
, TASK_ID TASK_ID
, RELATED_EVENT_FROM RELATED_EVENT_FROM
, RELATED_EVENT_ID RELATED_EVENT_ID
, PROGRAM_ATTRIBUTE_CATEGORY PROGRAM_ATTRIBUTE_CATEGORY
, PROGRAM_ATTRIBUTE1 PROGRAM_ATTRIBUTE1
, PROGRAM_ATTRIBUTE2 PROGRAM_ATTRIBUTE2
, PROGRAM_ATTRIBUTE3 PROGRAM_ATTRIBUTE3
, PROGRAM_ATTRIBUTE4 PROGRAM_ATTRIBUTE4
, PROGRAM_ATTRIBUTE5 PROGRAM_ATTRIBUTE5
, PROGRAM_ATTRIBUTE6 PROGRAM_ATTRIBUTE6
, PROGRAM_ATTRIBUTE7 PROGRAM_ATTRIBUTE7
, PROGRAM_ATTRIBUTE8 PROGRAM_ATTRIBUTE8
, PROGRAM_ATTRIBUTE9 PROGRAM_ATTRIBUTE9
, PROGRAM_ATTRIBUTE10 PROGRAM_ATTRIBUTE10
, PROGRAM_ATTRIBUTE11 PROGRAM_ATTRIBUTE11
, PROGRAM_ATTRIBUTE12 PROGRAM_ATTRIBUTE12
, PROGRAM_ATTRIBUTE13 PROGRAM_ATTRIBUTE13
, PROGRAM_ATTRIBUTE14 PROGRAM_ATTRIBUTE14
, PROGRAM_ATTRIBUTE15 PROGRAM_ATTRIBUTE15
, ORIG_CUSTOM_SETUP_ID ORIG_CUSTOM_SETUP_ID
FROM "AMS"."AMS_CAMPAIGNS_ALL_B"