MSS_OP_RESOURCE_SET_MEMBERS

This table stores operation resource set member information. Information in this table is a snapshot of data from WIS_WD_OPERATION_RESOURCES and WIS_WD_OP_ALT_RESOURCES. WIS_WD_OPERATION_RESOURCES.WD_OPERATION_RESOURCE_ID corresponds to an operation resource set in PS, with a RESOURCE_ID as the resource "assigned" to the operation; For each WD_OPERATION_RESOURCE_ID, there are entries in WIS_WD_OP_ALT_RESOURCES table that represents alternate resources, with each RESOURCE_ID in that table represents an alternate resource for WD_OPERATION_RESOURCE_ID (the PS operation set); Data in this table combines the "assigned" resources and "alternate" resources in those 2 tables to form complete operation resource sets.

Details

Schema: FUSION
Object owner: MSS
Object type: TABLE
Tablespace: TRANSACTION_TABLES

Primary Key

Name	Columns
MSS_OP_RES_SET_MEMBERS_PK	PLAN_ID, WD_OPERATION_RESOURCE_ID, RESOURCE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLAN_ID	NUMBER		18	Yes	Identifier of the Production Scheduling plan.
OPERATION_ID	NUMBER		18		Parent Operation ID. Foreign key to the MSS_OPERATIONS table. Null if there is no operation template for resource set members.
RESOURCE_SEQ_NUMBER	NUMBER				Resource sequence number of the operation.
WD_OPERATION_RESOURCE_ID	NUMBER		18	Yes	Represents the work definition operation resource for which the resource or alternate resource is defined. This is a indirect foreign key to the WIS_WD_OPERATION_RESOURCES table.
RESOURCE_SET_CODE	VARCHAR2	100			Code that represents a set of alternate resources.
WORK_CENTER_ID	NUMBER		18	Yes	Indicates the work center where the resource resides.
RESOURCE_ID	NUMBER		18	Yes	Represents the member resource identifier. This is a foreign key to the MSS_RESOURCES table.
RESOURCE_ACTIVITY_NAME	VARCHAR2	80			Indicates the activity name this operation resource is going to perform. Valid values are looked-up from lookup type = ORA_WIS_RESOURCE_ACTIVITY.
PRIMARY_FLAG	VARCHAR2	1			Is this a primary operation resource set member (Y\|N)?
SCHEDULED_FLAG	VARCHAR2	1			Is this operation resource scheduled (Y/N)?
PREFERENCE	NUMBER			Yes	Indicates the order of preference. Planning uses this information to choose the appropriate alternate resource. Preferred resources will use 1 (highest priority)
DURATION	NUMBER			Yes	Time duration of the operation resource.
DURATION_UNIT	VARCHAR2	30			Duration unit: seconds\|minutes\|hours\|days\|weeks
LOT_MULTIPLE	NUMBER				Lot multiple of the operation resource.
CAPACITY_REQUIRED	NUMBER			Yes	Number of alternate resource instances (Labor or Equipment).
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSS_OP_RESOURCE_SET_MEMBERS	mss_resources	PLAN_ID, WORK_CENTER_ID, RESOURCE_ID
MSS_OP_RESOURCE_SET_MEMBERS	mss_operations	PLAN_ID, OPERATION_ID, RESOURCE_SEQ_NUMBER

Indexes

Index	Uniqueness	Tablespace	Columns	Status
MSS_OP_RES_SET_MEMBERS_N1	Non Unique	Default	PLAN_ID, WORK_CENTER_ID, RESOURCE_ID
MSS_OP_RES_SET_MEMBERS_N2	Non Unique	Default	PLAN_ID, OPERATION_ID, RESOURCE_SEQ_NUMBER
MSS_OP_RES_SET_MEMBERS_U1	Unique	Default	PLAN_ID, WD_OPERATION_RESOURCE_ID, RESOURCE_ID	Active