[Home] [Help]
[Dependency Information]
| Object Name: | MSC_FOLDER_COLUMNS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| Subobject Name: | |
| Status: | VALID |
List of columns userd in find windows
| Tablespace: | APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_FOLDER_COLUMNS_N1 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
FOLDER_ID
|
| MSC_FOLDER_COLUMNS_N2 | NORMAL | NONUNIQUE |
APPS_TS_SEED
|
FOLDER_ID
ITEM_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FOLDER_ID | NUMBER | Folder Id | ||
| DISPLAY_MODE | VARCHAR2 | (1) | Display Mode | |
| ITEM_NAME | VARCHAR2 | (30) | Item Name | |
| SEQUENCE | NUMBER | Sequence | ||
| ITEM_WIDTH | NUMBER | Item Width | ||
| ASC_DESC | NUMBER | Flag to indicate sort order |
Cut, paste (and edit) the following text to query this object:
SELECT FOLDER_ID
, DISPLAY_MODE
, ITEM_NAME
, SEQUENCE
, ITEM_WIDTH
, ASC_DESC
FROM MSC.MSC_FOLDER_COLUMNS;
MSC.MSC_FOLDER_COLUMNS does not reference any database object
MSC.MSC_FOLDER_COLUMNS is referenced by following:
MSC
MSC_FOLDER_COLUMNS#
|
|
|
|