MSC_FORM_QUERY
This is a generic query table for inquiry forms in Oracle APS and for the bucketed horizontal view in Oracle Supply Chain Exchange.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QUERY_ID | NUMBER | 18 | Yes | Query identifier for the global temporary table. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| DATE1 | DATE | Generic date column for the global temporary table. | |||
| DATE2 | DATE | Generic date column for the global temporary table. | |||
| DATE3 | DATE | Generic date column for the global temporary table. | |||
| DATE4 | DATE | Generic date column for the global temporary table. | |||
| DATE5 | DATE | Generic date column for the global temporary table. | |||
| DATE6 | DATE | Generic date column for the global temporary table. | |||
| DATE7 | DATE | Generic date column for the global temporary table. | |||
| DATE8 | DATE | Generic date column for the global temporary table. | |||
| NUMBER1 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER2 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER3 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER4 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER5 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER6 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER7 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER8 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER9 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER10 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER11 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER12 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER13 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER14 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER15 | NUMBER | Generic number column for the global temporary table. | |||
| CHAR1 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR2 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR3 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR4 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR5 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR6 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR7 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR8 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR9 | VARCHAR2 | 250 | Generic character column for the global temporary table. | ||
| NUMBER16 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER17 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER18 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER19 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER20 | NUMBER | Generic number column for the global temporary table. | |||
| CHAR10 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR11 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR12 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR13 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR14 | VARCHAR2 | 250 | Generic character column for the global temporary table. | ||
| CHAR15 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR16 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR17 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR18 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR19 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR20 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR21 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR22 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR23 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR24 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR25 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR26 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR27 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR28 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR29 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR30 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR31 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR32 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR33 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR34 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR35 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR36 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR37 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR38 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR39 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| CHAR40 | VARCHAR2 | 80 | Generic character column for the global temporary table. | ||
| NUMBER21 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER22 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER23 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER24 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER25 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER26 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER27 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER28 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER29 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER30 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER31 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER32 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER33 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER34 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER35 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER36 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER37 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER38 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER39 | NUMBER | Generic number column for the global temporary table. | |||
| NUMBER40 | NUMBER | Generic number column for the global temporary table. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| MSC_FORM_QUERY_N1 | Non Unique | QUERY_ID |