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

TABLE: MSC.MSC_FORM_QUERY

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


This is a generic query table for inquiry forms in Oracle APS and for the bucketed horizontal view in Oracle Supply Chain Exchange.


Temporary Table Details

MSC.MSC_FORM_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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
MSC_FORM_QUERY_N1 NORMAL NONUNIQUE Tablespace ColumnQUERY_ID
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 (400)
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 (250)
Generic character column
CHAR15 VARCHAR2 (80)
Generic character column
NUMBER17 NUMBER

NUMBER18 NUMBER

NUMBER19 NUMBER

NUMBER20 NUMBER

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
,      NUMBER17
,      NUMBER18
,      NUMBER19
,      NUMBER20
FROM MSC.MSC_FORM_QUERY;

Dependencies

[top of page]

MSC.MSC_FORM_QUERY does not reference any database object

MSC.MSC_FORM_QUERY is referenced by following:

SchemaAPPS
SynonymMSC_FORM_QUERY