WIE_WO_ASSETS

This table is used to store the assets that are being maintained on the maintenance work order.

Details

• Schema: FUSION

• Object owner: WIE

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
WIE_WO_ASSETS_PK	WO_ASSET_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WO_ASSET_ID	NUMBER		18	Yes	Represents the internal identifier of the work order asset record.
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.
ORGANIZATION_ID	NUMBER		18	Yes	Identifier of the organization associated to this work order asset.
WORK_ORDER_ID	NUMBER		18	Yes	Represents the foreign key to the work order that this asset is associated.
ASSET_ID	NUMBER		18	Yes	Represents the unique identifier of the asset that is being maintained on this work order.
WARRANTY_REPAIR_FLAG	VARCHAR2	1			Flag to indicate that the work performed in this work order is covered by a supplier warranty.
MATCH_TO_TXN_CODE_FLAG	VARCHAR2	1			Flag to indicate that the transactions performed in this work order must be coded with predefined transaction codes.
REASON_FOR_REPAIR_CODE_ID	NUMBER		18		The specific reason for repair for which the work order is created. This is a foreign key to the CSE_CONDITION_EVENT_CODES_B table.
LAST_WO_OPERATION_ID	NUMBER		18		The last operation completed for the asset on the work order.
MNT_COMPLETE_FLAG	VARCHAR2	1			Flag indicating whether the work is complete for the asset.
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
WIE_WO_ASSETS	wie_work_orders_b	WORK_ORDER_ID

Indexes

Index	Uniqueness	Tablespace	Columns
WIE_WO_ASSETS_N01	Non Unique	Default	ASSET_ID
WIE_WO_ASSETS_U01	Unique	Default	WO_ASSET_ID
WIE_WO_ASSETS_U02	Unique	Default	WORK_ORDER_ID, ASSET_ID