Skip to content

Blitz Report LOVs

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

Blitz Report LOVs

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
Blitz Report LOVs.sql
Blitz Report LOVs.sql
 
 
DESCRIPTION.md
DESCRIPTION.md
 
 
README.md
README.md
 
 

README.md

layout default
title Blitz Report LOVs | Oracle EBS SQL Report
description Blitz Report list of values – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, Blitz, Report, LOVs, xxen_report_parameter_lovs_h, xxen_report_parameters, xxen_report_parameter_lovs_v
permalink /Blitz%20Report%20LOVs/

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

Enginatics

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

© 2026 Enginatics