DBA Data[Home] [Help] [Dependency Information]


VIEW: IEO.IEO_CP_LIST_STATS_ALL#

Object Details
Object Name: IEO_CP_LIST_STATS_ALL#
Object Type: VIEW
Owner: IEO
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

IEO.IEO_CP_LIST_STATS_ALL# references the following:

SchemaIEO
TableIEO_CP_LIST_STATS_ALL
IEO.IEO_CP_LIST_STATS_ALL# is referenced by following:

SchemaAPPS
SynonymIEO_CP_LIST_STATS_ALL