Search Results item_scope_type




Overview
Explore in AI Chat

Overview

MTL_ABC_ASSGNMNT_GROUPS_ALL_V is an Oracle E-Business Suite view owned by the APPS schema in the Inventory (INV) product module. It is documented in ETRM as "10SC ONLY," indicating that the object is delivered specifically in support of the 10SC (ten-step cycle count / ABC classification) functionality rather than as a general-purpose Inventory interface. The view is marked VALID and is registered against Oracle EBS 12.1.1 and 12.2.2.

Functionally, the view exposes ABC assignment group definitions used by Oracle Inventory's ABC analysis and cycle counting processes. ABC assignment groups allow planners to combine an organization, a compilation run, an item scope, and a classification method into a reusable definition that drives how items are ranked into ABC classes. Because the view is a thin projection over its base table, it presents the same attribute set as the underlying entity while providing the APPS-owned, ALL-style naming convention expected by reporting and integration tools. It contains no view-level filters beyond those in the view text supplied in the metadata.

Underlying Base Objects

The view is defined over a single base object: MTL_ABC_ASSIGNMENT_GROUPS, referenced in the documented metadata as a SYNONYM in the APPS schema. The view text is a pure column projection, selecting every column from the base table without joins, unions, or aggregation.

  • MTL_ABC_ASSIGNMENT_GROUPS — the physical ABC assignment group definition table in Oracle Inventory.
  • No other tables, views, or outer joins are documented in the view text.
  • Because there is a one-to-one column and row correspondence, row counts and primary key values in the view match the base table exactly.

Key Columns

The view exposes thirty-one columns. The most significant from a functional and query perspective are:

Common Use Cases and Queries

The view is typically consumed by ABC classification reporting, cycle count setup validation, and integration extracts that must reconcile assignment groups between environments. Because it is a direct projection, it can be queried anywhere the base table is accessible under APPS.

  • Listing assignment groups by organization and classification method.
  • Identifying groups tied to a specific compilation run.
  • Extracting group definitions with descriptive flexfield attributes for downstream analytics.

Sample query:

  • SELECT assignment_group_id, assignment_group_name, organization_id, classification_method_type, item_scope_type FROM mtl_abc_assgnmnt_groups_all_v WHERE organization_id = :p_org_id ORDER BY assignment_group_name;

A second common pattern joins the view to MTL_ABC_COMPILES or ABC class assignment tables to validate that grouping and classification results are consistent within a given organization and compilation run.