WIS_STD_OPERATION_RESOURCES_

This table stores the resource requirements for a given standard operation definition.

Details

  • Schema: FUSION

  • Object owner: WIS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

WIS_STD_OP_RESOURCES_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, STD_OPERATION_RESOURCE_ID

Columns

Name Datatype Length Precision Not-null Comments
STD_OPERATION_RESOURCE_ID NUMBER 18 Yes The unique identifier of a standard operation resource. 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.
RESOURCE_SEQ_NUMBER NUMBER Defines the actual sequence of the resource used in the operation. Multiple resources can be scheduled to be working concurrently within the same operation. Simultaneity is implemented by having more than one resource with the same sequence number.
ASSIGNED_UNITS NUMBER Indicates the number of resource instances assigned to this operation.
USAGE_RATE NUMBER The resource usage rate to yield one unit of product.
UOM_CODE VARCHAR2 3 Represents the unit of measure code of the resource usage rate.
BASIS_TYPE VARCHAR2 30 Indicates whether the resource usage is fixed (i.e. usage per lot produced) or variable (i.e. usage per item produced). Valid values exist in the lookup with lookup type = EGP_BOM_BASIS_TYPE.
SCHEDULE_TYPE VARCHAR2 30 Indicates if this resource is scheduled or not. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_SCHEDULE.
PRINCIPAL_FLAG VARCHAR2 1 When two or more resources are running in parallel (i.e. simultaneous resources which have the same sequence number), one and only one of them must be marked as the principal/primary resource. Planning will identify bottlenecks if the principal resource is not available when checking for capacity.
CHARGE_TYPE VARCHAR2 30 Indicates how the resource is charged during work execution. Valid values exist in the lookup with lookup type = ORA_WIS_CHARGE_TYPE.
RESOURCE_ACTIVITY_CODE VARCHAR2 30 Indicates the activity this production resource is going to perform at this operation. Valid values exist in the lookup with lookup type = ORA_WIS_RESOURCE_ACTIVITY.
INVERSE_USAGE_RATE NUMBER Indicates the inverse resource usage rate.
STANDARD_OPERATION_ID NUMBER 18 Reference to the standard operation to which this resource is assigned.
WORK_CENTER_ID NUMBER 18 Indicates the work center where this resource resides.
RESOURCE_ID NUMBER 18 Indicates the resource assigned to the standard operation.
PROFILE_ID NUMBER 18 Foreign key reference to HCM model profiles.
EQP_QUAL_PROFILE_ID NUMBER 18 Foreign key reference to equipment qualification profiles.
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.
ATTRIBUTE_CATEGORY VARCHAR2 80 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR16 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR17 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR18 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR19 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR20 VARCHAR2 240 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
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 Name.

Indexes

Index Uniqueness Tablespace Columns
WIS_STD_OPER_RESOURCES_N1_ Non Unique Default STD_OPERATION_RESOURCE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY
WIS_STD_OPER_RESOURCES_N2_ Non Unique Default AUDIT_ACTION_TYPE_
WIS_STD_OPER_RESOURCES_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, STD_OPERATION_RESOURCE_ID
WIS_STD_OPER_RESOURCES_U2_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, STANDARD_OPERATION_ID, RESOURCE_SEQ_NUMBER, RESOURCE_ID