Search Results item_scope_code




Overview
Explore in AI Chat

Overview

MTL_ABC_ASSIGNMENT_GROUPS_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema within the Inventory (INV) product module. According to the ETRM metadata, its documented description is "10SC ONLY," indicating that this view is restricted in scope and is not intended as a general-purpose, broadly supported interface across all EBS implementations. It is classified as a VIEW object with a VALID status, meaning it is present and compiled in the APPS schema for the documented releases (12.1.1 and 12.2.2).

The view presents ABC assignment group configuration data used by the Inventory ABC analysis and compilation process. ABC analysis classifies items into cumulative value buckets (A, B, and C) so that high-value items can be prioritized for cycle counting, planning attention, and inventory control. The view exposes assignment group header information alongside header-level compile attributes, resolving several derived columns — compile name, item scope code, item scope description, and compile statistics — so that consumers do not need to join the underlying ABC tables themselves. Conceptually, it serves reporting and integration consumers who need a denormalized, read-only perspective of ABC assignment groups per organization.

Underlying Base Objects

The view is defined over three referenced base objects as documented in the ETRM metadata:

  • MTL_ABC_ASSIGNMENT_GROUPS (referenced as a SYNONYM) — the primary source for assignment group identity, organization, item scope type, classification method type, secondary inventory flag, descriptive flexfield attributes, and standard WHO/audit columns (creation and last-update information).
  • MTL_ABC_COMPILE_HEADERS (referenced as a SYNONYM) — supplies compile-level data such as compile name, item scope code, description, cumulative value, and compile item counts.
  • MFG_LOOKUPS (referenced as a VIEW) — provides the lookup meaning for the item scope code, restricted to the lookup type MTL_ABC_ITEM_SCOPE.

The join logic links MTL_ABC_ASSIGNMENT_GROUPS to MTL_ABC_COMPILE_HEADERS on COMPILE_ID and ORGANIZATION_ID, with special handling for the case where COMPILE_ID is null but an ORGANIZATION_ID match exists. The lookup join uses a DECODE so that a null COMPILE_ID resolves to lookup code 1 and otherwise resolves to the compile header's ITEM_SCOPE_CODE. The view text uses a distinct query over the assignment group's ROWID, and the derived compile columns are wrapped in DECODE expressions that return NULL when no COMPILE_ID is present.

Key Columns

Common Use Cases and Queries

This view is typically consumed for reporting on ABC assignment group configuration and for validating that compile definitions are correctly associated with organizations. A representative query listing all assignment groups for an organization follows:

  • SELECT assignment_group_id, assignment_group_name, compile_name, item_scope_code, item_scope_description, classification_method_type, number_of_items
  • FROM mtl_abc_assignment_groups_v
  • WHERE organization_id = :org_id
  • ORDER BY assignment_group_name;

Because the view resolves the lookup meaning and compile metrics, it is well suited to diagnostic and administrative reporting without directly touching MTL_ABC_ASSIGNMENT_GROUPS and MTL_ABC_COMPILE_HEADERS. Given the "10SC ONLY" designation in the ETRM metadata, implementers should confirm support for their specific release and avoid treating this view as a guaranteed, upgrade-stable public API.