| layout | default |
|---|---|
| title | INV Item Relationships | Oracle EBS SQL Report |
| description | Master listing for Inventory item relationships – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, INV, Item, Relationships, mtl_parameters, mtl_related_items, mtl_system_items_vl |
| permalink | /INV%20Item%20Relationships/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Master listing for Inventory item relationships
Item, Last Update Date From, Last Update Date To, Last Updated By, Creation Date From, Creation Date To, Created By, Organization Code
mtl_parameters, mtl_related_items, mtl_system_items_vl, org_access_view
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
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 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/ |
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.
- 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.
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.
- 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.
- Item: Filter for a specific item.
- Organization Code: Relationships are organization-specific.
- 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