# DW_MFG_MA_RULES_G (Preview)

This table requires activation of Component Shortage functional area. This table contains Material Availability Rules.

## Details

Module:

## Key Columns

MA_RULE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
MA_RULE_ID | NUMBER | 38 | 0 | True | Material Availability Rule 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 this material availability rule belongs. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
RULE_TYPE | VARCHAR2 | 32 |  |  | Represents the type of rule for this material availability rule. Values represent either a work order assignment sequence or force assignment or exclude material. |  |
RULE_SEQ_NUMBER | NUMBER |  |  |  | Used to store the rule sequence entered by the user for calculating work order assignment sequence. |  |
MA_RULE_ATTRIBUTE_ID | NUMBER | 38 | 0 |  | Represents the corresponding rule attribute used by this rule line. | DW_MFG_MA_RULE_ATTRIBUTES_TL | MA_RULE_ATTRIBUTE_ID
RULE_ATTRIBUTE_VALUE | VARCHAR2 | 999 |  |  | Stores the attribute value for the corresponding rule attribute record. It is not applicable and will be null for rules based on sort order. |  |
SORT_ORDER_CODE | VARCHAR2 | 32 |  |  | Indicates whether the rule line is sort based or not. If it is sort based then it records the appropriate sort order as ORA_ASC (ascending) or ORA_DESC (descending). Null value in this column indicates that the rule is based on RULE_ATTRIBUTE_VALUE. | DW_ORA_WIE_MA_RULE_SORTORDER_LKP_TL | ORA_WIE_MA_RULE_SORTORDER_CODE
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.