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

TABLE: MSC.MSC_PROFILES

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


This table will have the unique record for a particular profile option value for a given preference set name,user name, appl/resp name, schema name and for that particular profile name.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_SET_NAME VARCHAR2 (50) Yes The name for a particular group of profile option values which user wants to upload at a time
LEVEL_TYPE VARCHAR2 (30)
Level Type (e.g. USER, SITE etc)
LEVEL_NAME VARCHAR2 (100)
Value at particular level (e.g. value at USER level is MFG)
PROFILE_OPTION_NAME VARCHAR2 (80)
Profile option name
PROFILE_OPTION_VALUE VARCHAR2 (240)
Value of that particular profile at that particular level
APPLICATION_NAME VARCHAR2 (10)
Application Name
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_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 PREFERENCE_SET_NAME
,      LEVEL_TYPE
,      LEVEL_NAME
,      PROFILE_OPTION_NAME
,      PROFILE_OPTION_VALUE
,      APPLICATION_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_PROFILES;

Dependencies

[top of page]

MSC.MSC_PROFILES does not reference any database object

MSC.MSC_PROFILES is referenced by following:

SchemaMSC
ViewMSC_PROFILES#