WIE_WO_OP_DEPENDENCIES_

This table stores parallel operation dependencies between the various execution steps required for a given work order. These steps include the processes that are necessary to produce a given product.

Details

• Schema: FUSION

• Object owner: WIE

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
WIE_WO_OP_DEPENDENCIES_PK_	LAST_UPDATE_DATE, LAST_UPDATED_BY, WO_OP_DEPENDENCY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WO_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		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_ORDER_ID	NUMBER		18		Represents the work order identifier that is the foreign key to the WIE_WORK_ORDERS_B table.
FROM_WO_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 WIE_WO_OPERATIONS_B table.
TO_WO_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 WIE_WO_OPERATIONS_B table.
DEPENDENCY_TYPE	VARCHAR2	30			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.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP				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.
AUDIT_ACTION_TYPE_	VARCHAR2	10			Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_	VARCHAR2	1000			Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_	VARCHAR2	64			Original Impersonator User.

Indexes

Index	Uniqueness	Tablespace	Columns
WIE_WO_OP_DEPENDENCIES_N1_	Non Unique	Default	WO_OP_DEPENDENCY_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY
WIE_WO_OP_DEPENDENCIES_N2_	Non Unique	WIE_WO_OP_DEPENDENCIES_N2_	AUDIT_ACTION_TYPE_
WIE_WO_OP_DEPENDENCIES_U01_	Unique	Default	LAST_UPDATE_DATE, LAST_UPDATED_BY, WO_OP_DEPENDENCY_ID
WIE_WO_OP_DEPENDENCIES_U02_	Unique	Default	LAST_UPDATE_DATE, LAST_UPDATED_BY, WORK_ORDER_ID, FROM_WO_OPERATION_ID, TO_WO_OPERATION_ID