DBA Data[Home] [Help] [Dependency Information]

VIEW: AMS.AMS_CAMPAIGN_SCHEDULES_B#

Object Details
Object Name: AMS_CAMPAIGN_SCHEDULES_B#
Object Type: VIEW
Owner: AMS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
CAMPAIGN_ID NUMBER
Yes
USER_STATUS_ID NUMBER
Yes
STATUS_CODE VARCHAR2 (30) Yes
STATUS_DATE DATE
Yes
SOURCE_CODE VARCHAR2 (30) Yes
USE_PARENT_CODE_FLAG VARCHAR2 (1) Yes
START_DATE_TIME DATE

END_DATE_TIME DATE

TIMEZONE_ID NUMBER (15)
ACTIVITY_TYPE_CODE VARCHAR2 (30) Yes
ACTIVITY_ID NUMBER

ARC_MARKETING_MEDIUM_FROM VARCHAR2 (30)
MARKETING_MEDIUM_ID NUMBER

CUSTOM_SETUP_ID NUMBER
Yes
TRIGGERABLE_FLAG VARCHAR2 (1) Yes
TRIGGER_ID NUMBER

NOTIFY_USER_ID NUMBER

APPROVER_USER_ID NUMBER

OWNER_USER_ID NUMBER
Yes
ACTIVE_FLAG VARCHAR2 (1) Yes
COVER_LETTER_ID NUMBER

REPLY_TO_MAIL VARCHAR2 (120)
MAIL_SENDER_NAME VARCHAR2 (120)
MAIL_SUBJECT VARCHAR2 (240)
FROM_FAX_NO VARCHAR2 (25)
ACCOUNTS_CLOSED_FLAG VARCHAR2 (1) Yes
ORG_ID NUMBER (32)
OBJECTIVE_CODE VARCHAR2 (30)
COUNTRY_ID NUMBER
Yes
CAMPAIGN_CALENDAR VARCHAR2 (20)
START_PERIOD_NAME VARCHAR2 (15)
END_PERIOD_NAME VARCHAR2 (30)
PRIORITY VARCHAR2 (30)
WORKFLOW_ITEM_KEY VARCHAR2 (240)
TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
BUDGET_AMOUNT_TC NUMBER

BUDGET_AMOUNT_FC NUMBER

LANGUAGE_CODE VARCHAR2 (4)
TASK_ID NUMBER

RELATED_EVENT_FROM VARCHAR2 (30)
RELATED_EVENT_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE_CATEGORY VARCHAR2 (240)
ACTIVITY_ATTRIBUTE1 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE2 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE3 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE4 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE5 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE6 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE7 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE8 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE9 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE10 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE11 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE12 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE13 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE14 VARCHAR2 (150)
ACTIVITY_ATTRIBUTE15 VARCHAR2 (150)
SECURITY_GROUP_ID NUMBER

QUERY_ID NUMBER

INCLUDE_CONTENT_FLAG VARCHAR2 (1)
CONTENT_TYPE VARCHAR2 (30)
TEST_EMAIL_ADDRESS VARCHAR2 (150)
SOURCE_FROM_PARENT VARCHAR2 (1)
TRIG_REPEAT_FLAG VARCHAR2 (1)
TGRP_EXCLUDE_PREV_FLAG VARCHAR2 (1)
ORIG_CSCH_ID NUMBER

COVER_LETTER_VERSION NUMBER

LAST_ACTIVATION_DATE DATE

USAGE VARCHAR2 (30)
PURPOSE VARCHAR2 (30)
SALES_METHODOLOGY_ID NUMBER

LABEL_FND_ID NUMBER

PRINTER_ADDRESS VARCHAR2 (255)
REPEAT_WORKFLOW_ITEM_KEY VARCHAR2 (240)
NOTIFY_ON_ACTIVATION_FLAG VARCHAR2 (1)
ORIG_CUSTOM_SETUP_ID NUMBER

SENDER_DISPLAY_NAME VARCHAR2 (240)
DELIVERY_MODE VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AMS.AMS_CAMPAIGN_SCHEDULES_B# references the following:

SchemaAMS
TableAMS_CAMPAIGN_SCHEDULES_B
AMS.AMS_CAMPAIGN_SCHEDULES_B# is referenced by following:

SchemaAPPS
SynonymAMS_CAMPAIGN_SCHEDULES_B