1. Tables and Views for SCM
  2. MSC_ST_ROUTING_OP_DEPEND_INT

MSC_ST_ROUTING_OP_DEPEND_INT

The staging/interface table used by the collection program to validate and process routing/work definition operation dependency data for table MSC_ROUTING_OP_DEPENDENCIES.

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.
ASSEMBLY_NAME VARCHAR2 300 Indicates the assembly name for the routing.
ORGANIZATION_CODE VARCHAR2 18 This column indicates the organization code.
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 30 Specifies the name of the routing or work definition.
PREVIOUS_OP_SEQ_NUM NUMBER Operation sequence number of the previous operation on the dependency relation.
PREV_OP_EFFECTIVITY_DATE DATE Indicates the date on which the previous operation became effective.
NEXT_OP_SEQ_NUM NUMBER Operation sequence number of the next operation on the dependency relation.
NEXT_OP_EFFECTIVITY_DATE DATE Indicates the date when the next operation becomes effective.
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.
VERSION_EFFECTIVITY_DATE DATE This column indicates Work Definition Version start Date.
VERSION_DISABLE_DATE DATE This column indicates Work Definition Version end Date.
STATUS_CODE VARCHAR2 30 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.
ASSEMBLY_ITEM_ID NUMBER 18 Indicates the Item identifier of the assembly.
ORGANIZATION_ID NUMBER 18 This column indicates the organization identifer.
ROUTING_SEQUENCE_ID NUMBER 18 Routing sequence identifier for the routing/work definition.
PREVIOUS_OP_SEQ_ID NUMBER 18 Operation sequence identifier of the previous operation on thedependency relation.
NEXT_OP_SEQ_ID NUMBER 18 Operation sequence identifier of the next operation on the dependency relation.
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.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
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_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.