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


TABLE: MSC.MSC_FOLDER_COLUMNS

Object Details
Object Name: MSC_FOLDER_COLUMNS
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


List of columns userd in find windows


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_FOLDER_COLUMNS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFOLDER_ID
MSC_FOLDER_COLUMNS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFOLDER_ID
ColumnITEM_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

MSC.MSC_FOLDER_COLUMNS does not reference any database object

MSC.MSC_FOLDER_COLUMNS is referenced by following:

SchemaMSC
ViewMSC_FOLDER_COLUMNS#