MSC_ST_WO_OP_DEPEND_INT
The staging table used by the collection program to validate and process workorder operation dependencies for the MSC_WO_OPERATION_DEPENDENCIES table.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_INSTANCE_CODE | VARCHAR2 | 30 | The source system code for which the data is being collected. | ||
| REFRESH_NUMBER | NUMBER | Indicates the refresh identifier for the collection run. | |||
| ORGANIZATION_ID | NUMBER | 18 | This column indicates the organization identifier. | ||
| ORGANIZATION_CODE | VARCHAR2 | 18 | This column indicates the organization code. | ||
| ITEM_NAME | VARCHAR2 | 300 | This indicates the assembly item on the work order. | ||
| WIP_ENTITY_NAME | VARCHAR2 | 240 | This stores the work order's job name. | ||
| PREV_OP_SEQ_NUM | NUMBER | Operation sequence number of the previous operation on the dependency relation. | |||
| NEXT_OP_SEQ_NUM | NUMBER | Operation sequence number of the next operation on the dependency relation. | |||
| DEPENDENCY_TYPE | NUMBER | 2 | 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. | |||
| ORDER_TYPE | NUMBER | Specifies the supply order type. | |||
| WO_OP_DEPENDENCY_ID | NUMBER | 18 | The source unique identifier of a work operation dependency setup.Its value is an application generated unique id. | ||
| DELETED_FLAG | NUMBER | 2 | Flag indicating whether this is a deleted record. | ||
| PROCESS_FLAG | NUMBER | 2 | Processing Flag indicating the status of records during pre-processing. 1-Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | ||
| ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record. | ||
| ERROR_TEXT | VARCHAR2 | 2000 | Detailed information about the validation errors for this record. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Indicates the request identifier of the job that processed this record. | ||
| 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. |