eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MSC.MSC_EXCEPTION_PREFERENCES

Object Details

Object Name:	MSC_EXCEPTION_PREFERENCES
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_EXCEPTION_PREFERENCES
Subobject Name:
Status:	VALID

This table stores the order in which a user chooses to see the exception types.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_EXCEPTION_PREFERENCES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_ID EXCEPTION_TYPE_LOOKUP_CODE RANK

Columns

Name	Datatype	Comments
USER_ID	NUMBER	Id of the user
EXCEPTION_TYPE_LOOKUP_CODE	NUMBER	Exception type
RANK	NUMBER	rank used for ordering the exceptions
CREATION_DATE	DATE	Standard who column
CREATED_BY	NUMBER	Standard who column
LAST_UPDATE_DATE	DATE	Standard who column
LAST_UPDATED_BY	NUMBER	Standard who column
LAST_UPDATE_LOGIN	NUMBER	Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USER_ID
,      EXCEPTION_TYPE_LOOKUP_CODE
,      RANK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_EXCEPTION_PREFERENCES;

Dependencies

[top of page]

MSC.MSC_EXCEPTION_PREFERENCES does not reference any database object

MSC.MSC_EXCEPTION_PREFERENCES is referenced by following:

APPS: MSC_EXCEPTION_PREFERENCES