Skip to the content.

BOM Item Where Used GUI – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Bills of Material · all Bills of Material reports

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

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

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

CAC Internal Order Shipment Margin, GL Account Distribution Analysis, WIP Move Transactions 11i, CAC PO Price vs. Costing Method Comparison, WIP Required Components

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 Example
Blitz Report™ XML Import BOM_Item_Where_Used_GUI.xml
SQL Source BOM Item Where Used GUI.sql
Full Report 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


© Enginatics GmbH