[Home] [Help] [Dependency Information]
Object Name: | IEO_CP_LIST_STATS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | IEO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CP_LIST_STAT_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) | ||
ORG_ID | NUMBER | (15) | Yes | |
LIST_NAME | VARCHAR2 | (30) | Yes | |
LIST_SRV_NAME | VARCHAR2 | (30) | Yes | |
SREF_TYPE | VARCHAR2 | (5) | Yes | |
T10AM | NUMBER | (9) | ||
T10PM | NUMBER | (9) | ||
T10_MIN | NUMBER | (9) | ||
T11AM | NUMBER | (9) | ||
T11PM | NUMBER | (9) | ||
T12PM | NUMBER | (9) | ||
T1PM | NUMBER | (9) | ||
T12AM | NUMBER | (9) | ||
T1AM | NUMBER | (9) | ||
T15_MIN | NUMBER | (9) | ||
T1_MIN | NUMBER | (9) | ||
T2PM | NUMBER | (9) | ||
T2AM | NUMBER | (9) | ||
T3PM | NUMBER | (9) | ||
T3AM | NUMBER | (9) | ||
T30_MIN | NUMBER | (9) | ||
T4PM | NUMBER | (9) | ||
T4AM | NUMBER | (9) | ||
T5PM | NUMBER | (9) | ||
T5AM | NUMBER | (9) | ||
T5_MIN | NUMBER | (9) | ||
T6PM | NUMBER | (9) | ||
T6AM | NUMBER | (9) | ||
T60_MIN | NUMBER | (9) | ||
T7PM | NUMBER | (9) | ||
T7AM | NUMBER | (9) | ||
T8PM | NUMBER | (9) | ||
T8AM | NUMBER | (9) | ||
T9PM | NUMBER | (9) | ||
RELEASED_1 | NUMBER | (9) | ||
RELEASED_10 | NUMBER | (9) | ||
RELEASED_11 | NUMBER | (9) | ||
RELEASED_12 | NUMBER | (9) | ||
RELEASED_13 | NUMBER | (9) | ||
RELEASED_14 | NUMBER | (9) | ||
RELEASED_15 | NUMBER | (9) | ||
RELEASED_16 | NUMBER | (9) | ||
RELEASED_17 | NUMBER | (9) | ||
RELEASED_18 | NUMBER | (9) | ||
RELEASED_19 | NUMBER | (9) | ||
RELEASED_2 | NUMBER | (9) | ||
RELEASED_20 | NUMBER | (9) | ||
RELEASED_21 | NUMBER | (9) | ||
RELEASED_22 | NUMBER | (9) | ||
RELEASED_23 | NUMBER | (9) | ||
RELEASED_24 | NUMBER | (9) | ||
RELEASED_25 | NUMBER | (9) | ||
RELEASED_26 | NUMBER | (9) | ||
RELEASED_27 | NUMBER | (9) | ||
RELEASED_28 | NUMBER | (9) | ||
RELEASED_29 | NUMBER | (9) | ||
RELEASED_3 | NUMBER | (9) | ||
RELEASED_30 | NUMBER | (9) | ||
RELEASED_31 | NUMBER | (9) | ||
RELEASED_32 | NUMBER | (9) | ||
RELEASED_33 | NUMBER | (9) | ||
RELEASED_34 | NUMBER | (9) | ||
RELEASED_35 | NUMBER | (9) | ||
RELEASED_36 | NUMBER | (9) | ||
RELEASED_37 | NUMBER | (9) | ||
RELEASED_38 | NUMBER | (9) | ||
RELEASED_39 | NUMBER | (9) | ||
RELEASED_4 | NUMBER | (9) | ||
RELEASED_40 | NUMBER | (9) | ||
RELEASED_41 | NUMBER | (9) | ||
RELEASED_42 | NUMBER | (9) | ||
RELEASED_43 | NUMBER | (9) | ||
RELEASED_44 | NUMBER | (9) | ||
RELEASED_45 | NUMBER | (9) | ||
RELEASED_46 | NUMBER | (9) | ||
RELEASED_47 | NUMBER | (9) | ||
RELEASED_48 | NUMBER | (9) | ||
RELEASED_49 | NUMBER | (9) | ||
RELEASED_5 | NUMBER | (9) | ||
RELEASED_50 | NUMBER | (9) | ||
RELEASED_51 | NUMBER | (9) | ||
RELEASED_52 | NUMBER | (9) | ||
RELEASED_53 | NUMBER | (9) | ||
RELEASED_54 | NUMBER | (9) | ||
RELEASED_55 | NUMBER | (9) | ||
RELEASED_56 | NUMBER | (9) | ||
RELEASED_57 | NUMBER | (9) | ||
RELEASED_58 | NUMBER | (9) | ||
RELEASED_59 | NUMBER | (9) | ||
RELEASED_6 | NUMBER | (9) | ||
RELEASED_60 | NUMBER | (9) | ||
RELEASED_7 | NUMBER | (9) | ||
RELEASED_8 | NUMBER | (9) | ||
RELEASED_9 | NUMBER | (9) | ||
TN1_MIN | NUMBER | (9) | ||
TN5_MIN | NUMBER | (9) | ||
TN10_MIN | NUMBER | (9) | ||
TN15_MIN | NUMBER | (9) | ||
TN30_MIN | NUMBER | (9) | ||
TN60_MIN | NUMBER | (9) | ||
REC_ADDED | NUMBER | (9) | ||
REC_TAKEN | NUMBER | (9) | ||
CUR_TOTAL_REC | NUMBER | (9) | ||
REC_AVAILABLE | NUMBER | (9) | ||
REC_UNAVAILABLE | NUMBER | (9) | ||
T9AM | NUMBER | (9) | ||
LAST_STAT_REFRESH | DATE | |||
SECURITY_GROUP_ID | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER |
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#;
|
|
|