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

TABLE: MSC.MSC_HZ_UI_HEADERS

Object Details
Object Name: MSC_HZ_UI_HEADERS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID

Temporary Table Details

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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
MSC_HZ_UI_HEADERS_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
Columns
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)
Query Text

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;

Dependencies

[top of page]

MSC.MSC_HZ_UI_HEADERS does not reference any database object

MSC.MSC_HZ_UI_HEADERS is referenced by following:

SchemaAPPS
SynonymMSC_HZ_UI_HEADERS