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™. Oracle EBS module: Cost Management · all Cost Management reports
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
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
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
Related Reports
INV Transaction Historical Summary, CST Subinventory Account Value - Multi-Org, CST Inventory Value - Multi-Organization (Item Costs), CAC Inventory and Intransit Value (Period-End) - Discrete/OPM
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
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 |
| SQL Source | CST Inventory Value Report - by Subinventory (Item Cost).sql |
| Full Report 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
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH