Results for “compile_quantity”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

MTL_ABC_COMPILES is an Inventory (INV) module table that stores ABC descending value compile data. ABC analysis classifies inventory items by relative value or consumption so that planners can apply differentiated controls to high-value (Class A), mid-value (Class B), and low-value (Class C) items. MTL_ABC_COMPILES holds the compiled result rows produced by the ABC compile process, capturing per-item, per-organization, and per-subinventory ranked values and cumulative totals that drive those classifications.

The table belongs to the INV schema and is documented as VALID in ETRM for both Oracle EBS 12.1.1 and 12.2.2, with a documented physical schema of 19 columns. Based on the foreign key topology, the heuristic Data Vault classification for this object is link — a modeling suggestion that reflects its role as an associative table connecting an ABC compile run (header) with the inventory items, organizations, and subinventories evaluated in that run. Under this interpretation, the descriptive numeric measures (compile quantity, compile value, and cumulative equivalents) would typically be modeled as satellite attributes attached to that link rather than as independent hubs.

Key Information Stored

The documented primary key is MTL_ABC_COMPILES_PK, composed of INVENTORY_ITEM_ID and COMPILE_ID. A unique index, MTL_ABC_COMPILES_U1, is defined on the same two columns, confirming that a given item appears at most once per compile run and making this pair the effective business-key candidate. The most significant columns are:

• INVENTORY_ITEM_ID — the item evaluated in the compile; part of the primary key and a foreign key to MTL_SYSTEM_ITEMS_B.
• COMPILE_ID — identifies the parent compile run; part of the primary key and a foreign key to MTL_ABC_COMPILE_HEADERS.
• ORGANIZATION_ID — the inventory organization in which the item was compiled; joins to MTL_SYSTEM_ITEMS_B and MTL_SECONDARY_INVENTORIES.
• SECONDARY_INVENTORY — the subinventory scope of the compiled row, referencing MTL_SECONDARY_INVENTORIES.
• INVENTORY_TYPE — indicates the item or inventory category represented by the row.
• SEQUENCE_NUMBER — the descending-rank position assigned to the item within the compile.
• COMPILE_QUANTITY — the quantity used in the ABC valuation for this item.
• COMPILE_VALUE — the extended value attributed to the item for the compile.
• CUMULATIVE_QUANTITY — the running quantity total through this sequence position.
• CUMULATIVE_VALUE — the running value total, which drives the ABC class breakpoints.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program and request audit context for the compile job.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS Who columns.

Common Use Cases and Queries

Typical reporting scenarios include reproducing the descending value ranking for a completed compile, validating cumulative percentages against ABC class thresholds, and comparing item placement across successive compile runs. A representative query joins the compile rows to the compile header and item master:

• SELECT c.compile_id, c.sequence_number, c.inventory_item_id, c.organization_id, c.compile_value, c.cumulative_value FROM mtl_abc_compiles c WHERE c.compile_id = :compile_id ORDER BY c.sequence_number;
• Join to MTL_ABC_COMPILE_HEADERS h ON h.compile_id = c.compile_id to retrieve compile parameters and status.
• Join to MTL_SYSTEM_ITEMS_B i ON i.inventory_item_id = c.inventory_item_id AND i.organization_id = c.organization_id to display item descriptions and segment values.
• Aggregate by ORGANIZATION_ID or SECONDARY_INVENTORY to profile value concentration across subinventories.

Because the table is regenerated by the ABC compile concurrent program, it is best treated as a staging/result store for the most recent run rather than as a transaction table; analyses should always filter by COMPILE_ID.

Related Objects

The documented foreign keys establish the primary dependencies:

• MTL_ABC_COMPILE_HEADERS — parent compile run; joined on COMPILE_ID.
• MTL_SYSTEM_ITEMS_B — item master; joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• MTL_SECONDARY_INVENTORIES — subinventory definition; joined on SECONDARY_INVENTORY and ORGANIZATION_ID.
• MTL_ABC_CLASSES / ABC class assignment tables — downstream consumers of the compiled ranking.
• INV ABC compile concurrent program and INVABC report — the process and report that populate and present this data.

Together these objects form the ABC analysis pipeline: compile parameters in the header, ranked results in MTL_ABC_COMPILES, and resulting class assignments applied to items.