CST Subinventory Account Value - Multi-Org – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Report: CST Subinventory Account Value - Multi-Org
Description: Shows onhand inventory value broken down by GL account and cost element across multiple organizations.
For each subinventory, the report unpivots inventory value into separate rows per cost element (Material, Material Overhead, Resource, Outside Processing, Overhead), each showing the GL account where that cost element is recorded.
Asset subinventories show 5 rows per item (one per cost element). Expense subinventories show 1 row per item with total cost under the expense account.
Account determination follows Oracle standard costing rules:
- Standard costing: accounts from subinventory setup (mtl_secondary_inventories)
- Average/FIFO/LIFO costing: accounts from organization defaults (mtl_parameters)
- Cost group accounting: accounts from cost group accounts (cst_cost_group_accounts)
Corresponds to Oracle standard report: Subinventory Account Value Report (CSTRSAVR)
The report can be run across multiple Inventory Organizations.
DB package: XXEN_INV_VALUE
Report Parameters
Ledger, Operating Unit, Organization Code, Cost Type, As of Date, Costing Enabled Items Only, Item From, Item To, Category Set, Category From, Category To, Subinventory From, Subinventory To, Quantities By Revision, Negative Quantities Only, Include Expense Items, Include Zero Quantities
Oracle EBS Tables Used
cst_inv_qty_temp, cst_inv_cost_temp, mtl_parameters, mtl_secondary_inventories, mtl_system_items_vl, mtl_categories_b_kfv, cst_cost_groups, cst_cost_group_accounts, dual, gl_code_combinations_kfv, org_organization_definitions, hr_all_organization_units, gl_sets_of_books
Report Categories
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 Subinventory Account Value - Multi-Org 04-Apr-2026 010937.xlsx |
| Blitz Report™ XML Import | CST_Subinventory_Account_Value_Multi_Org.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/cst-subinventory-account-value-multi-org/ |
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
© 2026 Enginatics