Compare Blitz Report LOVs between environments

Description
select
x.*
from
(
select
case
when xrplv.guid is not null and xrplv2.last_updated_by<>-1  then 'conflict'
when xrplv.guid is null and xrplv2.guid is not null then 'add to local database'
when xrplv.guid is not null and xrplv2.guid is null then 'transfer'
else 'update'
end result,
case when xrplv.lov_name<>xrplv2.lov_name then 'Y' end name_diff,
case when xrplv.lov_query<>xrplv2.lov_query then 'Y' end query_diff,
case when xrplv.description<>xrplv2.description then 'Y' end descr_diff,
xrplv.lov_name,
xrplv2.lov_name lov_name_remote,
xrplv.description,
xrplv2.description description_remote,
xrplv.last_update_date,
xrplv2.last_update_date last_update_date_remote,
xxen_util.user_name(xrplv.last_updated_by) last_updated_by,
xxen_util.user_name@&database_link(xrplv2.last_updated_by) last_updated_by_remote,
xrplv.creation_date,
xrplv2.creation_date creation_date_remote,
xxen_util.user_name(xrplv.created_by) created_by,
xxen_util.user_name@&database_link(xrplv2.created_by) created_by_remote,
xrplv.lov_query,
xrplv2.lov_query lov_query_remote
from
xxen_report_parameter_lovs_v xrplv
full outer join
xxen_report_parameter_lovs_v@&database_link xrplv2
on
xrplv.guid=xrplv2.guid
where
1=1
) x
where
nvl(x.lov_name,'x')<>nvl(x.lov_name_remote,'x') or
x.name_diff is not null or
x.descr_diff is not null or
x.query_diff is not null
order by
coalesce(x.name_diff,x.descr_diff,x.query_diff),
x.last_update_date_remote desc nulls last,
x.last_update_date desc
Parameter Name SQL text Validation
Remote Database
<parameter_value>
LOV