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_PROCESS_FLOW_ACTIVITIES

Object Details

Object Name:	MSC_PROCESS_FLOW_ACTIVITIES
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

This table contains activity information for a particular process flow.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_ID	NUMBER		Yes	Activity ID
ACTIVITY_TYPE	NUMBER		Yes	Activity Type
PROCESS_FLOW_ID	NUMBER		Yes	Process Flow ID
PROCESS_SCOPE	VARCHAR2	(50)		Process Scope
ACTIVITY_SEQUENCE	NUMBER		Yes	Activity Sequence
CREATED_BY	NUMBER			Standard Who Column
CREATION_DATE	DATE			Standard Who Column
LAST_UPDATED_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER			Standard Who Column
LAST_UPDATED_LOGIN	NUMBER			Standard Who Column

Query Text

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


SELECT ACTIVITY_ID
,      ACTIVITY_TYPE
,      PROCESS_FLOW_ID
,      PROCESS_SCOPE
,      ACTIVITY_SEQUENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_LOGIN
FROM MSC.MSC_PROCESS_FLOW_ACTIVITIES;

Dependencies

[top of page]

MSC.MSC_PROCESS_FLOW_ACTIVITIES does not reference any database object

MSC.MSC_PROCESS_FLOW_ACTIVITIES is referenced by following:

MSC: MSC_PROCESS_FLOW_ACTIVITIES#