WIE_MA_MTL_ASSIGNMENTS
This table stores the assignment and shortage information for each material, populated during material assignment.
Details
-
Schema: FUSION
-
Object owner: WIE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIE_MA_MTL_ASSIGNMENTS_PK |
MA_MTL_ASSIGNMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MA_MTL_ASSIGNMENT_ID | NUMBER | 18 | Yes | The unique identifier of the material availability assignments record. Its value is an application generated unique id. | |
| 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. | |
| WORK_ORDER_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order for which the material is being assigned. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which the material belongs. | |
| WO_OPERATION_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order operation for which the material is being assigned. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Represents the internal identifier of the material that is being assigned. | |
| WO_OPERATION_MATERIAL_ID | NUMBER | 18 | Yes | Represents the internal identifier of the work order operation material. This is a foreign key to the WIE_WO_OPERATION_MATERIALS. | |
| AVAILABLE_QUANTITY | NUMBER | Yes | Represents the total available on-hand quantity for an item. | ||
| PROJECTED_AVAILABLE_QUANTITY | NUMBER | Yes | Represents the quantity available to assign. | ||
| REQUIRED_QUANTITY | NUMBER | Quantity of the material consumed in the operation. This is usually the Work Order Quantity times the QUANTITY_PER_ASSEMBLY when the basis type is VARIABLE. | |||
| ALLOCATED_QUANTITY | NUMBER | The total allocated quantity for a work order material. | |||
| PICKED_QUANTITY | NUMBER | The total picked quantity for a work order material. | |||
| OPEN_QUANTITY | NUMBER | Yes | Represents the quantity required for that operation. | ||
| NET_OPEN_QUANTITY | NUMBER | Represents the total quantity required for that operation. | |||
| ASSIGNED_QUANTITY | NUMBER | Yes | Represents the quantity assigned for the material. | ||
| SHORTAGE_QUANTITY | NUMBER | Yes | Represents the shortage if any for the material. | ||
| EXPECTED_QUANTITY | NUMBER | Yes | Represents the expected supply if any for the material. | ||
| RESERVED_QUANTITY | NUMBER | This column represents the total quantity reserved against the work order material. | |||
| UNRESERVED_ALLOCATED_QUANTITY | NUMBER | This column represents the allocated quantity which does not have corresponding reservations in the INV_RESERVATIONS table. | |||
| UOM_CODE | VARCHAR2 | 3 | Yes | Represents the unit of measure code for all quantities stored in this table. | |
| CALCULATION_DATE | TIMESTAMP | Yes | Represents the date/time at which the material has been assigned. | ||
| USE_COMMON_INVENTORY_FLAG | VARCHAR2 | 1 | Flag to determine whether material should be issued/returned from common inventory or from the project associated with the work order. A value of Y indicates material should be issued/returned from common inventory. A value of N indicates material should be issued/returned from the project associated with the work order. | ||
| PJC_PROJECTED_AVAILABLE_QTY | NUMBER | Represents the quantity available to assign from project striped inventory. | |||
| COMMON_PROJECTED_AVAILABLE_QTY | NUMBER | Represents the quantity available to assign from common inventory. | |||
| PJC_AVAILABLE_QUANTITY | NUMBER | Represents the available on-hand quantity for an item from project striped inventory. | |||
| COMMON_AVAILABLE_QUANTITY | NUMBER | Represents the available on-hand quantity for an item from common inventory. | |||
| PJC_ASSIGNED_QUANTITY | NUMBER | Represents the quantity assigned for the material from project striped inventory. | |||
| COMMON_ASSIGNED_QUANTITY | NUMBER | Represents the quantity assigned for the material from common inventory. | |||
| PJC_EXPECTED_QUANTITY | NUMBER | Represents the expected supply for the material when the PROJECT_REFERENCE_ENABLED flag is set to 'Y' for the organization. The value is the sum of project/task supplies associated with the work order and common supplies. | |||
| SUBSTITUTE_FLAG | VARCHAR2 | 1 | Flag used indicate whether this component is a substitute or not. Valid values: Y - Substitute N or null - Primary component | ||
| 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. | ||
| 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 |
|---|---|---|
| WIE_MA_MTL_ASSIGNMENTS | wie_work_orders_b | WORK_ORDER_ID |
| WIE_MA_MTL_ASSIGNMENTS | wie_wo_operations_b | WO_OPERATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| WIE_MA_MTL_ASSIGNMENTS_N01 | Non Unique | Default | WORK_ORDER_ID |
| WIE_MA_MTL_ASSIGNMENTS_N02 | Non Unique | Default | WO_OPERATION_ID |
| WIE_MA_MTL_ASSIGNMENTS_N03 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID |
| WIE_MA_MTL_ASSIGNMENTS_U01 | Unique | Default | MA_MTL_ASSIGNMENT_ID |
| WIE_MA_MTL_ASSIGNMENTS_U02 | Unique | Default | WO_OPERATION_MATERIAL_ID |