[Home] [Help] [Dependency Information]
Object Name: | IEO_CP_SVC_LISTS_ALL |
---|---|
Object Type: | TABLE |
Owner: | IEO |
FND Design Data: | IEO.IEO_CP_SVC_LISTS_ALL |
Subobject Name: | |
Status: | VALID |
Calling lists supported by CP services
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_SVC_LIST_ID | NUMBER | Yes | Primary key column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO field |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
LIST_NAME | VARCHAR2 | (30) | Yes | List name |
LIST_SRV_NAME | VARCHAR2 | (30) | Yes | List service in which this list is defined |
SREF_TYPE | VARCHAR2 | (5) | Yes | "S" |
CALENDAR_FILE | VARCHAR2 | (30) | Filename or other locator for list-specific calendar/scheduling file | |
CAL_ALG_TYPE | VARCHAR2 | (10) | Yes | Always "SCHEDULE" |
ORG_ID | NUMBER | (15) | Yes | Multi-org support |
LIST_RELEASE_STR | VARCHAR2 | (1000) | Boolean logic that permits records to be released from this list | |
QUEUE_FIRST_ENTRY | NUMBER | (9) | Pointer to first record of this list in .QLD | |
QUEUE_LAST_ENTRY | NUMBER | (9) | Pointer to last record of this list in .QLD | |
QUEUE_SCORE | NUMBER | (9) | Total score for this list (applies only to Scoring release strategies) | |
QUEUE_SCORE_CNT | NUMBER | (9) | Count of entries contributing to QUEUE_SCORE (applies only to Scoring) | |
QUEUE_CODE | NUMBER | (9) | Unique numeric identifier for this list in this service | |
QUEUE_PRIORITY | NUMBER | (9) | Release priority for this list (1-100) | |
QUEUE_STATUS | VARCHAR2 | (5) | "N" = new, "D" = deleted, "X" = deletion in process, "Y" = other | |
QUEUE_TYPE | VARCHAR2 | (5) | "O" = always open | |
RELEASE_STRATEGY | NUMBER | (9) | 1 = Quantum, 2 = Quota, 3 = Avg Score, 4 = Total Score | |
RELEASE_ARRAY_CNT | NUMBER | (9) | Number of minutes' of release statistical data available (1-60) | |
RELEASE_STOP_FLAG | VARCHAR2 | (5) | Obsolete | |
REMAIN_QUOTA | NUMBER | (9) | Remaining quota in this time period (only applies to Quota release strategy) | |
RANDOMIZE_FLAG | VARCHAR2 | (5) | Obsolete | |
RECYCLE_METHOD | VARCHAR2 | (30) | Obsolete | |
SHORT_DESCRIPTION | VARCHAR2 | (30) | Obsolete | |
SORT_KEY | NUMBER | (9) | Obsolete | |
CREATE_DT_TM | DATE | Obsolete | ||
CALL_TYPE_CODE | NUMBER | (9) | Obsolete | |
CTRL_LENGTH | NUMBER | (9) | Length of LIST_RELEASE_STR | |
DIALING_METHOD | VARCHAR2 | (20) | Obsolete | |
STOP_DT_TM | DATE | Obsolete | ||
SELECTION_CRITERIA | VARCHAR2 | (1000) | Obsolete | |
SORT_ORDER_MAP | VARCHAR2 | (1000) | Obsolete | |
SELECTION_PRIORITY | NUMBER | (9) | Selection (load) priority for this list (1-32K) | |
SCORE_RESET | NUMBER | (9) | Base score reset value (applies only to Scoring) | |
SORT_FIELD | VARCHAR2 | (240) | Columns by which list is to be sorted | |
SELECT_STRING_LEN | NUMBER | (9) | Length of LIST_SELECT_STR | |
TOTAL_RECORDS | NUMBER | (9) | Count of records in this list | |
NUM_SORT_KEYS | NUMBER | (9) | Number of columns used for record sorting | |
ORIGIN_OF_LIST | VARCHAR2 | (30) | Obsolete | |
VIEW_LIST_Y_N | VARCHAR2 | (5) | Obsolete | |
AUTO_REFRESH | NUMBER | (9) | Obsolete | |
LONG_DESCRIPTION | VARCHAR2 | (1000) | Obsolete | |
LIST_SORT_ORDER | VARCHAR2 | (1000) | Obsolete | |
PRD_EXHAUST | NUMBER | (9) | Obsolete | |
QUANTUM | NUMBER | (9) | Quantum of records to be released during one timeslice for this list | |
QUOTA | NUMBER | (9) | Number of records permitted to be released from this list under Quota release strategy | |
QUOTA_RESET | NUMBER | (9) | Time interval after which quota is to be reset (in minutes) (applies only to Quota release strategy) | |
DEFLT_RECYCLE_LIST | VARCHAR2 | (32) | List to which records from this list should be recycled, absent more specific info | |
TIMESTAMP_FLAG | VARCHAR2 | (5) | "Y"(es) if timestamps on records in this list are to be honored | |
DIALING_TYPE | NUMBER | (9) | 5 = Preview, 45 = Predictive | |
DT_PRD_EXHAUST | DATE | Predicted exhaustion date/time of this list | ||
DIALING_OPTIONS | VARCHAR2 | (128) | Options string transmitted to Predictive along with any record from this list | |
EXHAUST_AVAIL_FLAG | VARCHAR2 | (5) | Release records from this list, regardless of timestamp, if no other lists have releasable records | |
LIST_SELECT_STR | VARCHAR2 | (1000) | Boolean logic that qualifies records for inclusion in this list | |
LIST_MGR_LIST_Y_N | VARCHAR2 | (5) | "Y"(es) if list is to be processed by Campaign Plus | |
LIST_STATUS | VARCHAR2 | (5) | "O"(pen) or "C"(losed) | |
LIST_TYPE | VARCHAR2 | (30) | Campaign to which this list belongs | |
INDEX_SLOTS | NUMBER | (9) | Obsolete | |
TIMESTAMP_ACTUAL | VARCHAR2 | (5) | "Y"(es) if list contains timestamped records | |
SECURITY_GROUP_ID | NUMBER | (15) | Used in hosted environments | |
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
Cut, paste (and edit) the following text to query this object:
SELECT CP_SVC_LIST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LIST_NAME
, LIST_SRV_NAME
, SREF_TYPE
, CALENDAR_FILE
, CAL_ALG_TYPE
, ORG_ID
, LIST_RELEASE_STR
, QUEUE_FIRST_ENTRY
, QUEUE_LAST_ENTRY
, QUEUE_SCORE
, QUEUE_SCORE_CNT
, QUEUE_CODE
, QUEUE_PRIORITY
, QUEUE_STATUS
, QUEUE_TYPE
, RELEASE_STRATEGY
, RELEASE_ARRAY_CNT
, RELEASE_STOP_FLAG
, REMAIN_QUOTA
, RANDOMIZE_FLAG
, RECYCLE_METHOD
, SHORT_DESCRIPTION
, SORT_KEY
, CREATE_DT_TM
, CALL_TYPE_CODE
, CTRL_LENGTH
, DIALING_METHOD
, STOP_DT_TM
, SELECTION_CRITERIA
, SORT_ORDER_MAP
, SELECTION_PRIORITY
, SCORE_RESET
, SORT_FIELD
, SELECT_STRING_LEN
, TOTAL_RECORDS
, NUM_SORT_KEYS
, ORIGIN_OF_LIST
, VIEW_LIST_Y_N
, AUTO_REFRESH
, LONG_DESCRIPTION
, LIST_SORT_ORDER
, PRD_EXHAUST
, QUANTUM
, QUOTA
, QUOTA_RESET
, DEFLT_RECYCLE_LIST
, TIMESTAMP_FLAG
, DIALING_TYPE
, DT_PRD_EXHAUST
, DIALING_OPTIONS
, EXHAUST_AVAIL_FLAG
, LIST_SELECT_STR
, LIST_MGR_LIST_Y_N
, LIST_STATUS
, LIST_TYPE
, INDEX_SLOTS
, TIMESTAMP_ACTUAL
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_SVC_LISTS_ALL;
IEO.IEO_CP_SVC_LISTS_ALL does not reference any database object
IEO.IEO_CP_SVC_LISTS_ALL is referenced by following:
|
|
|