MSC_WO_OPERATION_DEPENDENCIES
This table stores work order operation-level dependencies for collected data and for all plans.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_WO_OP_DEP_PK |
PLAN_ID, PART_KEY1, DEPENDENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PLAN_ID | NUMBER | 18 | Yes | This value indicates the plan identifier for the record. | |
| PART_KEY1 | NUMBER | 18 | Yes | Source application instance identifier for the work order dependency. | |
| DEPENDENCY_ID | NUMBER | 18 | Yes | Dependency Identifier generated for the work order operation dependencies. This is a sequence generated value. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column indicates the organization identifier. | |
| WO_OP_DEPENDENCY_ID | NUMBER | 18 | The source unique identifier of a work operation dependency setup.Its value is an application generated unique id. | ||
| SUPPLY_ID | NUMBER | 18 | Yes | This value indicates the supply identifier of the work order in msc_supplies. | |
| PREV_OP_SEQ_NUMBER | NUMBER | Yes | Operation sequence number of the previous operation on the dependency relation. | ||
| NEXT_OP_SEQ_NUMBER | NUMBER | Yes | Operation sequence number of the next operation on the dependency relation. | ||
| DEPENDENCY_TYPE | NUMBER | 2 | Yes | Indicated the type of dependency between the specified previous and next operations. | |
| TRANSFER_PERCENT | NUMBER | Indicates the percent of batch quantity that is transferred between previous and next work operation in the operation dependency setup.For the first operation dependency if the batch quantity is of type calculated batch quantity, the transfer percentage is left null. For the last operation dependency, the transfer percentage is left null. | |||
| REFRESH_NUMBER | NUMBER | Indicates the refresh identifier for the collection run. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_WO_OP_DEP_N1 | Non Unique | Default | PLAN_ID, PART_KEY1, ORGANIZATION_ID, SUPPLY_ID, PREV_OP_SEQ_NUMBER, NEXT_OP_SEQ_NUMBER |
| MSC_WO_OP_DEP_N2 | Non Unique | Default | PLAN_ID, PART_KEY1, WO_OP_DEPENDENCY_ID |
| MSC_WO_OP_DEP_U1 | Unique | Default | PLAN_ID, PART_KEY1, DEPENDENCY_ID |