[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IEO_CP_SERVICES_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | IEO |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CP_SERVICE_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) | ||
| SREF_TYPE | VARCHAR2 | (5) | Yes | |
| LIST_SRV_NAME | VARCHAR2 | (30) | Yes | |
| RECYCLING_METHOD | VARCHAR2 | (30) | ||
| CALENDAR_FILE | VARCHAR2 | (128) | Yes | |
| CAL_ALG_TYPE | VARCHAR2 | (10) | Yes | |
| RCY_ALG_TYPE | VARCHAR2 | (10) | Yes | |
| ORG_ID | NUMBER | (15) | Yes | |
| REORG_RECHECK_FLG | VARCHAR2 | (5) | ||
| REORG_DATE | DATE | |||
| REVISION | NUMBER | (9) | ||
| REORG_FLAG | VARCHAR2 | (5) | ||
| STOP_LIST_LD_FLAG | VARCHAR2 | (5) | ||
| SEND_ORIG_LIST_FLG | VARCHAR2 | (5) | ||
| SCRIPT_NAME | VARCHAR2 | (32) | ||
| SQL_SELECT_STR | VARCHAR2 | (1000) | ||
| STOP_CNTCT_CH_FLAG | VARCHAR2 | (5) | ||
| T2PM | NUMBER | (9) | ||
| T3PM | NUMBER | (9) | ||
| T30_MIN | NUMBER | (9) | ||
| T4PM | NUMBER | (9) | ||
| T5PM | NUMBER | (9) | ||
| T5_MIN | NUMBER | (9) | ||
| T6PM | NUMBER | (9) | ||
| T60_MIN | NUMBER | (9) | ||
| T7PM | NUMBER | (9) | ||
| T8PM | NUMBER | (9) | ||
| T9PM | NUMBER | (9) | ||
| T10PM | NUMBER | (9) | ||
| T10_MIN | NUMBER | (9) | ||
| T10AM | NUMBER | (9) | ||
| T11PM | NUMBER | (9) | ||
| LAST_STAT_REFRESH | DATE | |||
| LIST_DB_NAME | VARCHAR2 | (128) | ||
| LISTDB_RELEASE_STR | VARCHAR2 | (1000) | ||
| LISTDB_SELECT_STR | VARCHAR2 | (1000) | ||
| LIST_DB_STATUS | VARCHAR2 | (5) | ||
| LAST_QBLOCK_BYTES | NUMBER | (9) | ||
| MASTER_FILE_SPEC | VARCHAR2 | (250) | ||
| MASTER_TABLE | VARCHAR2 | (30) | ||
| MASTER_FS_LEN | NUMBER | (9) | ||
| NUM_AGENTS | NUMBER | (9) | ||
| NUM_BLKS_LIST_FILE | NUMBER | (9) | ||
| NUM_CACHE_READS | NUMBER | (9) | ||
| NUM_CACHE_WRITES | NUMBER | (9) | ||
| NUM_CACHE_HITS | NUMBER | (9) | ||
| NUM_CACHE_MISSES | NUMBER | (9) | ||
| NUM_CACHE_COLLISNS | NUMBER | (9) | ||
| NUM_FIELD_RECORDS | NUMBER | (9) | ||
| NUM_SET_RECORDS | NUMBER | (9) | ||
| NUM_LIST_RECORDS | NUMBER | (9) | ||
| NUM_CACHE_FLUSHES | NUMBER | (9) | ||
| CHECK_DUPES_FLAG | VARCHAR2 | (5) | ||
| PROP_RLS_FLAG | VARCHAR2 | (5) | ||
| CURRENT_ENTRY_CNT | NUMBER | (9) | ||
| DIALING_OPTIONS | VARCHAR2 | (128) | ||
| ABANDON_LIMIT | NUMBER | (9) | ||
| TALK_TIME_LOCAL | NUMBER | (9) | ||
| PACING_METHOD | NUMBER | (9) | ||
| PACE_Y_N | VARCHAR2 | (5) | ||
| PBX_NAME | VARCHAR2 | (30) | ||
| LISTDB_TYPE | NUMBER | (9) | ||
| T1_MIN | NUMBER | (9) | ||
| T15_MIN | NUMBER | (9) | ||
| T9AM | NUMBER | (9) | ||
| T11AM | NUMBER | (9) | ||
| T12PM | NUMBER | (9) | ||
| T1PM | NUMBER | (9) | ||
| TIME_ZONE | NUMBER | (38) | ||
| ACCT_NAME_COLUMNS | VARCHAR2 | (100) | ||
| DATA_FIELDS | VARCHAR2 | (1100) | ||
| DB_PASSWORD | VARCHAR2 | (60) | ||
| ACCOUNT_ID | VARCHAR2 | (30) | ||
| POST_PROC_FILE | VARCHAR2 | (128) | ||
| JOURNAL_FLUSH | NUMBER | (9) | ||
| DIALING_TYPE | NUMBER | (9) | ||
| NPR_LST_DB_LIST | NUMBER | (9) | ||
| USER_DATA_SIZE | NUMBER | (9) | ||
| VERSION | NUMBER | (9) | ||
| CAMPAIGN_LIST_ID | NUMBER | (15) | ||
| SECURITY_GROUP_ID | NUMBER | (15) | ||
| OBJECT_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT CP_SERVICE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SREF_TYPE
, LIST_SRV_NAME
, RECYCLING_METHOD
, CALENDAR_FILE
, CAL_ALG_TYPE
, RCY_ALG_TYPE
, ORG_ID
, REORG_RECHECK_FLG
, REORG_DATE
, REVISION
, REORG_FLAG
, STOP_LIST_LD_FLAG
, SEND_ORIG_LIST_FLG
, SCRIPT_NAME
, SQL_SELECT_STR
, STOP_CNTCT_CH_FLAG
, T2PM
, T3PM
, T30_MIN
, T4PM
, T5PM
, T5_MIN
, T6PM
, T60_MIN
, T7PM
, T8PM
, T9PM
, T10PM
, T10_MIN
, T10AM
, T11PM
, LAST_STAT_REFRESH
, LIST_DB_NAME
, LISTDB_RELEASE_STR
, LISTDB_SELECT_STR
, LIST_DB_STATUS
, LAST_QBLOCK_BYTES
, MASTER_FILE_SPEC
, MASTER_TABLE
, MASTER_FS_LEN
, NUM_AGENTS
, NUM_BLKS_LIST_FILE
, NUM_CACHE_READS
, NUM_CACHE_WRITES
, NUM_CACHE_HITS
, NUM_CACHE_MISSES
, NUM_CACHE_COLLISNS
, NUM_FIELD_RECORDS
, NUM_SET_RECORDS
, NUM_LIST_RECORDS
, NUM_CACHE_FLUSHES
, CHECK_DUPES_FLAG
, PROP_RLS_FLAG
, CURRENT_ENTRY_CNT
, DIALING_OPTIONS
, ABANDON_LIMIT
, TALK_TIME_LOCAL
, PACING_METHOD
, PACE_Y_N
, PBX_NAME
, LISTDB_TYPE
, T1_MIN
, T15_MIN
, T9AM
, T11AM
, T12PM
, T1PM
, TIME_ZONE
, ACCT_NAME_COLUMNS
, DATA_FIELDS
, DB_PASSWORD
, ACCOUNT_ID
, POST_PROC_FILE
, JOURNAL_FLUSH
, DIALING_TYPE
, NPR_LST_DB_LIST
, USER_DATA_SIZE
, VERSION
, CAMPAIGN_LIST_ID
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_SERVICES_ALL#;
IEO
IEO_CP_SERVICES_ALL
APPS
IEO_CP_SERVICES_ALL
|
|
|
|