Blitz Report LOVs – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Blitz Report list of values
Report Parameters
LOV Name starts with, SQL Text contains, Based on Table, Used by Parameter, Updated within x Days, Last Update Date From, Last Updated By, Used by a Parameter, Not Used by any Parameter
Oracle EBS Tables Used
xxen_report_parameter_lovs_h, xxen_report_parameters, xxen_report_parameter_lovs_v
Report Categories
Related Reports
Blitz Report LOV SQL Validation, Blitz Report Text Search, DIS End User Layers, Blitz Report LOV Comparison between environments, Blitz Report History, Blitz Reports, Blitz Upload Dependencies, Blitz Report Parameter Comparison between reports
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 | Blitz Report LOVs 27-Jul-2018 212033.xlsx |
| Blitz Report™ XML Import | Blitz_Report_LOVs.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/blitz-report-lovs/ |
Blitz Report LOVs - Case Study & Technical Analysis
Executive Summary
Blitz Report LOVs is a dictionary of all List of Values definitions in the system. It allows developers to search for existing LOVs to reuse, rather than creating duplicates. It also helps in impact analysis (e.g., “If I change this LOV, which reports will be affected?”).
Business Challenge
- Reusability: A developer needs a “Supplier List” parameter. Instead of writing a new SQL query, they can search this report to find an existing, tested LOV.
- Impact Analysis: The “Active Employees” view is being renamed. Which LOVs use this view, and which reports use those LOVs?
- Cleanup: Identifying LOVs that are defined but not used by any parameter (
Not Used by any Parameter).
Solution
This report lists the LOV definitions, their SQL text, and usage statistics.
- Search: Search by SQL text (
SQL Text contains) or Table Name (Based on Table). - Usage: Shows which parameters use the LOV.
Technical Architecture
Key Tables
XXEN_REPORT_PARAMETER_LOVS_V: The LOV definition.XXEN_REPORT_PARAMETERS: The link to reports.
Logic
The query lists LOVs and joins to the parameter table to count usages or list specific reports.
Parameters
- LOV Name starts with: Search by name.
- SQL Text contains: Search the code.
- Based on Table: Find LOVs querying a specific table.
- Used by Parameter: Find where a specific LOV is used.
- Updated within x Days / Last Updated By: Audit changes.
- Not Used by any Parameter: Find candidates for deletion.
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