Search Results cumulative_item_percent

Overview

APPS.MTL_ABC_COMPILES_V is a supplementary view in the Oracle E-Business Suite Inventory (INV) module, owned by the APPS schema and registered under FND Design Data as INV.MTL_ABC_COMPILES_V. It exposes the results of ABC compilation runs executed against inventory organizations, presenting the per-item statistics, cumulative totals, and percentage breakdowns that classify on-hand inventory into ABC categories (A, B, and C) based on value and quantity contribution. The view is documented as a "supplementary view used to simplify forms coding," so its primary purpose is to support the ABC Compile and ABC Analysis forms rather than to serve as a public integration interface. Oracle explicitly warns that the view may change dramatically in subsequent minor or major releases, and does not recommend that customers query or alter data through it directly. In Oracle EBS 12.1.1 and 12.2.2 the view remains VALID and stable in structure, but the documented base objects and the warning together indicate that any read access should be treated as informational rather than as a supported API.

Underlying Base Objects

The ETRM 12.2.2 metadata documents three referenced base objects, each accessed through public synonyms:

• MTL_ABC_COMPILES — the detail table holding one row per item per ABC compilation, including quantities, values, and cumulative figures.
• MTL_ABC_COMPILE_HEADERS — the header table holding one row per compilation run, storing the compile name, type, status, item count, and compile date.
• MTL_SYSTEM_ITEMS — the item master, supplying the item description and related item attributes joined to each compiled item.

The view therefore joins the ABC compilation header to its detail lines and enriches each line with item master information, so that a single query returns a self-describing compilation result without requiring the caller to know the internal foreign key relationships between the ABC tables and inventory items.

Key Columns

The view exposes a wide set of columns. The identifier and header columns include COMPILE_ID, COMPILE_NAME, COMPILE_TYPE, COMPILE_STATUS, COMPILE_ITEMS, and COMPILE_DATE, which describe the ABC compilation run itself. The item-level columns include INVENTORY_ITEM_ID, ITEM_DESCRIPTION, ITEM_SCOPE_CODE, and SEQUENCE_NUMBER, identifying the item and its position in the ordered compilation.

The quantitative and value columns are the analytical core of the view:

• COMPILE_QUANTITY and COMPILE_VALUE — the quantity and value of the item for the compilation.
• CUMULATIVE_QUANTITY and CUMULATIVE_VALUE — running totals across the ordered compilation.
• ITEM_PERCENT and VALUE_PERCENT — the individual item's percentage contribution to total quantity and value.
• CUMULATIVE_ITEM_PERCENT and CUMULATIVE_VALUE_PERCENT — the cumulative percentage of items and cumulative percentage of value up to and including the current row.

CUMULATIVE_VALUE_PERCENT is the column reflected in the user's search term; it is the running value percentage used to draw the ABC classification boundaries (for example, items accumulating to the first configured value threshold are class A). Additional columns include ORGANIZATION_ID, SECONDARY_INVENTORY, INVENTORY_TYPE, COST_CODE, COST_TYPE, the ATTRIBUTE1 through ATTRIBUTE15 descriptive flexfield segments, and standard WHO audit columns such as LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATE_LOGIN. A ROW_ID column provides the row identifier.

Common Use Cases and Queries

Typical usage is ad hoc reporting on ABC classification results for a given organization, for example extracting the items that fall into the A class based on cumulative value percentage, auditing compilation status, or reproducing the ABC curve used in cycle count planning. Because the view is not a supported interface, queries should be restricted to read-only, diagnostic use.

A representative query that lists the highest-value contributors within a compilation, ordered by cumulative value percent, follows:

• SELECT compile_id, compile_name, inventory_item_id, item_description, compile_value, cumulative_value, cumulative_value_percent FROM apps.mtl_abc_compiles_v WHERE organization_id = :org_id AND compile_status = 3 ORDER BY compile_id, sequence_number;

A second pattern retrieves only the rows whose CUMULATIVE_VALUE_PERCENT is at or below a configured class A threshold, which is the practical expression of the searched column:

• SELECT inventory_item_id, item_description, compile_value, cumulative_value_percent FROM apps.mtl_abc_compiles_v WHERE compile_id = :compile_id AND cumulative_value_percent <= 80 ORDER BY sequence_number;

In both cases the caller should treat results as informational and, where a supported integration is required, prefer the underlying ABC compilation concurrent program outputs or the base tables documented above.