[Home] [Help] [Dependency Information]
Object Name: | AMS_P_CAMPAIGN_SCHEDS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_CAMPAIGN_SCHEDS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view will hold the general information for campaign schedules.
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 |
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;
APPS.AMS_P_CAMPAIGN_SCHEDS_V is not referenced by any database object
|
|
|