BOM Item Where Used GUI – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Description: Item Where Used GUI Report

Provides equivalent functionality to the the following standard reports:

Application: Bills of Material Source: Item Where Used Report GUI (XML) Short Name: BOMRWUITG_XML DB package: BOM_BOMRWUIT_XMLP_PKG

Report Parameters

Application, Organization Code, All Organizations, Organization Hierarchy, Item, Item Description, Item Type, Exclude Item Type, Revision, Item From, Item To, Category Set, Category From, Category To, Levels To Implode, Implemented Only, Display Option, Date, Top Assemblies Only

Oracle EBS Tables Used

mtl_system_items_vl, mtl_item_flexfields, bom_implosion_view

Report Categories

Enginatics, R12 only

CAC Internal Order Shipment Margin, WIP Required Components, CAC Receiving Account Detail, CAC Missing WIP Accounting Transactions, CST Detailed Item Cost, CAC Resource Costs

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 None
Blitz Report™ XML Import BOM_Item_Where_Used_GUI.xml
Full SQL on Enginatics www.enginatics.com/reports/bom-item-where-used-gui/

BOM Item Where Used GUI

Description

Item Where Used GUI Report

Provides equivalent functionality to the the following standard reports:

Parameters

Application, Organization Code, All Organizations, Organization Hierarchy, Item, Item Type, Exclude Item Type, Revision, Item From, Item To, Category Set, Category From, Category To, Levels To Implode, Implemented Only, Display Option, Date, Top Assemblies Only

Used tables

mtl_system_items_vl, mtl_item_flexfields, bom_implosion_view

Categories

Enginatics

© 2026 Enginatics