INV Item Default Transaction Subinventories – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master data report of inventory item relationships including the type of relationship between the item and the subinventory.
Report Parameters
Item, Subinventory, Organization Code
Oracle EBS Tables Used
hr_all_organization_units_vl, mtl_parameters, mtl_item_sub_defaults, mtl_system_items_vl, org_access_view
Report Categories
Related Reports
CAC Calculate Average Item Costs, INV Item Default Transaction Locators, CAC User-Defined and Rolled Up Costs, CAC Material Account Alias with Lot Numbers, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Receiving Expense Value (Period-End), CAC Missing Receiving Accounting Transactions, CAC Receiving Account Detail
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 | INV Item Default Transaction Subinventories 24-Jul-2023 194535.xlsx |
| Blitz Report™ XML Import | INV_Item_Default_Transaction_Subinventories.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-item-default-transaction-subinventories/ |
INV Item Default Transaction Subinventories - Case Study & Technical Analysis
Executive Summary
The INV Item Default Transaction Subinventories report lists the default subinventory assigned to an item. Similar to the Locator report, this defines the “Home” subinventory for an item. It is used to restrict where an item can be transacted or to provide a default value during receiving and miscellaneous transactions.
Business Use Cases
- Putaway Logic: Defines the primary storage area for an item (e.g., “Cold Storage” vs. “Dry Goods”).
- Transaction Control: Can be used in conjunction with “Restrict Subinventories” flag on the Item Master to prevent users from putting items in the wrong place.
- Min-Max Planning: Often used to define which subinventory is replenished for a specific item.
Technical Analysis
Core Tables
MTL_ITEM_SUB_DEFAULTS: The table storing the default subinventory code for an item.MTL_SYSTEM_ITEMS_VL: Item master.
Key Joins & Logic
- Organization Specific: Defaults are specific to an Inventory Organization.
- Relationship: This is a simple 1:Many relationship (One Item can have defaults in multiple Orgs, but usually one default per Org/Type).
Key Parameters
- Item: Filter for a specific item.
- Subinventory: Filter for a specific subinventory.
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