| layout | default |
|---|---|
| title | INV Item Default Transaction Subinventories | Oracle EBS SQL Report |
| description | Master data report of inventory item relationships including the type of relationship between the item and the subinventory. |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, INV, Item, Default, Transaction, hr_all_organization_units_vl, mtl_parameters, mtl_item_sub_defaults |
| permalink | /INV%20Item%20Default%20Transaction%20Subinventories/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Master data report of inventory item relationships including the type of relationship between the item and the subinventory.
Item, Subinventory, Organization Code
hr_all_organization_units_vl, mtl_parameters, mtl_item_sub_defaults, mtl_system_items_vl, org_access_view
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, INV Slow Moving Inventory, CAC Receiving Expense Value (Period-End), CAC Missing Receiving Accounting Transactions, CAC Receiving Account Detail
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.
| 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/ |
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.
- 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.
MTL_ITEM_SUB_DEFAULTS: The table storing the default subinventory code for an item.MTL_SYSTEM_ITEMS_VL: Item master.
- 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).
- Item: Filter for a specific item.
- Subinventory: Filter for a specific subinventory.
- 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