[Home] [Help]
[Dependency Information]
[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#;
IEO
IEO_CP_SVC_LISTS_ALL
APPS
IEO_CP_SVC_LISTS_ALL
|
|
|
|