This table requires activation of Component Shortage functional area. This table contains Material Selection Criteria.
Module:
MA_SELECTION_CRITERIA_ID
| 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.