MSC_ROUTING_OP_DEPENDENCIES
This table stores the time-phased operation dependencies on the routing/work definition.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MSC_ROUTING_OP_DEP_PK |
PLAN_ID, PART_KEY1, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, VERSION_EFFECTIVITY_DATE, PREVIOUS_OP_SEQ_ID, NEXT_OP_SEQ_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 | Yes | Source system identifier. This is used as the partition key column. | ||
| ASSEMBLY_ITEM_ID | NUMBER | 18 | Yes | Indicates the Item identifier of the assembly. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | This column indicates the organization identifier. | |
| ROUTING_SEQUENCE_ID | NUMBER | 18 | Yes | Routing sequence identifier for the routing/work definition. | |
| PREVIOUS_OP_SEQ_ID | NUMBER | Yes | Operation sequence identifier of the previous operation on the dependency relation. | ||
| NEXT_OP_SEQ_ID | NUMBER | Yes | Operation sequence identifier 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. | |||
| VERSION_EFFECTIVITY_DATE | DATE | Yes | This column indicates Work Definition Version start Date. | ||
| VERSION_DISABLE_DATE | DATE | This column indicates Work Definition Version end Date. | |||
| STATUS_CODE | NUMBER | 2 | Indicates the validation status of the record. It is used internally by process manufacturing for knowing the status of processing the dependencies between operations. Possible values are ERROR - denotes that record has validation errors that need to be resolved, null - denotes that the record is clean of validation errors. | ||
| REFRESH_NUMBER | NUMBER | Indicates the refresh identifier for the collection run. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| WD_OP_DEPENDENCY_ID | NUMBER | 18 | The unique identifier of a work operation dependency setup. Its value is an application generated unique id. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MSC_ROUTING_OP_DEP_N1 | Non Unique | Default | PLAN_ID, PART_KEY1, WD_OP_DEPENDENCY_ID |
| MSC_ROUTING_OP_DEP_U1 | Unique | Default | PLAN_ID, PART_KEY1, ORGANIZATION_ID, ROUTING_SEQUENCE_ID, VERSION_EFFECTIVITY_DATE, PREVIOUS_OP_SEQ_ID, NEXT_OP_SEQ_ID |