Search Results default_abc_assignment_group

Overview

The MRP_DEFAULT_ABC_ASSIGNMENT_GROUPS view, owned by the APPS schema, is a lightweight reporting object within the Oracle E-Business Suite Master Scheduling/MRP (MRP) product family. Its purpose is to resolve, for each inventory organization configured in Oracle Master Scheduling/MRP, the single ABC assignment group that has been designated as the default. ABC assignment groups are the mechanism by which Oracle Advanced Supply Chain Planning and related MRP processes classify inventory items into A, B, and C categories based on criteria such as annual dollar usage or transaction volume.

Rather than persisting a default flag directly on the assignment group record, Oracle stores the default selection in the MRP parameters table. The view bridges these two structures, joining the organization-level planning parameter (DEFAULT_ABC_ASSIGNMENT_GROUP) to the corresponding row in MTL_ABC_ASSIGNMENT_GROUPS. The result is a simple, denormalized result set listing the assignment group name, its surrogate identifier, and the owning organization. This design allows reports, concurrent programs, and integrations to retrieve the active default without embedding the join logic themselves, and it keeps a consistent definition available across the MRP module.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two base objects, both referenced through APPS synonyms:

• MRP_PARAMETERS — the organization-level planning parameters table. For each ORGANIZATION_ID it holds the DEFAULT_ABC_ASSIGNMENT_GROUP column, which references the assignment group chosen as the default for that organization.
• MTL_ABC_ASSIGNMENT_GROUPS — the assignment group definition table, keyed by ASSIGNMENT_GROUP_ID and ORGANIZATION_ID, and carrying the human-readable ASSIGNMENT_GROUP_NAME.

The view text joins these two sources on two conditions simultaneously: the organization identifiers must match (G.ORGANIZATION_ID = P.ORGANIZATION_ID), and the assignment group identifier in MTL_ABC_ASSIGNMENT_GROUPS must equal the default value in MRP_PARAMETERS (ASSIGNMENT_GROUP_ID = DEFAULT_ABC_ASSIGNMENT_GROUP). This ensures the returned group is both organizationally scoped and the one currently flagged as default. Because both sides are synonyms to the underlying EBS tables, the view inherits the standard APPS security and grants model.

Key Columns

• ASSIGNMENT_GROUP_NAME — the descriptive name of the default ABC assignment group for the organization; the most commonly referenced column in reports and lookups.
• ORGANIZATION_ID — the inventory organization identifier (from the MRP_PARAMETERS side of the join), providing the organizational context for the default assignment.
• ASSIGNMENT_GROUP_ID — the surrogate primary key of the assignment group in MTL_ABC_ASSIGNMENT_GROUPS; useful for joins to ABC compilation and assignment tables.

Common Use Cases and Queries

Typical uses include validating which ABC group drives classification for an organization, driving concurrent report parameters, and feeding downstream integrations that need the current default group identifier. A representative query returning all default assignments is:

• SELECT assignment_group_name, organization_id, assignment_group_id FROM mrp_default_abc_assign_view ORDER BY organization_id; — enumerates the default ABC group for every organization.
• SELECT assignment_group_id FROM mrp_default_abc_assign_view WHERE organization_id = :org_id; — resolves the default group identifier for a specific organization, commonly used in PL/SQL or a report parameter list.
• Joining the returned ASSIGNMENT_GROUP_ID to ABC classification tables allows analysts to trace which group's item designations are active for planning.

Because the view contains only rows where a default has been configured, organizations with no DEFAULT_ABC_ASSIGNMENT_GROUP value in MRP_PARAMETERS will not appear. Consumers should therefore treat an empty result as an indication that no default ABC assignment group has been set for that organization.