INV Item Relationships – 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 listing for Inventory item relationships
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, 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 Invoice Price Variance, INV Onhand Quantities, INV Material Transactions, INV Item Default Transaction Subinventories, INV Item Default Transaction Locators, PO Approved Supplier List, EAM Assets, INV Items, INV Safety Stocks
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 Relationships 18-Jan-2018 221121.xlsx |
| Blitz Report™ XML Import | INV_Item_Relationships.xml |
| SQL Source | INV Item Relationships.sql |
| Full Report 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
© Enginatics GmbH