INV Item Relationships – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Master listing for Inventory item relationships
Report Parameters
Item, Last Update Date From, Last Update Date To, Last Updated By, Creation Date From, Creation Date To, Created By, Organization Code
Oracle EBS Tables Used
mtl_parameters, mtl_related_items, mtl_system_items_vl, org_access_view
Report Categories
Related Reports
CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, CAC Internal Order Shipment Margin, CAC WIP Resource Efficiency, CAC Invoice Price Variance, CAC Inventory Lot and Locator OPM Value (Period-End), CAC AP Accrual IR ISO Match Analysis, CAC OPM WIP Account Value, CAC Last Standard Item Cost
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 Relationships 18-Jan-2018 221121.xlsx |
| Blitz Report™ XML Import | INV_Item_Relationships.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-item-relationships/ |
INV Item Relationships - Case Study & Technical Analysis
Executive Summary
The INV Item Relationships report documents the functional links between items. In Oracle Inventory, items can be related for various purposes: Substitutes (if A is out, ship B), Cross-Sells (if buying A, suggest B), Up-Sells, or Service Items (Warranty for Item A). This report is crucial for validating these setups, which directly impact Order Management and Planning.
Business Use Cases
- Substitute Management: Verifies that discontinued items have valid substitutes defined so orders don’t get stuck.
- Sales Effectiveness: Audits the “Cross-Sell” and “Up-Sell” relationships used by the telesales team.
- Spare Parts Mapping: Documents which service parts belong to which finished goods.
Technical Analysis
Core Tables
MTL_RELATED_ITEMS: The table storing the relationship (Item A -> Item B, Relationship Type).MTL_SYSTEM_ITEMS_VL: Item details for both the “From” and “To” items.
Key Joins & Logic
- Directionality: Relationships can be one-way or reciprocal. The report typically shows the “From” item and the “To” item.
- Effectiveness: Relationships have start and end dates; the report can filter for currently active links.
Key Parameters
- Item: Filter for a specific item.
- Organization Code: Relationships are organization-specific.
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