Skip to content

CST Inventory Value Report - by Subinventory (Item Cost)

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

CST Inventory Value Report - by Subinventory (Item Cost)

README.md

layout default
title CST Inventory Value Report - by Subinventory (Item Cost) | Oracle EBS SQL Report
description Imported Oracle standard inventory value subinventory report by item cost Source: Inventory Value Report - by Subinventory (XML) Short Name: CSTRINVRXML…
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, CST, Inventory, Value, Report, mtl_categories_b_kfv, mtl_system_items_vl, mtl_secondary_inventories
permalink /CST%20Inventory%20Value%20Report%20-%20by%20Subinventory%20%28Item%20Cost%29/

CST Inventory Value Report - by Subinventory (Item Cost) – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Imported Oracle standard inventory value subinventory report by item cost Source: Inventory Value Report - by Subinventory (XML) Short Name: CSTRINVR_XML DB package: BOM_CSTRINVR_XMLP_PKG

Report Parameters

Cost Type, As of Date, Item From, Item To, Category Set, Category From, Category To, Subinventory From, Subinventory To, Currency, Exchange Rate, Quantities By Revision, Negative Quantities only, Display Zero Costs only, Include Expense Items, Include Expense Subinventories, Include Zero Quantities, Include Unvalued Transactions

Oracle EBS Tables Used

mtl_categories_b_kfv, mtl_system_items_vl, mtl_secondary_inventories, cst_inv_qty_temp, cst_inv_cost_temp, mtl_parameters, cst_item_costs, cst_cost_groups

Report Categories

Enginatics, R12 only

Related Reports

CST Inventory Value - Multi-Organization (Element Costs) 11i, INV Transaction Historical Summary, CST Subinventory Account Value - Multi-Org, CST Inventory Value - Multi-Organization (Item Costs)

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output CST Inventory Value Report - by Subinventory (Item Cost) 21-Sep-2020 122236.xlsx
Blitz Report™ XML Import CST_Inventory_Value_Report_by_Subinventory_Item_Cost.xml
Full SQL on Enginatics www.enginatics.com/reports/cst-inventory-value-report-by-subinventory-item-cost/

Executive Summary

The CST Inventory Value Report - by Subinventory (Item Cost) is a direct extraction of the standard Oracle "Inventory Value Report - by Subinventory". It provides a valuation of on-hand inventory, grouped and subtotaled by Subinventory (storage location). This view is essential for warehouse managers and cost accountants who need to validate the value of goods in specific physical areas (e.g., "Finished Goods" vs. "Raw Materials" vs. "Quarantine").

Business Challenge

While the General Ledger shows the total inventory balance, it doesn't explain where that value sits physically.

  • Location Analysis: "Why is the value in the 'Scrap' subinventory so high?"
  • Account Reconciliation: Different subinventories often map to different GL asset accounts. This report helps reconcile those specific sub-ledger accounts.
  • Audit: Auditors often select specific subinventories for physical counts and valuation testing.

Solution

This report lists items and their values within each subinventory.

Key Features:

  • Subinventory Grouping: The primary sort key is the Subinventory, allowing for easy subtotaling.
  • Cost Type Flexibility: Can report based on Frozen (Standard) costs or other simulation cost types.
  • Granularity: Shows Quantity, Unit Cost, and Total Value for each item.

Architecture

This is a Blitz Report import of the standard Oracle XML Publisher report CSTRINVR_XML. It uses the package BOM_CSTRINVR_XMLP_PKG.

Key Tables:

  • MTL_SECONDARY_INVENTORIES: Defines the subinventories.
  • CST_INV_QTY_TEMP: Calculates on-hand quantities.
  • CST_ITEM_COSTS: Retrieves unit costs.
  • MTL_SYSTEM_ITEMS_VL: Item details.

Impact

  • Asset Protection: Helps identify high-value items sitting in unsecured or inappropriate subinventories.
  • Financial Accuracy: Supports the detailed reconciliation of inventory GL accounts.
  • Operational Control: Provides visibility into the distribution of inventory value across the warehouse layout.

Useful Links

© 2026 Enginatics