Blitz Report Parameter Custom LOV Validation

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Blitz report parameters using custom LOVs with the same query more than once so that they should be set up as a shared LOV instead
Run Blitz Report Parameter Custom LOV Validation and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select
count(*) over (partition by dbms_lob.substr(xrpv.lov_query_dsp,4000,1)) dupl_count,
count(nvl2(xrpv.lov_id,null,1)) over (partition by dbms_lob.substr(xrpv.lov_query_dsp,4000,1)) custom_count,
xrpv.report_name,
xrpv.category,
xrpv.display_sequence,
xrpv.parameter_name,
xrpv.parameter_type_dsp,
xrpv.lov_name,
dbms_lob.substr(xrpv.lov_query_dsp,4000,1) lov_query_dsp 
from
xxen_report_parameters_v xrpv
where
1=1 and
xrpv.parameter_type='LOV'
) x
where
x.dupl_count>1 and
x.custom_count>0
order by
x.dupl_count desc,
x.lov_query_dsp
Parameter Name SQL text Validation
Enginatics Category only 
xrpv.category like '%Enginatics%'
 LOV
Download
Related Blitz Reports
Blitz Report Text Search Blitz Report Parameter Uniqueness Validation ONT Cancelled Orders DIS End User Layers Blitz Reports QP Customer Pricing Engine Request Blitz Report Parameter Default Values Blitz Report Parameter Dependencies Blitz Report Execution History Compare Blitz Report Parameters
Blitz Report™

Blitz Report™ provides multiple benefits: