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

TABLE: MSC.MSC_ACTIVITY_PARAMETERS

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


This table contains parameters and their display value and default value for a particular activity


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ACTIVITY_PARAMETERS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnACTIVITY_TYPE
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_TYPE NUMBER
Yes Activity Type
NAME VARCHAR2 (100) Yes Name
DATA_TYPE VARCHAR2 (30)
Data Type
DEFAULT_VALUE VARCHAR2 (30)
Default Value
SEQUENCE NUMBER

Sequence
SQL VARCHAR2 (2000)
SQL
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
DISPLAYED VARCHAR2 (10) Yes Displayed
REQUIRED VARCHAR2 (10) Yes Required
DISPLAY_NAME VARCHAR2 (240) Yes Display Name
DEF_DISP_VALUE VARCHAR2 (80)
Default Display Value
PARAM_VERSION NUMBER

Parameter Version
Query Text

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


SELECT ACTIVITY_TYPE
,      NAME
,      DATA_TYPE
,      DEFAULT_VALUE
,      SEQUENCE
,      SQL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DISPLAYED
,      REQUIRED
,      DISPLAY_NAME
,      DEF_DISP_VALUE
,      PARAM_VERSION
FROM MSC.MSC_ACTIVITY_PARAMETERS;

Dependencies

[top of page]

MSC.MSC_ACTIVITY_PARAMETERS does not reference any database object

MSC.MSC_ACTIVITY_PARAMETERS is referenced by following:

SchemaMSC
ViewMSC_ACTIVITY_PARAMETERS#