VIEW: APPS.AMS_CAMPAIGN_SCHEDULES_VL

Source

View Text - Preformatted

SELECT b.rowid row_id , b.SCHEDULE_ID , b.LAST_UPDATE_DATE , b.LAST_UPDATED_BY, b.CREATION_DATE , b.CREATED_BY , b.LAST_UPDATE_LOGIN , b.OBJECT_VERSION_NUMBER , b.CAMPAIGN_ID , b.USER_STATUS_ID , b.STATUS_CODE , b.STATUS_DATE , b.SOURCE_CODE , b.USE_PARENT_CODE_FLAG , b.START_DATE_TIME , b.END_DATE_TIME , b.TIMEZONE_ID , b.ACTIVITY_TYPE_CODE , b.ACTIVITY_ID , b.ARC_MARKETING_MEDIUM_FROM , b.MARKETING_MEDIUM_ID , b.CUSTOM_SETUP_ID , b.TRIGGERABLE_FLAG , b.TRIGGER_ID , b.NOTIFY_USER_ID , b.APPROVER_USER_ID , b.OWNER_USER_ID , b.ACTIVE_FLAG , b.COVER_LETTER_ID , b.REPLY_TO_MAIL , b.MAIL_SENDER_NAME , b.MAIL_SUBJECT , b.FROM_FAX_NO , b.ACCOUNTS_CLOSED_FLAG , b.ORG_ID , b.OBJECTIVE_CODE , b.COUNTRY_ID , b.CAMPAIGN_CALENDAR , b.START_PERIOD_NAME , b.END_PERIOD_NAME , b.PRIORITY , b.WORKFLOW_ITEM_KEY , b.TRANSACTION_CURRENCY_CODE , b.FUNCTIONAL_CURRENCY_CODE , b.BUDGET_AMOUNT_TC , b.BUDGET_AMOUNT_FC , b.LANGUAGE_CODE , b.TASK_ID , b.RELATED_EVENT_FROM , b.RELATED_EVENT_ID , b.ATTRIBUTE_CATEGORY , b.ATTRIBUTE1 , b.ATTRIBUTE2 , b.ATTRIBUTE3 , b.ATTRIBUTE4 , b.ATTRIBUTE5 , b.ATTRIBUTE6 , b.ATTRIBUTE7 , b.ATTRIBUTE8 , b.ATTRIBUTE9 , b.ATTRIBUTE10 , b.ATTRIBUTE11 , b.ATTRIBUTE12, b.ATTRIBUTE13 , b.ATTRIBUTE14 , b.ATTRIBUTE15 , b.ACTIVITY_ATTRIBUTE_CATEGORY , b.ACTIVITY_ATTRIBUTE1 , b.ACTIVITY_ATTRIBUTE2 , b.ACTIVITY_ATTRIBUTE3 , b.ACTIVITY_ATTRIBUTE4 , b.ACTIVITY_ATTRIBUTE5 , b.ACTIVITY_ATTRIBUTE6 , b.ACTIVITY_ATTRIBUTE7 , b.ACTIVITY_ATTRIBUTE8 , b.ACTIVITY_ATTRIBUTE9 , b.ACTIVITY_ATTRIBUTE10 , b.ACTIVITY_ATTRIBUTE11 , b.ACTIVITY_ATTRIBUTE12 , b.ACTIVITY_ATTRIBUTE13 , b.ACTIVITY_ATTRIBUTE14 , b.ACTIVITY_ATTRIBUTE15 , b.QUERY_ID , b.INCLUDE_CONTENT_FLAG , b.CONTENT_TYPE , b.TEST_EMAIL_ADDRESS , t.SCHEDULE_NAME , t.DESCRIPTION , t.GREETING_TEXT , t.FOOTER_TEXT , b.TRIG_REPEAT_FLAG , b.TGRP_EXCLUDE_PREV_FLAG , b.ORIG_CSCH_ID , b.COVER_LETTER_VERSION, b.LAST_ACTIVATION_DATE, b.USAGE, b.PURPOSE, b.SALES_METHODOLOGY_ID, b.LABEL_FND_ID, b.PRINTER_ADDRESS, b.REPEAT_WORKFLOW_ITEM_KEY, b.notify_on_activation_flag, b.orig_custom_setup_id, b.sender_display_name, b.delivery_mode FROM ams_campaign_schedules_b b, ams_campaign_schedules_tl t WHERE B.schedule_iD = T.schedule_id AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.SCHEDULE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.CAMPAIGN_ID
, B.USER_STATUS_ID
, B.STATUS_CODE
, B.STATUS_DATE
, B.SOURCE_CODE
, B.USE_PARENT_CODE_FLAG
, B.START_DATE_TIME
, B.END_DATE_TIME
, B.TIMEZONE_ID
, B.ACTIVITY_TYPE_CODE
, B.ACTIVITY_ID
, B.ARC_MARKETING_MEDIUM_FROM
, B.MARKETING_MEDIUM_ID
, B.CUSTOM_SETUP_ID
, B.TRIGGERABLE_FLAG
, B.TRIGGER_ID
, B.NOTIFY_USER_ID
, B.APPROVER_USER_ID
, B.OWNER_USER_ID
, B.ACTIVE_FLAG
, B.COVER_LETTER_ID
, B.REPLY_TO_MAIL
, B.MAIL_SENDER_NAME
, B.MAIL_SUBJECT
, B.FROM_FAX_NO
, B.ACCOUNTS_CLOSED_FLAG
, B.ORG_ID
, B.OBJECTIVE_CODE
, B.COUNTRY_ID
, B.CAMPAIGN_CALENDAR
, B.START_PERIOD_NAME
, B.END_PERIOD_NAME
, B.PRIORITY
, B.WORKFLOW_ITEM_KEY
, B.TRANSACTION_CURRENCY_CODE
, B.FUNCTIONAL_CURRENCY_CODE
, B.BUDGET_AMOUNT_TC
, B.BUDGET_AMOUNT_FC
, B.LANGUAGE_CODE
, B.TASK_ID
, B.RELATED_EVENT_FROM
, B.RELATED_EVENT_ID
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ACTIVITY_ATTRIBUTE_CATEGORY
, B.ACTIVITY_ATTRIBUTE1
, B.ACTIVITY_ATTRIBUTE2
, B.ACTIVITY_ATTRIBUTE3
, B.ACTIVITY_ATTRIBUTE4
, B.ACTIVITY_ATTRIBUTE5
, B.ACTIVITY_ATTRIBUTE6
, B.ACTIVITY_ATTRIBUTE7
, B.ACTIVITY_ATTRIBUTE8
, B.ACTIVITY_ATTRIBUTE9
, B.ACTIVITY_ATTRIBUTE10
, B.ACTIVITY_ATTRIBUTE11
, B.ACTIVITY_ATTRIBUTE12
, B.ACTIVITY_ATTRIBUTE13
, B.ACTIVITY_ATTRIBUTE14
, B.ACTIVITY_ATTRIBUTE15
, B.QUERY_ID
, B.INCLUDE_CONTENT_FLAG
, B.CONTENT_TYPE
, B.TEST_EMAIL_ADDRESS
, T.SCHEDULE_NAME
, T.DESCRIPTION
, T.GREETING_TEXT
, T.FOOTER_TEXT
, B.TRIG_REPEAT_FLAG
, B.TGRP_EXCLUDE_PREV_FLAG
, B.ORIG_CSCH_ID
, B.COVER_LETTER_VERSION
, B.LAST_ACTIVATION_DATE
, B.USAGE
, B.PURPOSE
, B.SALES_METHODOLOGY_ID
, B.LABEL_FND_ID
, B.PRINTER_ADDRESS
, B.REPEAT_WORKFLOW_ITEM_KEY
, B.NOTIFY_ON_ACTIVATION_FLAG
, B.ORIG_CUSTOM_SETUP_ID
, B.SENDER_DISPLAY_NAME
, B.DELIVERY_MODE
FROM AMS_CAMPAIGN_SCHEDULES_B B
, AMS_CAMPAIGN_SCHEDULES_TL T
WHERE B.SCHEDULE_ID = T.SCHEDULE_ID
AND T.LANGUAGE = USERENV('LANG')