[Home] [Help] [Dependency Information]
Object Name: | MSC_CRITICAL_PATHS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_CRITICAL_PATHS |
Subobject Name: | |
Status: | VALID |
Table created for Improved Exceptions
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_CRITICAL_PATHS_N1 | NORMAL | NONUNIQUE |
PLAN_ID
SR_INSTANCE_ID DEMAND_ID SUPPLY_ID ROUTING_SEQUENCE_ID OPERATION_SEQUENCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Plan identifier | |
SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
ROUTING_SEQUENCE_ID | NUMBER | Source application identifier for that routing | ||
OPERATION_SEQUENCE_ID | NUMBER | Source application identifier for that operation | ||
DEMAND_ID | NUMBER | Yes | Demand Identifier | |
SUPPLY_ID | NUMBER | Yes | Supply Identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
LEVEL_NUMBER | NUMBER | The level of operation in the demand | ||
PATH_NUMBER | NUMBER | The number of critical in this demand | ||
TIME_GAP | NUMBER | The gap between this level's operation and previous level's operations in minutes | ||
EARLIEST_START_DATE | DATE | |||
EARLIEST_END_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, SR_INSTANCE_ID
, ROUTING_SEQUENCE_ID
, OPERATION_SEQUENCE_ID
, DEMAND_ID
, SUPPLY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, LEVEL_NUMBER
, PATH_NUMBER
, TIME_GAP
, EARLIEST_START_DATE
, EARLIEST_END_DATE
FROM MSC.MSC_CRITICAL_PATHS;
MSC.MSC_CRITICAL_PATHS does not reference any database object
MSC.MSC_CRITICAL_PATHS is referenced by following:
|
|
|