INV Item Default Transaction Subinventories – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Inventory · all Inventory reports
Overview
Master data report of inventory item relationships including the type of relationship between the item and the subinventory.
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
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, INL Landed Cost Adjustments, INV Slow Moving Inventory, EAM Assets, CST Detailed Item Cost, INV Onhand Quantities, WIP Job Upload, CST Item Standard Cost Upload
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 | INV Item Default Transaction Subinventories 24-Jul-2023 194535.xlsx |
| Blitz Report™ XML Import | INV_Item_Default_Transaction_Subinventories.xml |
| SQL Source | INV Item Default Transaction Subinventories.sql |
| Full Report 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
© Enginatics GmbH