[Home] [Help] [Dependency Information]
Object Name: | IEO_CP_SVC_LISTS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | IEO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_SVC_LIST_ID | NUMBER | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LIST_NAME | VARCHAR2 | (30) | Yes | |
LIST_SRV_NAME | VARCHAR2 | (30) | Yes | |
SREF_TYPE | VARCHAR2 | (5) | Yes | |
CALENDAR_FILE | VARCHAR2 | (30) | ||
CAL_ALG_TYPE | VARCHAR2 | (10) | Yes | |
ORG_ID | NUMBER | (15) | Yes | |
LIST_RELEASE_STR | VARCHAR2 | (1000) | ||
QUEUE_FIRST_ENTRY | NUMBER | (9) | ||
QUEUE_LAST_ENTRY | NUMBER | (9) | ||
QUEUE_SCORE | NUMBER | (9) | ||
QUEUE_SCORE_CNT | NUMBER | (9) | ||
QUEUE_CODE | NUMBER | (9) | ||
QUEUE_PRIORITY | NUMBER | (9) | ||
QUEUE_STATUS | VARCHAR2 | (5) | ||
QUEUE_TYPE | VARCHAR2 | (5) | ||
RELEASE_STRATEGY | NUMBER | (9) | ||
RELEASE_ARRAY_CNT | NUMBER | (9) | ||
RELEASE_STOP_FLAG | VARCHAR2 | (5) | ||
REMAIN_QUOTA | NUMBER | (9) | ||
RANDOMIZE_FLAG | VARCHAR2 | (5) | ||
RECYCLE_METHOD | VARCHAR2 | (30) | ||
SHORT_DESCRIPTION | VARCHAR2 | (30) | ||
SORT_KEY | NUMBER | (9) | ||
CREATE_DT_TM | DATE | |||
CALL_TYPE_CODE | NUMBER | (9) | ||
CTRL_LENGTH | NUMBER | (9) | ||
DIALING_METHOD | VARCHAR2 | (20) | ||
STOP_DT_TM | DATE | |||
SELECTION_CRITERIA | VARCHAR2 | (1000) | ||
SORT_ORDER_MAP | VARCHAR2 | (1000) | ||
SELECTION_PRIORITY | NUMBER | (9) | ||
SCORE_RESET | NUMBER | (9) | ||
SORT_FIELD | VARCHAR2 | (240) | ||
SELECT_STRING_LEN | NUMBER | (9) | ||
TOTAL_RECORDS | NUMBER | (9) | ||
NUM_SORT_KEYS | NUMBER | (9) | ||
ORIGIN_OF_LIST | VARCHAR2 | (30) | ||
VIEW_LIST_Y_N | VARCHAR2 | (5) | ||
AUTO_REFRESH | NUMBER | (9) | ||
LONG_DESCRIPTION | VARCHAR2 | (1000) | ||
LIST_SORT_ORDER | VARCHAR2 | (1000) | ||
PRD_EXHAUST | NUMBER | (9) | ||
QUANTUM | NUMBER | (9) | ||
QUOTA | NUMBER | (9) | ||
QUOTA_RESET | NUMBER | (9) | ||
DEFLT_RECYCLE_LIST | VARCHAR2 | (32) | ||
TIMESTAMP_FLAG | VARCHAR2 | (5) | ||
DIALING_TYPE | NUMBER | (9) | ||
DT_PRD_EXHAUST | DATE | |||
DIALING_OPTIONS | VARCHAR2 | (128) | ||
EXHAUST_AVAIL_FLAG | VARCHAR2 | (5) | ||
LIST_SELECT_STR | VARCHAR2 | (1000) | ||
LIST_MGR_LIST_Y_N | VARCHAR2 | (5) | ||
LIST_STATUS | VARCHAR2 | (5) | ||
LIST_TYPE | VARCHAR2 | (30) | ||
INDEX_SLOTS | NUMBER | (9) | ||
TIMESTAMP_ACTUAL | VARCHAR2 | (5) | ||
SECURITY_GROUP_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER |
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#;
|
|
|