VIEW: AMS.AMS_CAMPAIGN_SCHEDULES_B#

Source

View Text - Preformatted

select SCHEDULE_ID SCHEDULE_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, CAMPAIGN_ID CAMPAIGN_ID, USER_STATUS_ID USER_STATUS_ID, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, SOURCE_CODE SOURCE_CODE, USE_PARENT_CODE_FLAG USE_PARENT_CODE_FLAG, START_DATE_TIME START_DATE_TIME, END_DATE_TIME END_DATE_TIME, TIMEZONE_ID TIMEZONE_ID, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, ACTIVITY_ID ACTIVITY_ID, ARC_MARKETING_MEDIUM_FROM ARC_MARKETING_MEDIUM_FROM, MARKETING_MEDIUM_ID MARKETING_MEDIUM_ID, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, TRIGGERABLE_FLAG TRIGGERABLE_FLAG, TRIGGER_ID TRIGGER_ID, NOTIFY_USER_ID NOTIFY_USER_ID, APPROVER_USER_ID APPROVER_USER_ID, OWNER_USER_ID OWNER_USER_ID, ACTIVE_FLAG ACTIVE_FLAG, COVER_LETTER_ID COVER_LETTER_ID, REPLY_TO_MAIL REPLY_TO_MAIL, MAIL_SENDER_NAME MAIL_SENDER_NAME, MAIL_SUBJECT MAIL_SUBJECT, FROM_FAX_NO FROM_FAX_NO, ACCOUNTS_CLOSED_FLAG ACCOUNTS_CLOSED_FLAG, ORG_ID ORG_ID, OBJECTIVE_CODE OBJECTIVE_CODE, COUNTRY_ID COUNTRY_ID, CAMPAIGN_CALENDAR CAMPAIGN_CALENDAR, START_PERIOD_NAME START_PERIOD_NAME, END_PERIOD_NAME END_PERIOD_NAME, PRIORITY PRIORITY, WORKFLOW_ITEM_KEY WORKFLOW_ITEM_KEY, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC, LANGUAGE_CODE LANGUAGE_CODE, TASK_ID TASK_ID, RELATED_EVENT_FROM RELATED_EVENT_FROM, RELATED_EVENT_ID RELATED_EVENT_ID, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, QUERY_ID QUERY_ID, INCLUDE_CONTENT_FLAG INCLUDE_CONTENT_FLAG, CONTENT_TYPE CONTENT_TYPE, TEST_EMAIL_ADDRESS TEST_EMAIL_ADDRESS, SOURCE_FROM_PARENT SOURCE_FROM_PARENT, TRIG_REPEAT_FLAG TRIG_REPEAT_FLAG, TGRP_EXCLUDE_PREV_FLAG TGRP_EXCLUDE_PREV_FLAG, ORIG_CSCH_ID ORIG_CSCH_ID, COVER_LETTER_VERSION COVER_LETTER_VERSION, LAST_ACTIVATION_DATE LAST_ACTIVATION_DATE, USAGE USAGE, PURPOSE PURPOSE, SALES_METHODOLOGY_ID SALES_METHODOLOGY_ID, LABEL_FND_ID LABEL_FND_ID, PRINTER_ADDRESS PRINTER_ADDRESS, REPEAT_WORKFLOW_ITEM_KEY REPEAT_WORKFLOW_ITEM_KEY, NOTIFY_ON_ACTIVATION_FLAG NOTIFY_ON_ACTIVATION_FLAG, ORIG_CUSTOM_SETUP_ID ORIG_CUSTOM_SETUP_ID, SENDER_DISPLAY_NAME SENDER_DISPLAY_NAME, DELIVERY_MODE DELIVERY_MODE from "AMS"."AMS_CAMPAIGN_SCHEDULES_B"

View Text - HTML Formatted

SELECT SCHEDULE_ID SCHEDULE_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
, CAMPAIGN_ID CAMPAIGN_ID
, USER_STATUS_ID USER_STATUS_ID
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, SOURCE_CODE SOURCE_CODE
, USE_PARENT_CODE_FLAG USE_PARENT_CODE_FLAG
, START_DATE_TIME START_DATE_TIME
, END_DATE_TIME END_DATE_TIME
, TIMEZONE_ID TIMEZONE_ID
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, ACTIVITY_ID ACTIVITY_ID
, ARC_MARKETING_MEDIUM_FROM ARC_MARKETING_MEDIUM_FROM
, MARKETING_MEDIUM_ID MARKETING_MEDIUM_ID
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, TRIGGERABLE_FLAG TRIGGERABLE_FLAG
, TRIGGER_ID TRIGGER_ID
, NOTIFY_USER_ID NOTIFY_USER_ID
, APPROVER_USER_ID APPROVER_USER_ID
, OWNER_USER_ID OWNER_USER_ID
, ACTIVE_FLAG ACTIVE_FLAG
, COVER_LETTER_ID COVER_LETTER_ID
, REPLY_TO_MAIL REPLY_TO_MAIL
, MAIL_SENDER_NAME MAIL_SENDER_NAME
, MAIL_SUBJECT MAIL_SUBJECT
, FROM_FAX_NO FROM_FAX_NO
, ACCOUNTS_CLOSED_FLAG ACCOUNTS_CLOSED_FLAG
, ORG_ID ORG_ID
, OBJECTIVE_CODE OBJECTIVE_CODE
, COUNTRY_ID COUNTRY_ID
, CAMPAIGN_CALENDAR CAMPAIGN_CALENDAR
, START_PERIOD_NAME START_PERIOD_NAME
, END_PERIOD_NAME END_PERIOD_NAME
, PRIORITY PRIORITY
, WORKFLOW_ITEM_KEY WORKFLOW_ITEM_KEY
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC
, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC
, LANGUAGE_CODE LANGUAGE_CODE
, TASK_ID TASK_ID
, RELATED_EVENT_FROM RELATED_EVENT_FROM
, RELATED_EVENT_ID RELATED_EVENT_ID
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, QUERY_ID QUERY_ID
, INCLUDE_CONTENT_FLAG INCLUDE_CONTENT_FLAG
, CONTENT_TYPE CONTENT_TYPE
, TEST_EMAIL_ADDRESS TEST_EMAIL_ADDRESS
, SOURCE_FROM_PARENT SOURCE_FROM_PARENT
, TRIG_REPEAT_FLAG TRIG_REPEAT_FLAG
, TGRP_EXCLUDE_PREV_FLAG TGRP_EXCLUDE_PREV_FLAG
, ORIG_CSCH_ID ORIG_CSCH_ID
, COVER_LETTER_VERSION COVER_LETTER_VERSION
, LAST_ACTIVATION_DATE LAST_ACTIVATION_DATE
, USAGE USAGE
, PURPOSE PURPOSE
, SALES_METHODOLOGY_ID SALES_METHODOLOGY_ID
, LABEL_FND_ID LABEL_FND_ID
, PRINTER_ADDRESS PRINTER_ADDRESS
, REPEAT_WORKFLOW_ITEM_KEY REPEAT_WORKFLOW_ITEM_KEY
, NOTIFY_ON_ACTIVATION_FLAG NOTIFY_ON_ACTIVATION_FLAG
, ORIG_CUSTOM_SETUP_ID ORIG_CUSTOM_SETUP_ID
, SENDER_DISPLAY_NAME SENDER_DISPLAY_NAME
, DELIVERY_MODE DELIVERY_MODE
FROM "AMS"."AMS_CAMPAIGN_SCHEDULES_B"