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

TABLE: MSC.MSC_SETUP_TRANSITIONS

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


table for storing resource setup transitions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_SETUP_TRANSITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnRESOURCE_ID
ColumnFROM_SETUP_ID
ColumnTO_SETUP_ID
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan Id
SR_INSTANCE_ID NUMBER
Yes Collection Instance Id
RESOURCE_ID NUMBER
Yes Resource on which set up is performed. For opm it is -1.
ORGANIZATION_ID NUMBER
Yes Organization Id
FROM_SETUP_ID NUMBER

Populated for wip/eam
TO_SETUP_ID NUMBER
Yes Populated for wip/eam
STANDARD_OPERATION_CODE VARCHAR2 (4)
Standard operation id associated with transition
TRANSITION_TIME NUMBER
Yes Setup transition time in hours
TRANSITION_UOM VARCHAR2 (3) Yes Time UOM
TRANSITION_PENALTY NUMBER

Transition penalty
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment.
REFRESH_NUMBER NUMBER

Refresh Number. For internal use
RING_SEQUENCE_NUMBER NUMBER

Ring Sequence Number
STANDARD_OPERATION_ID NUMBER

Standard Operation Id
DEPARTMENT_ID NUMBER

Department Id
ORIG_TRANSITION_TIME NUMBER

Original Transtion Time
Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      RESOURCE_ID
,      ORGANIZATION_ID
,      FROM_SETUP_ID
,      TO_SETUP_ID
,      STANDARD_OPERATION_CODE
,      TRANSITION_TIME
,      TRANSITION_UOM
,      TRANSITION_PENALTY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REFRESH_NUMBER
,      RING_SEQUENCE_NUMBER
,      STANDARD_OPERATION_ID
,      DEPARTMENT_ID
,      ORIG_TRANSITION_TIME
FROM MSC.MSC_SETUP_TRANSITIONS;

Dependencies

[top of page]

MSC.MSC_SETUP_TRANSITIONS does not reference any database object

MSC.MSC_SETUP_TRANSITIONS is referenced by following:

SchemaMSC
ViewMSC_SETUP_TRANSITIONS#