Skip to content

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

TABLE: MSC.MSC_ST_PROFILES

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


This is the interface table to keep the profile option and their values in profile option utility program


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_SET_NAME VARCHAR2 (50)
The name for a particular group of profile option values which user wants to upload at a time
LEVEL_TYPE VARCHAR2 (10)
Level Type (e.g. USER, SITE etc)
LEVEL_NAME VARCHAR2 (100)
The value at particular level (e.g. at USER level the value is MFG)
PROFILE_OPTION_NAME VARCHAR2 (80)
Name of the profile option to be uploaded into the destination database
PROFILE_OPTION_VALUE VARCHAR2 (240)
The value of profile option at particular level
APPLICATION_NAME VARCHAR2 (10)
Application Name
PROCESS_FLAG NUMBER

Processing Flag indicating the status of records during pre-processing. 1- New Record, 3- Error , 5- Successfully Processed
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
ERROR_TEXT VARCHAR2 (2000)
Error text
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
,      PROCESS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ERROR_TEXT
FROM MSC.MSC_ST_PROFILES;

Dependencies

[top of page]

MSC.MSC_ST_PROFILES does not reference any database object

MSC.MSC_ST_PROFILES is referenced by following:

SchemaMSC
ViewMSC_ST_PROFILES#