VIEW: AMS.AMS_ADI_CAMPAIGNS_INTERFACE#

Source

View Text - Preformatted

select UPLOAD_BATCH_ID UPLOAD_BATCH_ID, OPERATION_TYPE OPERATION_TYPE, OPERATION_STATUS OPERATION_STATUS, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, OBJECT_NAME OBJECT_NAME, SOURCE_CODE SOURCE_CODE, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE, PARENT_OBJECT_ID PARENT_OBJECT_ID, ERROR_MESSAGE ERROR_MESSAGE, UI_INSTANCE_ID UI_INSTANCE_ID, START_DATE START_DATE, END_DATE END_DATE, START_TIME START_TIME, END_TIME END_TIME, TIME_FORMAT TIME_FORMAT, TEMPLATE_ID TEMPLATE_ID, ACTIVITY_ID ACTIVITY_ID, ACTUAL_ACTIVITY_ID ACTUAL_ACTIVITY_ID, MARKETING_MEDIUM_ID MARKETING_MEDIUM_ID, PURPOSE PURPOSE, COUNTRY_ID COUNTRY_ID, OWNER_USER_ID OWNER_USER_ID, TIMEZONE_ID TIMEZONE_ID, CURRENCY_CODE CURRENCY_CODE, OBJECTIVE OBJECTIVE, APPROVAL_ACTION_CODE APPROVAL_ACTION_CODE, USER_STATUS_ID USER_STATUS_ID, STATUS_CODE STATUS_CODE, REP_SCHED_FREQ_CODE REP_SCHED_FREQ_CODE, REP_SCHED_FREQUENCY REP_SCHED_FREQUENCY, REP_SCHED_TG_EXCLUDE_FLAG REP_SCHED_TG_EXCLUDE_FLAG, PRODUCT_ID1 PRODUCT_ID1, PRODUCT_ID2 PRODUCT_ID2, PRODUCT_CATEGORY_ID1 PRODUCT_CATEGORY_ID1, PRODUCT_CATEGORY_ID2 PRODUCT_CATEGORY_ID2, COVER_LETTER_ID COVER_LETTER_ID, COLLAB_CITEM_ID1 COLLAB_CITEM_ID1, COLLAB_CITEM_ID2 COLLAB_CITEM_ID2, COLLAB_CITEM_ID3 COLLAB_CITEM_ID3, COLLAB_SCRIPT_ID COLLAB_SCRIPT_ID, NOTES NOTES, PRETTY_URL_WEBSITE PRETTY_URL_WEBSITE, ADDITIONAL_URL_PARAM ADDITIONAL_URL_PARAM, WP_APPLICATION_ID WP_APPLICATION_ID, WP_PLACEMENT_ID WP_PLACEMENT_ID, WP_PLACEMENT_TITLE WP_PLACEMENT_TITLE, WP_CITEM_ID WP_CITEM_ID, CTD_ACTION CTD_ACTION, CTD_URL_TEXT CTD_URL_TEXT, CTD_PARAM1 CTD_PARAM1, CTD_PARAM2 CTD_PARAM2, CTD_PARAM3 CTD_PARAM3, CTD_PARAM4 CTD_PARAM4, CTD_ADHOC_PARAM1 CTD_ADHOC_PARAM1, CTD_ADHOC_PARAM_VAL1 CTD_ADHOC_PARAM_VAL1, CTD_ADHOC_PARAM2 CTD_ADHOC_PARAM2, CTD_ADHOC_PARAM_VAL2 CTD_ADHOC_PARAM_VAL2, CTD_ADHOC_PARAM3 CTD_ADHOC_PARAM3, CTD_ADHOC_PARAM_VAL3 CTD_ADHOC_PARAM_VAL3, CTD_ADHOC_PARAM4 CTD_ADHOC_PARAM4, CTD_ADHOC_PARAM_VAL4 CTD_ADHOC_PARAM_VAL4, CTD_ADHOC_PARAM5 CTD_ADHOC_PARAM5, CTD_ADHOC_PARAM_VAL5 CTD_ADHOC_PARAM_VAL5, 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, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ACTIVITY_ATTRIBUTE_CATEGORY ACTIVITY_ATTRIBUTE_CATEGORY, ACTIVITY_ATTRIBUTE1 ACTIVITY_ATTRIBUTE1, ACTIVITY_ATTRIBUTE2 ACTIVITY_ATTRIBUTE2, ACTIVITY_ATTRIBUTE3 ACTIVITY_ATTRIBUTE3, ACTIVITY_ATTRIBUTE4 ACTIVITY_ATTRIBUTE4, ACTIVITY_ATTRIBUTE5 ACTIVITY_ATTRIBUTE5, ACTIVITY_ATTRIBUTE6 ACTIVITY_ATTRIBUTE6, ACTIVITY_ATTRIBUTE7 ACTIVITY_ATTRIBUTE7, ACTIVITY_ATTRIBUTE8 ACTIVITY_ATTRIBUTE8, ACTIVITY_ATTRIBUTE9 ACTIVITY_ATTRIBUTE9, ACTIVITY_ATTRIBUTE10 ACTIVITY_ATTRIBUTE10, ACTIVITY_ATTRIBUTE11 ACTIVITY_ATTRIBUTE11, ACTIVITY_ATTRIBUTE12 ACTIVITY_ATTRIBUTE12, ACTIVITY_ATTRIBUTE13 ACTIVITY_ATTRIBUTE13, ACTIVITY_ATTRIBUTE14 ACTIVITY_ATTRIBUTE14, ACTIVITY_ATTRIBUTE15 ACTIVITY_ATTRIBUTE15, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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 from "AMS"."AMS_ADI_CAMPAIGNS_INTERFACE"

View Text - HTML Formatted

SELECT UPLOAD_BATCH_ID UPLOAD_BATCH_ID
, OPERATION_TYPE OPERATION_TYPE
, OPERATION_STATUS OPERATION_STATUS
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, OBJECT_NAME OBJECT_NAME
, SOURCE_CODE SOURCE_CODE
, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE
, PARENT_OBJECT_ID PARENT_OBJECT_ID
, ERROR_MESSAGE ERROR_MESSAGE
, UI_INSTANCE_ID UI_INSTANCE_ID
, START_DATE START_DATE
, END_DATE END_DATE
, START_TIME START_TIME
, END_TIME END_TIME
, TIME_FORMAT TIME_FORMAT
, TEMPLATE_ID TEMPLATE_ID
, ACTIVITY_ID ACTIVITY_ID
, ACTUAL_ACTIVITY_ID ACTUAL_ACTIVITY_ID
, MARKETING_MEDIUM_ID MARKETING_MEDIUM_ID
, PURPOSE PURPOSE
, COUNTRY_ID COUNTRY_ID
, OWNER_USER_ID OWNER_USER_ID
, TIMEZONE_ID TIMEZONE_ID
, CURRENCY_CODE CURRENCY_CODE
, OBJECTIVE OBJECTIVE
, APPROVAL_ACTION_CODE APPROVAL_ACTION_CODE
, USER_STATUS_ID USER_STATUS_ID
, STATUS_CODE STATUS_CODE
, REP_SCHED_FREQ_CODE REP_SCHED_FREQ_CODE
, REP_SCHED_FREQUENCY REP_SCHED_FREQUENCY
, REP_SCHED_TG_EXCLUDE_FLAG REP_SCHED_TG_EXCLUDE_FLAG
, PRODUCT_ID1 PRODUCT_ID1
, PRODUCT_ID2 PRODUCT_ID2
, PRODUCT_CATEGORY_ID1 PRODUCT_CATEGORY_ID1
, PRODUCT_CATEGORY_ID2 PRODUCT_CATEGORY_ID2
, COVER_LETTER_ID COVER_LETTER_ID
, COLLAB_CITEM_ID1 COLLAB_CITEM_ID1
, COLLAB_CITEM_ID2 COLLAB_CITEM_ID2
, COLLAB_CITEM_ID3 COLLAB_CITEM_ID3
, COLLAB_SCRIPT_ID COLLAB_SCRIPT_ID
, NOTES NOTES
, PRETTY_URL_WEBSITE PRETTY_URL_WEBSITE
, ADDITIONAL_URL_PARAM ADDITIONAL_URL_PARAM
, WP_APPLICATION_ID WP_APPLICATION_ID
, WP_PLACEMENT_ID WP_PLACEMENT_ID
, WP_PLACEMENT_TITLE WP_PLACEMENT_TITLE
, WP_CITEM_ID WP_CITEM_ID
, CTD_ACTION CTD_ACTION
, CTD_URL_TEXT CTD_URL_TEXT
, CTD_PARAM1 CTD_PARAM1
, CTD_PARAM2 CTD_PARAM2
, CTD_PARAM3 CTD_PARAM3
, CTD_PARAM4 CTD_PARAM4
, CTD_ADHOC_PARAM1 CTD_ADHOC_PARAM1
, CTD_ADHOC_PARAM_VAL1 CTD_ADHOC_PARAM_VAL1
, CTD_ADHOC_PARAM2 CTD_ADHOC_PARAM2
, CTD_ADHOC_PARAM_VAL2 CTD_ADHOC_PARAM_VAL2
, CTD_ADHOC_PARAM3 CTD_ADHOC_PARAM3
, CTD_ADHOC_PARAM_VAL3 CTD_ADHOC_PARAM_VAL3
, CTD_ADHOC_PARAM4 CTD_ADHOC_PARAM4
, CTD_ADHOC_PARAM_VAL4 CTD_ADHOC_PARAM_VAL4
, CTD_ADHOC_PARAM5 CTD_ADHOC_PARAM5
, CTD_ADHOC_PARAM_VAL5 CTD_ADHOC_PARAM_VAL5
, 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
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ACTIVITY_ATTRIBUTE_CATEGORY ACTIVITY_ATTRIBUTE_CATEGORY
, ACTIVITY_ATTRIBUTE1 ACTIVITY_ATTRIBUTE1
, ACTIVITY_ATTRIBUTE2 ACTIVITY_ATTRIBUTE2
, ACTIVITY_ATTRIBUTE3 ACTIVITY_ATTRIBUTE3
, ACTIVITY_ATTRIBUTE4 ACTIVITY_ATTRIBUTE4
, ACTIVITY_ATTRIBUTE5 ACTIVITY_ATTRIBUTE5
, ACTIVITY_ATTRIBUTE6 ACTIVITY_ATTRIBUTE6
, ACTIVITY_ATTRIBUTE7 ACTIVITY_ATTRIBUTE7
, ACTIVITY_ATTRIBUTE8 ACTIVITY_ATTRIBUTE8
, ACTIVITY_ATTRIBUTE9 ACTIVITY_ATTRIBUTE9
, ACTIVITY_ATTRIBUTE10 ACTIVITY_ATTRIBUTE10
, ACTIVITY_ATTRIBUTE11 ACTIVITY_ATTRIBUTE11
, ACTIVITY_ATTRIBUTE12 ACTIVITY_ATTRIBUTE12
, ACTIVITY_ATTRIBUTE13 ACTIVITY_ATTRIBUTE13
, ACTIVITY_ATTRIBUTE14 ACTIVITY_ATTRIBUTE14
, ACTIVITY_ATTRIBUTE15 ACTIVITY_ATTRIBUTE15
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
FROM "AMS"."AMS_ADI_CAMPAIGNS_INTERFACE"