[Home] [Help] [Dependency Information]
Object Name: | MSC_HZ_UI_HEADERS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
MSC.MSC_HZ_UI_HEADERS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_HZ_UI_HEADERS_N1 | NORMAL | NONUNIQUE | QUERY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | ||
NO_OF_BUCKETS | NUMBER | Yes | ||
PROD_SUM_LEVEL | NUMBER | Yes | ||
ORG_SUM_LEVEL | VARCHAR2 | (30) | Yes | |
ORG_SUM_LEVEL_TP | VARCHAR2 | (30) | Yes | |
UNDATED_BUCKET_FLAG | VARCHAR2 | (1) | Yes | |
USER_PREFERENCE | VARCHAR2 | (30) | ||
BUCKET1 | DATE | |||
BUCKET2 | DATE | |||
BUCKET3 | DATE | |||
BUCKET4 | DATE | |||
BUCKET5 | DATE | |||
BUCKET6 | DATE | |||
BUCKET7 | DATE | |||
BUCKET8 | DATE | |||
BUCKET9 | DATE | |||
BUCKET10 | DATE | |||
BUCKET11 | DATE | |||
BUCKET12 | DATE | |||
BUCKET13 | DATE | |||
BUCKET14 | DATE | |||
BUCKET15 | DATE | |||
BUCKET16 | DATE | |||
BUCKET17 | DATE | |||
BUCKET18 | DATE | |||
BUCKET19 | DATE | |||
BUCKET20 | DATE | |||
BUCKET21 | DATE | |||
BUCKET22 | DATE | |||
BUCKET23 | DATE | |||
BUCKET24 | DATE | |||
BUCKET25 | DATE | |||
BUCKET26 | DATE | |||
BUCKET27 | DATE | |||
BUCKET28 | DATE | |||
BUCKET29 | DATE | |||
BUCKET30 | DATE | |||
BUCKET31 | DATE | |||
BUCKET32 | DATE | |||
BUCKET33 | DATE | |||
BUCKET34 | DATE | |||
BUCKET35 | DATE | |||
BUCKET36 | DATE | |||
GRAPH_TYPE | NUMBER | |||
GRAPH_TITLE | VARCHAR2 | (80) | ||
LAST_BUCKET | DATE | |||
PAST_DUE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, NO_OF_BUCKETS
, PROD_SUM_LEVEL
, ORG_SUM_LEVEL
, ORG_SUM_LEVEL_TP
, UNDATED_BUCKET_FLAG
, USER_PREFERENCE
, BUCKET1
, BUCKET2
, BUCKET3
, BUCKET4
, BUCKET5
, BUCKET6
, BUCKET7
, BUCKET8
, BUCKET9
, BUCKET10
, BUCKET11
, BUCKET12
, BUCKET13
, BUCKET14
, BUCKET15
, BUCKET16
, BUCKET17
, BUCKET18
, BUCKET19
, BUCKET20
, BUCKET21
, BUCKET22
, BUCKET23
, BUCKET24
, BUCKET25
, BUCKET26
, BUCKET27
, BUCKET28
, BUCKET29
, BUCKET30
, BUCKET31
, BUCKET32
, BUCKET33
, BUCKET34
, BUCKET35
, BUCKET36
, GRAPH_TYPE
, GRAPH_TITLE
, LAST_BUCKET
, PAST_DUE
FROM MSC.MSC_HZ_UI_HEADERS;
MSC.MSC_HZ_UI_HEADERS does not reference any database object
MSC.MSC_HZ_UI_HEADERS is referenced by following:
|
|
|