# DW_MFG_MA_SELECTION_CRITERIA_G (Preview)

This table requires activation of Component Shortage functional area. This table contains Material Selection Criteria.

## Details

Module:

## Key Columns

MA_SELECTION_CRITERIA_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
MA_SELECTION_CRITERIA_ID | NUMBER | 38 | 0 | True | Material Availability Selection Criteria Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated |  |
ORGANIZATION_ID | NUMBER | 38 | 0 |  | The organization identifier that represents the manufacturing plant to which the selection criteria belongs. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
TIME_FENCE_BASIS_CODE | VARCHAR2 | 32 |  |  | Indicates the time basis to pick up the work orders. | DW_ORA_WIE_MA_TIME_FENCE_BASIS_LKP_TL | ORA_WIE_MA_TIME_FENCE_BASIS_CODE
TIME_FENCE | NUMBER |  |  |  | Stores the time fence value in hours. |  |
WORK_ORDER_STATUS_IDS | VARCHAR2 | 512 |  |  | Stores a comma separated list of work order status identifiers to be included for material assignment. |  |
WORK_ORDER_TYPES | VARCHAR2 | 512 |  |  | Stores a comma separated list of work order types to be included for material assignment. |  |
WORK_ORDER_SUB_TYPES | VARCHAR2 | 999 |  |  | Stores a comma separated list of work order sub types to be included for material assignment. |  |
SUPPLY_TYPES | VARCHAR2 | 512 |  |  | Stores a comma separated list of supply types to be included for material assignment. |  |
MAKE_ITEM_FLAG | VARCHAR2 | 16 |  |  | Flag used to indicate whether items that are manufactured internally should be included for material assignment. |  |
CREATED_BY | VARCHAR2 | 128 |  |  | Indicates the user who created the row. | DW_USER_D | USERNAME
CREATION_DATE | TIMESTAMP |  |  |  | Creation Timestamp |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Last Update Timestamp |  |

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