[Home] [Help] [Dependency Information]
Object Name: | MSC_PLANNING_PROC_ACTIVITIES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
The contatins information about the activities for a particular process
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_ID | NUMBER | Yes | Process ID | |
ACTIVITY_ID | NUMBER | Yes | Activity ID | |
PLAN_ID | NUMBER | Plan ID | ||
SKIP | NUMBER | Skip | ||
OWNER | NUMBER | Owner | ||
STATUS | NUMBER | Status | ||
ACTIVITY_SEQUENCE | NUMBER | Yes | Activity Sequence | |
ACTIVITY_TYPE | NUMBER | Yes | Activity Type | |
ALTERNATE_OWNER | NUMBER | Alternate Owner | ||
TIME_OUT | NUMBER | Time Out | ||
PROCESS_SCOPE | VARCHAR2 | (30) | Yes | Process Scope |
RUN_SEQUENCE | NUMBER | Run Sequence | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_ID
, ACTIVITY_ID
, PLAN_ID
, SKIP
, OWNER
, STATUS
, ACTIVITY_SEQUENCE
, ACTIVITY_TYPE
, ALTERNATE_OWNER
, TIME_OUT
, PROCESS_SCOPE
, RUN_SEQUENCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM MSC.MSC_PLANNING_PROC_ACTIVITIES;
MSC.MSC_PLANNING_PROC_ACTIVITIES does not reference any database object
MSC.MSC_PLANNING_PROC_ACTIVITIES is referenced by following:
|
|
|