Search Results mtl_abc_assgn_group_classe_pk1

Overview

The MTL_ABC_ASSGN_GROUP_CLASSES table is a core intersection table within the Oracle E-Business Suite Inventory (INV) module, specifically for the ABC Analysis and Compile process. Its primary function is to define the many-to-many relationship between ABC Assignment Groups and ABC Classes. An ABC Assignment Group is a logical container used to execute an ABC analysis for a specific set of items, while ABC Classes (e.g., A, B, C) categorize items based on their ranking criteria, such as annual usage value. This table acts as a configuration bridge, determining which specific classes are included and analyzed within a given assignment group during the ABC Compile. Its integrity is critical for the accurate classification of inventory items.

Key Information Stored

The table's structure is concise, centering on the relationship between two key entities. The most important columns are the composite primary key, which enforces the unique pairing of a group and a class.

• ASSIGNMENT_GROUP_ID: A foreign key referencing MTL_ABC_ASSIGNMENT_GROUPS.ASSIGNMENT_GROUP_ID. It identifies the specific ABC analysis assignment group.
• ABC_CLASS_ID: A foreign key referencing MTL_ABC_CLASSES.ABC_CLASS_ID. It identifies the specific ABC class (e.g., A, B, C) assigned to the group.

Together, these columns form the primary key (MTL_ABC_ASSGN_GROUP_CLASSE_PK1), ensuring that a given class cannot be redundantly assigned to the same group.

Common Use Cases and Queries

This table is primarily referenced during the setup and execution of ABC analysis and in subsequent reporting. A common operational query is to review the class composition of an assignment group before running the ABC Compile. For example: SELECT ag.ASSIGNMENT_GROUP_NAME, c.CLASS_CODE FROM MTL_ABC_ASSGN_GROUP_CLASSES gc, MTL_ABC_ASSIGNMENT_GROUPS ag, MTL_ABC_CLASSES c WHERE gc.ASSIGNMENT_GROUP_ID = ag.ASSIGNMENT_GROUP_ID AND gc.ABC_CLASS_ID = c.ABC_CLASS_ID AND ag.ASSIGNMENT_GROUP_NAME = '&GROUP_NAME';. This ensures the correct classes are active. Furthermore, the table is essential for joining assignment results back to their defining groups and classes for management reports, such as listing all items classified as 'A' within a particular analysis run. Data in this table is typically maintained via the Oracle Forms interface for ABC Assignment Group setup, not via direct DML.

Related Objects

MTL_ABC_ASSGN_GROUP_CLASSES is a central junction in the ABC analysis schema, with documented foreign key relationships to key master and transaction tables.

• MTL_ABC_ASSIGNMENT_GROUPS: The parent table for assignment groups. Joined via ASSIGNMENT_GROUP_ID.
• MTL_ABC_CLASSES: The parent table for ABC class definitions. Joined via ABC_CLASS_ID.
• MTL_ABC_ASSIGNMENTS: The key transactional table storing the actual item classification results. It has a foreign key relationship referencing the composite primary key of MTL_ABC_ASSGN_GROUP_CLASSES on the columns ASSIGNMENT_GROUP_ID and ABC_CLASS_ID. This ensures that every item assignment record points to a valid, pre-defined group-class combination.