Reports2017-11-18T12:27:27+00:00

Blitz Report LOVs

Description
Categories: Application, Enginatics, Setup
Blitz Report list of values

select
xrplv.lov_name,
xrplv.description,
xxen_util.meaning(xrplv.validate_from_list,'YES_NO',0) validate_from_list,
xxen_util.meaning(xrplv.filter_before_display,'YES_NO',0) filter_before_display,
xrplv.creation_date,
xxen_util.user_name(xrplv.created_by) created_by,
xrplv.last_update_date,
xxen_util.user_name(xrplv.last_updated_by) last_updated_by,
xrplv.lov_query
from
xxen_report_parameter_lovs_v xrplv
where
1=1

Parameter Name SQL text Validation
Last Updated By
xrplv.last_updated_by in (select fu.user_id from fnd_user fu where fu.user_name=:last_updated_by)
LOV
Based on Table
lower(xrplv.lov_query) like '%'||lower(:search_text)||'%'
LOV
Used by Parameter
xrplv.lov_id in (
select
xrpv.lov_id
from
xxen_report_parameters_vl xrpv
where
xrpv.parameter_name=:parameter_name and
xrpv.parameter_type='LOV' and
xrpv.lov_id is not null
)
LOV
SQL Text contains
lower(xrplv.lov_query) like '%'||lower(:search_text)||'%'

By continuing to use the site, you agree to the use of cookies. Accept