WIS_WD_OP_DEPENDENCIES

This table is used to define the parallel operation dependencies setup that are necessary to manufacture the specified product.

Details

• Schema: FUSION

• Object owner: WIS

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
WIS_WD_OP_DEPENDENCIES_PK	WD_OP_DEPENDENCY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WD_OP_DEPENDENCY_ID	NUMBER		18	Yes	The unique identifier of a work operation dependency setup. Its value is an application generated unique id.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
WORK_DEFINITION_ID	NUMBER		18	Yes	Represents the work definition identifier that is the foreign key to the WIS_WORK_DEFINITIONS table.
WORK_DEFINITION_VERSION_ID	NUMBER		18	Yes	Represents the work definition version identifier that is the foreign key to the WIS_WD_VERSIONS table.
PREVIOUS_WD_OPERATION_ID	NUMBER		18		Represents the previous work operation identifier in the operation dependency setup. A null value in this column represents the start of the operation dependency setup. This is the foreign key to the WIS_WD_OPERATIONS_B table.
NEXT_WD_OPERATION_ID	NUMBER		18		Represents the next work operation identifier in the operation dependency setup. A null value in this column represents the end of the operation dependency setup. This is the foreign key to the WIS_WD_OPERATIONS_B table.
DEPENDENCY_TYPE	VARCHAR2	30		Yes	Indicates the dependency type between previous and next work operations in the operation dependency setup. Valid values exist in the lookup with lookup type = ORA_WIS_DEPENDENCY_TYPE.
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.
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.
ERROR_CODE	VARCHAR2	30			Identifies the validation error that this operation dependency record is facing. This value maps to the MESSAGE_NAME column of the FND_MESSAGES table.
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_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIS_WD_OP_DEPENDENCIES	wis_work_definitions	WORK_DEFINITION_ID
WIS_WD_OP_DEPENDENCIES	wis_wd_operations_b	PREVIOUS_WD_OPERATION_ID
WIS_WD_OP_DEPENDENCIES	wis_wd_operations_b	NEXT_WD_OPERATION_ID
WIS_WD_OP_DEPENDENCIES	wis_wd_versions	WORK_DEFINITION_VERSION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
WIS_WD_OP_DEPENDENCIES_U01	Unique	Default	WD_OP_DEPENDENCY_ID
WIS_WD_OP_DEPENDENCIES_U02	Unique	Default	WORK_DEFINITION_ID, WORK_DEFINITION_VERSION_ID, PREVIOUS_WD_OPERATION_ID, NEXT_WD_OPERATION_ID