eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_HUB_QUERY

Object Details

Object Name:	MSC_HUB_QUERY
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_HUB_QUERY
Subobject Name:
Status:	VALID

Temporary Table Details

MSC.MSC_HUB_QUERY 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000455958C00040$$	LOB	UNIQUE	SYSTEM
SYS_IL0000455958C00049$$	LOB	UNIQUE	SYSTEM
MSC_HUB_QUERY_N1	NORMAL	NONUNIQUE		QUERY_ID NUMBER1 NUMBER2 NUMBER3 NUMBER4 NUMBER5
MSC_HUB_QUERY_N2	NORMAL	NONUNIQUE		QUERY_ID NUMBER6
MSC_HUB_QUERY_N3	NORMAL	NONUNIQUE		QUERY_ID DATE1
MSC_HUB_QUERY_N4	NORMAL	NONUNIQUE		QUERY_ID DATE2
MSC_HUB_QUERY_N5	NORMAL	NONUNIQUE		QUERY_ID DATE3
MSC_HUB_QUERY_N6	NORMAL	NONUNIQUE		QUERY_ID DATE4
MSC_HUB_QUERY_N7	NORMAL	NONUNIQUE		QUERY_ID DATE5

Columns

Name	Datatype	Length	Mandatory
QUERY_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
DATE1	DATE
DATE2	DATE
DATE3	DATE
DATE4	DATE
NUMBER1	NUMBER
NUMBER2	NUMBER
NUMBER3	NUMBER
NUMBER4	NUMBER
NUMBER5	NUMBER
NUMBER6	NUMBER
NUMBER7	NUMBER
NUMBER8	NUMBER
NUMBER9	NUMBER
NUMBER10	NUMBER
NUMBER11	NUMBER
NUMBER12	NUMBER
NUMBER13	NUMBER
NUMBER14	NUMBER
NUMBER15	NUMBER
NUMBER16	NUMBER
NUMBER17	NUMBER
NUMBER18	NUMBER
NUMBER19	NUMBER
NUMBER20	NUMBER
NUMBER21	NUMBER
NUMBER22	NUMBER
NUMBER23	NUMBER
NUMBER24	NUMBER
NUMBER25	NUMBER
CHAR1	VARCHAR2	(80)
CHAR2	VARCHAR2	(100)
CHAR3	VARCHAR2	(255)
DATE5	DATE
BLOB1	BLOB	(4000)
NUMBER26	NUMBER
NUMBER27	NUMBER
NUMBER28	NUMBER
NUMBER29	NUMBER
NUMBER30	NUMBER
NUMBER31	NUMBER
NUMBER32	NUMBER
NUMBER33	NUMBER
CLOB1	CLOB	(4000)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUERY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
,      NUMBER16
,      NUMBER17
,      NUMBER18
,      NUMBER19
,      NUMBER20
,      NUMBER21
,      NUMBER22
,      NUMBER23
,      NUMBER24
,      NUMBER25
,      CHAR1
,      CHAR2
,      CHAR3
,      DATE5
,      BLOB1
,      NUMBER26
,      NUMBER27
,      NUMBER28
,      NUMBER29
,      NUMBER30
,      NUMBER31
,      NUMBER32
,      NUMBER33
,      CLOB1
FROM MSC.MSC_HUB_QUERY;

Dependencies

[top of page]

MSC.MSC_HUB_QUERY does not reference any database object

MSC.MSC_HUB_QUERY is referenced by following:

APPS: MSC_HUB_QUERY