RCS_WC_RESOURCE_EXC_DETAILS

This table contains the details of the work center resources in the set of participants in the exception. Each record indicates the change to the units available value for the work center resource.

Details

• Schema: FUSION

• Object owner: RCS

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
RCS_WC_RESOURCE_EXC_DETAI_PK	WC_RES_EXC_DETAIL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
WC_RES_EXC_DETAIL_ID	NUMBER		18	Yes	Work center resource exception detail identifier.
WC_RESOURCE_EXC_ID	NUMBER		18		Foreign key of the work center resource exception.
WC_ID	NUMBER		18		Foreign key of the work center the exception is for.
RESOURCE_ID	NUMBER		18		Foreign key of the manufacturing resource the exception is for.
EXC_UNITS_AVAILABLE	NUMBER				Override quantity value. This replaces the default units available for the time interval defined by the parent exception.
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
WC_RESOURCE_EXC_DETAILS_U1	Unique	FUSION_TS_TX_IDX	WC_RES_EXC_DETAIL_ID