# DW_MFG_MA_ASSIGNMENTS_MAP_G (Preview)

This table requires activation of Component Shortage functional area. This table contains Material Assignments and Shortage Details for a Work Order Operation Material.

## Details

Module:

## Key Columns

ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Material Availability Assignments Identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated |  |
MA_SEQ_ASSIGNMENT_SEQUENCE_ID | NUMBER | 38 | 0 |  | Material Availability Assignment Sequences Identifier |  |
MA_SEQ_ASSIGNMENT_SEQ_NUMBER | NUMBER |  |  |  | Priority sequence number assigned for the work order. |  |
WORK_ORDER_ID | NUMBER | 38 | 0 |  | The unique identifier of work order record | DW_MFG_WORK_ORDERS_TL | WORK_ORDER_ID
WO_OPERATION_ID | NUMBER | 38 | 0 |  | The unique identifier of the operation that uses this material. | DW_MFG_OPERATIONS_TL | WO_OPERATION_ID
WO_OPERATION_MATERIAL_ID | NUMBER | 38 | 0 |  | The unique identifier of the Operation Material. |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | The organization identifier that represents the manufacturing plant to which this work order belongs. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
REQUIRED_ITEM_ID | NUMBER | 38 | 0 |  | The unique identifier of the Required Material used in the operation. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
CALCULATION_TIMESTAMP | TIMESTAMP |  |  |  | Represents the timestamp at which the material has been assigned. |  |
CALCULATION_DATE | DATE |  |  |  | Represents the date at which the material has been assigned. | DW_DAY_D | CALENDAR_DATE
WORK_ORDER_MATERIAL_UOM_CODE | VARCHAR2 | 16 |  |  | Represents the unit of measure code of the material quantities. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
AVAILABLE_QUANTITY | NUMBER |  |  |  | Available on-hand quantity for an item. |  |
PROJECTED_AVAILABLE_QUANTITY | NUMBER |  |  |  | Quantity assigned for this workorder based on priority |  |
REQUIRED_QUANTITY | NUMBER |  |  |  | Work Order Material quantity. |  |
OPEN_QUANTITY | NUMBER |  |  |  | Quantity required for that operation |  |
RESERVED_QUANTITY | NUMBER |  |  |  | Quantity Reserved for that work order material |  |
ALLOCATED_QUANTITY | NUMBER |  |  |  | Quantity allocated for that work order material |  |
PICKED_QUANTITY | NUMBER |  |  |  | Quantity picked for that work order material |  |
SHORTAGE_QUANTITY | NUMBER |  |  |  | Shortage quantity for that work order material |  |
EXPECTED_QUANTITY | NUMBER |  |  |  | Expected Quantity supply for that material |  |
SUBSTITUTE_FLAG | VARCHAR2 | 16 |  |  | Flag used indicate whether this component is a substitute or not. Valid values: Y - Substitute, N or null - Primary component |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Material Assignments Created By | DW_USER_D | USERNAME
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Creation Date of Material Availability Assignments |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Last Update Date of Material Availability Assignments |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | The unique identifier of the Work Order's Finished Item i.e. the primary product #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
WORK_ORDER_UOM_CODE | VARCHAR2 | 16 |  |  | Represents the unit of measure code of the work order quantities. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
PLANNED_START_QUANTITY | NUMBER |  |  |  | Refers to the planned work order quantity which should be greater than zero for standard work orders, and can be equal to or greater than zero for non standard work orders |  |
MA_SEQ_PUOM_CONVERSION_FACTOR | NUMBER |  |  |  | PUOM Conversion factor from Work Order UOM to Finished Item's Primary UOM |  |
MA_SEQ_PUOM_CODE | VARCHAR2 | 16 |  |  | PUOM Code for Finished Item's Primary UOM | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
MA_SEQ_PUOM_PLANNED_START_QUANTITY | NUMBER |  |  |  | Refers to the planned work order quantity in the Finished Item's Primary UOM |  |
MA_SEQ_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Creation date of Material Availability Assignments Sequence |  |
MA_SEQ_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Last Update Date of Material Availability Assignments Sequence |  |
BOM_RATIO | NUMBER |  |  |  | BOM Ratio using the Primary UOM for Finished Item and Operation Materials |  |
MA_SEQ_PUOM_EXPECTED_PRODUCTION_QUANTITY | NUMBER |  |  |  | Expected Production Quantity for Finished Item in Primary UOM at Operation Materials level |  |

## Notes

#1 In these cases in addition to the Item ID columns, ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D

Copyright © 2019, 2026, Oracle and/or its affiliates.