Search Results cost_code

Overview

MTL_ABC_COMPILES_V is an APPS-owned, read-only database view in Oracle E-Business Suite that resides within the Inventory (INV) product module. It consolidates ABC compile results produced by the ABC Analysis concurrent programs and joins them with descriptive item and compile-header information. The view carries a Status of VALID and is documented in ETRM as "- Retrofitted," indicating that its definition was preserved or re-pointed during an upgrade, most notably in the 12.1.1 to 12.2.2 transition where many INV objects were converted to the Online Patching (Editioning) model and moved under the APPS schema as synonyms.

The view is primarily a reporting and integration surface. It allows custom reports, BI Publisher data models, Discoverer workbooks, and interface extracts to retrieve ABC classification outcomes without writing multi-table joins against the base transaction tables. Because it exposes the COST_CODE column (inherited from MTL_ABC_COMPILE_HEADERS), users searching on "cost_code" frequently land on this view when investigating ABC cost class assignments and their associated cost types.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is defined over three referenced base objects, each surfaced as a SYNONYM in the APPS schema:

• MTL_ABC_COMPILES — the detail table holding per-item, per-compile quantities, values, cumulative totals, sequence numbers, and who-columns (alias A).
• MTL_ABC_COMPILE_HEADERS — the header table describing each compile run, including compile name, type, status, item scope code, cost code, cost type, and the aggregate compile item counts and cumulative values used as denominators (alias B).
• MTL_SYSTEM_ITEMS — the item master, providing inventory item description and descriptive flexfield attributes (alias C).

The join predicates are documented as C.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID AND C.ORGANIZATION_ID = A.ORGANIZATION_ID AND A.COMPILE_ID = B.COMPILE_ID. The view text also selects A.ROWID as ROW_ID, but it is not updateable in practice because it is a multi-table join.

Key Columns

The view exposes the following significant columns:

• COMPILE_ID / COMPILE_NAME / COMPILE_TYPE / COMPILE_STATUS / COMPILE_DATE — identify and describe each ABC compile run.
• INVENTORY_ITEM_ID / ITEM_DESCRIPTION / ORGANIZATION_ID — item identity and the inventory organization context.
• SEQUENCE_NUMBER, COMPILE_QUANTITY, COMPILE_VALUE, CUMULATIVE_QUANTITY, CUMULATIVE_VALUE — the ABC ranking detail for each item.
• ITEM_PERCENT, VALUE_PERCENT, CUMULATIVE_VALUE_PERCENT, CUMULATIVE_ITEM_PERCENT — computed percentages derived via DECODE guards against divide-by-zero over B.COMPILE_ITEMS and B.CUMULATIVE_VALUE.
• COST_CODE and COST_TYPE — sourced from MTL_ABC_COMPILE_HEADERS (B); these drive the cost-classification dimension of the ABC compile and are the columns most relevant to cost_code-oriented queries.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — descriptive flexfield context and segments from MTL_SYSTEM_ITEMS.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program audit trail for the originating compile request.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns from MTL_ABC_COMPILES.

Common Use Cases and Queries

Typical uses include ABC class reporting, cost-code lookups, item ranking extracts, and reconciliation of compile output to the item master.

• Retrieving items in a specific ABC compile with their cost code:

SELECT compile_id, compile_name, inventory_item_id,
       item_description, cost_code, cost_type,
       cumulative_value_percent
FROM   mtl_abc_compiles_v
WHERE  organization_id = :org_id
AND    compile_id      = :compile_id
ORDER BY sequence_number;

• Filtering by cost code across all compiles:

SELECT compile_name, cost_code, cost_type,
       inventory_item_id, item_description, compile_value
FROM   mtl_abc_compiles_v
WHERE  cost_code = :cost_code
AND    organization_id = :org_id;

• Reporting descriptive flexfield attributes alongside ABC results, using ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 for category-specific reporting.

Because the view is not updateable, all maintenance of ABC compiles must be performed through the standard ABC Analysis concurrent programs or against the underlying base tables, while MTL_ABC_COMPILES_V remains the preferred query layer for read-only reporting and integration.