[Home] [Help] [Dependency Information]
Object Name: | IEC_G_SCHEDULES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View created to retrieve only campaign activities that have been assigned Advanced Outbound.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ID | NUMBER | Yes | SCHEDULE_ID | |
SCHEDULE_NAME | VARCHAR2 | (240) | Yes | SCHEDULE_NAME |
DESCRIPTION | VARCHAR2 | (4000) | DESCRIPTION | |
USER_STATUS_ID | NUMBER | Yes | USER_STATUS_ID | |
STATUS_CODE | VARCHAR2 | (30) | Yes | STATUS_CODE |
ACTIVITY_ID | NUMBER | ACTIVITY_ID | ||
CALENDAR_ID | VARCHAR2 | (150) | CALENDAR_ID | |
RECYCLING_ALGORITHM_ID | VARCHAR2 | (150) | RECYCLING_ALGORITHM_ID | |
RELEASE_ALGORITHM_ID | VARCHAR2 | (150) | RELEASE_ALGORITHM_ID | |
DIALING_METHOD | VARCHAR2 | (150) | DIALING_METHOD | |
ABANDON_LIMIT | VARCHAR2 | (150) | ABANDON_LIMIT | |
CALL_CENTER_READY_FLAG | VARCHAR2 | (150) | CALL_CENTER_READY_FLAG | |
PREDICTIVE_PACING_CLASS | VARCHAR2 | (150) | PREDICTIVE_PACING_CLASS | |
PREDICTIVE_TIMEOUT | VARCHAR2 | (150) | PREDICTIVE_TIMEOUT | |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | ACTIVE_FLAG |
SOURCE_CODE | VARCHAR2 | (30) | Yes | SOURCE_CODE |
START_DATE_TIME | DATE | START_DATE_TIME | ||
END_DATE_TIME | DATE | END_DATE_TIME | ||
CAMPAIGN_ID | NUMBER | Yes | CAMPAIGN_ID | |
CAMPAIGN_NAME | VARCHAR2 | (240) | Yes | CAMPAIGN_NAME |
MARKETING_MEDIUM_ID | NUMBER | MARKETING_MEDIUM_ID | ||
LAST_UPDATE_DATE | DATE | Yes | LAST_UPDATE_DATE | |
LAST_UPDATE_BY | NUMBER | (15) | Yes | LAST_UPDATE_BY |
CREATION_DATE | DATE | Yes | CREATION_DATE | |
CREATED_BY | NUMBER | (15) | Yes | CREATED_BY |
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | OBJECT_VERSION_NUMBER | |
OWNER_USER_ID | NUMBER | Yes | OWNER_USER_ID | |
LANGUAGE | VARCHAR2 | (4) | Yes | LANGUAGE |
NAME | VARCHAR2 | (120) | NAME |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_ID
, SCHEDULE_NAME
, DESCRIPTION
, USER_STATUS_ID
, STATUS_CODE
, ACTIVITY_ID
, CALENDAR_ID
, RECYCLING_ALGORITHM_ID
, RELEASE_ALGORITHM_ID
, DIALING_METHOD
, ABANDON_LIMIT
, CALL_CENTER_READY_FLAG
, PREDICTIVE_PACING_CLASS
, PREDICTIVE_TIMEOUT
, ACTIVE_FLAG
, SOURCE_CODE
, START_DATE_TIME
, END_DATE_TIME
, CAMPAIGN_ID
, CAMPAIGN_NAME
, MARKETING_MEDIUM_ID
, LAST_UPDATE_DATE
, LAST_UPDATE_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, OWNER_USER_ID
, LANGUAGE
, NAME
FROM APPS.IEC_G_SCHEDULES_V;
|
|
|