[Home] [Help] [Dependency Information]
Object Name: | MSC_HUB_QUERY |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_HUB_QUERY |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 | (80) | ||
CHAR3 | VARCHAR2 | (80) | ||
DATE5 | DATE |
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
FROM MSC.MSC_HUB_QUERY;
MSC.MSC_HUB_QUERY does not reference any database object
MSC.MSC_HUB_QUERY is referenced by following:
|
|
|