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

TABLE: MSC.MSC_QUERY

Object Details
Object Name: MSC_QUERY
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_QUERY
Subobject Name:
Status: VALID


Table used to pass data across sessions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Query identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
DATE1 DATE

Generic date column
DATE2 DATE

Generic date column
DATE3 DATE

Generic date column
DATE4 DATE

Generic date column
DATE5 DATE

Generic date column
DATE6 DATE

Generic date column
DATE7 DATE

Generic date column
DATE8 DATE

Generic date column
NUMBER1 NUMBER

Generic number column
NUMBER2 NUMBER

Generic number column
NUMBER3 NUMBER

Generic number column
NUMBER4 NUMBER

Generic number column
NUMBER5 NUMBER

Generic number column
NUMBER6 NUMBER

Generic number column
NUMBER7 NUMBER

Generic number column
NUMBER8 NUMBER

Generic number column
NUMBER9 NUMBER

Generic number column
NUMBER10 NUMBER

Generic number column
NUMBER11 NUMBER

Generic number column
NUMBER12 NUMBER

Generic number column
NUMBER13 NUMBER

Generic number column
NUMBER14 NUMBER

Generic number column
NUMBER15 NUMBER

Generic number column
REQUEST_ID NUMBER

Concurrent Who column
CHAR1 VARCHAR2 (80)
Generic character column
CHAR2 VARCHAR2 (80)
Generic character column
CHAR3 VARCHAR2 (80)
Generic character column
CHAR4 VARCHAR2 (80)
Generic character column
CHAR5 VARCHAR2 (80)
Generic character column
CHAR6 VARCHAR2 (80)
Generic character column
CHAR7 VARCHAR2 (80)
Generic character column
CHAR8 VARCHAR2 (80)
Generic character column
CHAR9 VARCHAR2 (250)
Generic character column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
NUMBER16 NUMBER

Generic number column
CHAR10 VARCHAR2 (80)
Generic character column
CHAR11 VARCHAR2 (80)
Generic character column
CHAR12 VARCHAR2 (80)
Generic character column
CHAR13 VARCHAR2 (80)
Generic character column
CHAR14 VARCHAR2 (80)
Generic character column
CHAR15 VARCHAR2 (80)
Generic character column
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
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      NUMBER11
,      NUMBER12
,      NUMBER13
,      NUMBER14
,      NUMBER15
,      REQUEST_ID
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CHAR6
,      CHAR7
,      CHAR8
,      CHAR9
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      NUMBER16
,      CHAR10
,      CHAR11
,      CHAR12
,      CHAR13
,      CHAR14
,      CHAR15
FROM MSC.MSC_QUERY;

Dependencies

[top of page]

MSC.MSC_QUERY does not reference any database object

MSC.MSC_QUERY is referenced by following:

SchemaAPPS
SynonymMSC_QUERY