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

VIEW: APPS.AMS_P_CAMPAIGN_SCHEDS_V

Object Details
Object Name: AMS_P_CAMPAIGN_SCHEDS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_P_CAMPAIGN_SCHEDS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view will hold the general information for campaign schedules.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_SCHEDULE_ID NUMBER

Unique Identifier
CAMPAIGN_ID NUMBER

Campaign Identifier
CAMPAIGN_NAME VARCHAR2 (240)
Name of the campaign
CAMPAIGN_TYPE VARCHAR2 (30)
Campaign type
CAMPAIGN_SOURCE_CODE VARCHAR2 (30)
Campaign Source code
SCHEDULE_STATUS VARCHAR2 (80)
Current system status
STATUS_CODE VARCHAR2 (30)
Current system status code
STATUS_DATE DATE

Date when the status was last updated
USE_PARENT_CODE_FLAG VARCHAR2 (1)
Flag to indicate if the schedule's source code is copied from the campaign
SCHEDULE_SOURCE_CODE VARCHAR2 (30)
Schedule Source Code
ACTIVITY_TYPE_CODE VARCHAR2 (30)
Activity Type code for the schedule
ACTIVITY_TYPE VARCHAR2 (80)
Activit Type of the schedule.
ACTIVITY_ID NUMBER

Identifier of the Activity associated to the schedule.
ACTIVITY VARCHAR2 (120)
Activity associated to the schedule.
ARC_MARKETING_MEDIUM_FROM VARCHAR2 (30)
Code to indicate where the marketing medium mapped to.
MARKETING_MEDIUM_ID NUMBER

Identifier for the marketing medium associated to the schedule.
MARKETING_MEDIUM VARCHAR2 (120)
Marketing medium associated to the schedule.
FORECASTED_START_DATE_TIME VARCHAR2 (0)
Forecasted start date and time
FORECASTED_END_DATE_TIME VARCHAR2 (0)
Forecasted end date and time
START_PERIOD_NAME VARCHAR2 (15)
Starting period name within the campaign calendar
END_PERIOD_NAME VARCHAR2 (30)
End period name within the campaign calendar
ACTUAL_START_DATE_TIME DATE

Actual start date and time
ACTUAL_END_DATE_TIME DATE

Actual end date and time
TIMEZONE_ID NUMBER (15)
Identifier of the timezone for schedule
TIMEZONE VARCHAR2 (80)
Timezone for the schedule.
FREQUENCY VARCHAR2 (0)
Not being used anymore.
FREQUENCY_UOM_CODE VARCHAR2 (0)
Not being used anymore.
ACTIVITY_OFFER_ID VARCHAR2 (0)
Not being used anymore.
DELIVERABLE_ID VARCHAR2 (0)
Not being used anymore.
INBOUND_SCRIPT_NAME VARCHAR2 (0)
Not being used anymore.
INBOUND_URL VARCHAR2 (0)
Not being used anymore.
INBOUND_EMAIL_ID VARCHAR2 (0)
Not being used anymore.
INBOUND_PHONE_NO VARCHAR2 (0)
Not being used anymore.
OUTBOUND_SCRIPT_NAME VARCHAR2 (0)
Not being used anymore.
CHANNEL_ID VARCHAR2 (0)
Not being used anymore.
COVER_LETTER NUMBER

Cover letter
REPLYTO_MAIL_ID VARCHAR2 (120)
Reply to Email address.
MAIL_SENDER_NAME VARCHAR2 (120)
Sender email address.
MAIL_SUBJECT VARCHAR2 (240)
email subject.
FROM_FAX_NO VARCHAR2 (25)
From Fax number
CUSTOM_SETUP_ID NUMBER

Identifier of the setup with which the schedule is created.
TRIGGERABLE_FLAG VARCHAR2 (1)
Flag to indicate if the schedule is executed through trigger or not.
TRIGGER_ID NUMBER

Identifier for the trigger associated to the schedule.
NOTIFY_USER_ID NUMBER

Identifier of the person who should be notified when the trigger check is met.
APPROVER_USER_ID NUMBER

Identifier of the approver for the approval of the schedule.
OWNER_USER_ID NUMBER

Identifier of the Schedule Coordinator.
PRIORITY VARCHAR2 (30)
Priority code of the schedule.
TRANSACTION_CURRENCY_CODE VARCHAR2 (15)
Transaction currency code for schedule.
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Code for the functional currency of the schedule.
BUDGET_AMOUNT_TC NUMBER

Budget amount for the schedule in transaction currency.
BUDGET_AMOUNT_FC NUMBER

Budget amount for schedule in Functional currency.
LANGUAGE_CODE VARCHAR2 (4)
Code for the language of the schedule.
TASK_ID NUMBER

Identifier of the task associated to the schedule.
RELATED_EVENT_FROM VARCHAR2 (30)
Type of event schedule is promoting.
RELATED_EVENT_ID NUMBER

Identifier of the event schedule is promoting.
RELATED_EVENT_NAME VARCHAR2 (240)
Name of of the event schedule is promoting.
COUNTRY_ID NUMBER

Identifier for the country where the schedule is created.
DESCRIPTION VARCHAR2 (4000)
Description
Query Text

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


SELECT CAMPAIGN_SCHEDULE_ID
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      CAMPAIGN_TYPE
,      CAMPAIGN_SOURCE_CODE
,      SCHEDULE_STATUS
,      STATUS_CODE
,      STATUS_DATE
,      USE_PARENT_CODE_FLAG
,      SCHEDULE_SOURCE_CODE
,      ACTIVITY_TYPE_CODE
,      ACTIVITY_TYPE
,      ACTIVITY_ID
,      ACTIVITY
,      ARC_MARKETING_MEDIUM_FROM
,      MARKETING_MEDIUM_ID
,      MARKETING_MEDIUM
,      FORECASTED_START_DATE_TIME
,      FORECASTED_END_DATE_TIME
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      ACTUAL_START_DATE_TIME
,      ACTUAL_END_DATE_TIME
,      TIMEZONE_ID
,      TIMEZONE
,      FREQUENCY
,      FREQUENCY_UOM_CODE
,      ACTIVITY_OFFER_ID
,      DELIVERABLE_ID
,      INBOUND_SCRIPT_NAME
,      INBOUND_URL
,      INBOUND_EMAIL_ID
,      INBOUND_PHONE_NO
,      OUTBOUND_SCRIPT_NAME
,      CHANNEL_ID
,      COVER_LETTER
,      REPLYTO_MAIL_ID
,      MAIL_SENDER_NAME
,      MAIL_SUBJECT
,      FROM_FAX_NO
,      CUSTOM_SETUP_ID
,      TRIGGERABLE_FLAG
,      TRIGGER_ID
,      NOTIFY_USER_ID
,      APPROVER_USER_ID
,      OWNER_USER_ID
,      PRIORITY
,      TRANSACTION_CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      BUDGET_AMOUNT_TC
,      BUDGET_AMOUNT_FC
,      LANGUAGE_CODE
,      TASK_ID
,      RELATED_EVENT_FROM
,      RELATED_EVENT_ID
,      RELATED_EVENT_NAME
,      COUNTRY_ID
,      DESCRIPTION
FROM APPS.AMS_P_CAMPAIGN_SCHEDS_V;

Dependencies

[top of page]

APPS.AMS_P_CAMPAIGN_SCHEDS_V references the following:

SchemaAPPS
ViewAMS_CAMPAIGNS_VL
ViewAMS_CAMPAIGN_SCHEDULES_VL
SynonymAMS_CHANNELS_TL
ViewAMS_EVENT_OFFERS_VL
ViewAMS_LOOKUPS
SynonymAMS_MEDIA_TL
SynonymHZ_TIMEZONES_TL

APPS.AMS_P_CAMPAIGN_SCHEDS_V is not referenced by any database object