[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IEO_CP_LIST_STATS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IEO |
| FND Design Data: |  IEO.IEO_CP_LIST_STATS_ALL
|
| Subobject Name: | |
| Status: | VALID |
Release statistics for records from CP Lists
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CP_LIST_STAT_ID | NUMBER | Yes | Primary key column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
| 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 | |
| ORG_ID | NUMBER | (15) | Yes | Multi-org support |
| LIST_NAME | VARCHAR2 | (30) | Yes | List name |
| LIST_SRV_NAME | VARCHAR2 | (30) | Yes | List service name |
| SREF_TYPE | VARCHAR2 | (5) | Yes | "S" |
| T10AM | NUMBER | (9) | Number of records released from 10am-10:59am | |
| T10PM | NUMBER | (9) | Number of records released from 10pm-10:59pm | |
| T10_MIN | NUMBER | (9) | Records released in the last 10 minutes | |
| T11AM | NUMBER | (9) | Number of records released from 11am-11:59am | |
| T11PM | NUMBER | (9) | Number of records released from 11pm-11:59pm | |
| T12PM | NUMBER | (9) | Number of records released from 12pm-12:59pm | |
| T1PM | NUMBER | (9) | Number of records released from 1pm-1:59pm | |
| T12AM | NUMBER | (9) | Number of records released from 12am-12:59am | |
| T1AM | NUMBER | (9) | Number of records released from 1am-1:59am | |
| T15_MIN | NUMBER | (9) | Records released in the last 15 minutes | |
| T1_MIN | NUMBER | (9) | Records released in the last 1 minute | |
| T2PM | NUMBER | (9) | Number of records released from 2pm-2:59pm | |
| T2AM | NUMBER | (9) | Number of records released from 2am-2:59am | |
| T3PM | NUMBER | (9) | Number of records released from 3pm-3:59pm | |
| T3AM | NUMBER | (9) | Number of records released from 3am-3:59am | |
| T30_MIN | NUMBER | (9) | Records released in the last 30 minutes | |
| T4PM | NUMBER | (9) | Number of records released from 4pm-4:59pm | |
| T4AM | NUMBER | (9) | Number of records released from 4am-4:59am | |
| T5PM | NUMBER | (9) | Number of records released from 5pm-5:59pm | |
| T5AM | NUMBER | (9) | Number of records released from 5am-5:59am | |
| T5_MIN | NUMBER | (9) | Records released in the last 5 minutes | |
| T6PM | NUMBER | (9) | Number of records released from 6pm-6:59pm | |
| T6AM | NUMBER | (9) | Number of records released from 6am-6:59am | |
| T60_MIN | NUMBER | (9) | Records released in the last 60 minutes | |
| T7PM | NUMBER | (9) | Number of records released from 7pm-7:59pm | |
| T7AM | NUMBER | (9) | Number of records released from 7am-7:59am | |
| T8PM | NUMBER | (9) | Number of records released from 8pm-8:59pm | |
| T8AM | NUMBER | (9) | Number of records released from 8am-8:59am | |
| T9PM | NUMBER | (9) | Number of records released from 9pm-9:59pm | |
| RELEASED_1 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_10 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_11 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_12 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_13 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_14 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_15 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_16 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_17 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_18 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_19 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_2 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_20 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_21 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_22 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_23 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_24 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_25 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_26 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_27 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_28 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_29 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_3 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_30 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_31 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_32 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_33 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_34 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_35 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_36 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_37 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_38 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_39 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_4 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_40 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_41 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_42 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_43 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_44 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_45 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_46 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_47 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_48 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_49 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_5 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_50 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_51 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_52 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_53 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_54 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_55 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_56 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_57 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_58 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_59 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_6 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_60 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_7 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_8 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| RELEASED_9 | NUMBER | (9) | Number of records released in one of the last 60 minutes | |
| TN1_MIN | NUMBER | (9) | Records expected to be relesaed in the next 1 minute | |
| TN5_MIN | NUMBER | (9) | Records expected to be relesaed in the next 5 minutes | |
| TN10_MIN | NUMBER | (9) | Records expected to be released in the next 10 minutes | |
| TN15_MIN | NUMBER | (9) | Records expected to be released in the next 15 minutes | |
| TN30_MIN | NUMBER | (9) | Records expected to be released in the next 30 minutes | |
| TN60_MIN | NUMBER | (9) | Records expected to be released in the next 60 minutes | |
| REC_ADDED | NUMBER | (9) | Number of records added since process started | |
| REC_TAKEN | NUMBER | (9) | Number of records taken since process started | |
| CUR_TOTAL_REC | NUMBER | (9) | Total records stored in this service | |
| REC_AVAILABLE | NUMBER | (9) | Records available for release | |
| REC_UNAVAILABLE | NUMBER | (9) | Records unavailable due to timestamps or closed lists | |
| T9AM | NUMBER | (9) | Number of records released from 9am-9:59am | |
| LAST_STAT_REFRESH | DATE | Obsolete | ||
| 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_LIST_STAT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, LIST_NAME
, LIST_SRV_NAME
, SREF_TYPE
, T10AM
, T10PM
, T10_MIN
, T11AM
, T11PM
, T12PM
, T1PM
, T12AM
, T1AM
, T15_MIN
, T1_MIN
, T2PM
, T2AM
, T3PM
, T3AM
, T30_MIN
, T4PM
, T4AM
, T5PM
, T5AM
, T5_MIN
, T6PM
, T6AM
, T60_MIN
, T7PM
, T7AM
, T8PM
, T8AM
, T9PM
, RELEASED_1
, RELEASED_10
, RELEASED_11
, RELEASED_12
, RELEASED_13
, RELEASED_14
, RELEASED_15
, RELEASED_16
, RELEASED_17
, RELEASED_18
, RELEASED_19
, RELEASED_2
, RELEASED_20
, RELEASED_21
, RELEASED_22
, RELEASED_23
, RELEASED_24
, RELEASED_25
, RELEASED_26
, RELEASED_27
, RELEASED_28
, RELEASED_29
, RELEASED_3
, RELEASED_30
, RELEASED_31
, RELEASED_32
, RELEASED_33
, RELEASED_34
, RELEASED_35
, RELEASED_36
, RELEASED_37
, RELEASED_38
, RELEASED_39
, RELEASED_4
, RELEASED_40
, RELEASED_41
, RELEASED_42
, RELEASED_43
, RELEASED_44
, RELEASED_45
, RELEASED_46
, RELEASED_47
, RELEASED_48
, RELEASED_49
, RELEASED_5
, RELEASED_50
, RELEASED_51
, RELEASED_52
, RELEASED_53
, RELEASED_54
, RELEASED_55
, RELEASED_56
, RELEASED_57
, RELEASED_58
, RELEASED_59
, RELEASED_6
, RELEASED_60
, RELEASED_7
, RELEASED_8
, RELEASED_9
, TN1_MIN
, TN5_MIN
, TN10_MIN
, TN15_MIN
, TN30_MIN
, TN60_MIN
, REC_ADDED
, REC_TAKEN
, CUR_TOTAL_REC
, REC_AVAILABLE
, REC_UNAVAILABLE
, T9AM
, LAST_STAT_REFRESH
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_CP_LIST_STATS_ALL;
IEO.IEO_CP_LIST_STATS_ALL does not reference any database object
IEO.IEO_CP_LIST_STATS_ALL is referenced by following:
IEO
IEO_CP_LIST_STATS_ALL#
|
|
|
|