Compare FND Lookup Values between environments

Description
Categories: Enginatics
Repository: Github
Compares lookup values between the local and a remote database environment
select
nvl(flv.lookup_type,flv2.lookup_type) lookup_type,
nvl(flv.lookup_code,flv2.lookup_code) lookup_code,
nvl(flv.language,flv2.language) language,
flv.source_lang,
flv2.source_lang source_lang_remote,
decode(nvl(flv.source_lang,'x'),nvl(flv2.source_lang,'x'),null,'Y') source_lang_different,
flv.description,
flv2.description description_remote,
decode(nvl(flv.description,'x'),nvl(flv2.description,'x'),null,'Y') description_different,
flv.meaning,
flv2.meaning meaning_remote,
decode(nvl(flv.meaning,'x'),nvl(flv2.meaning,'x'),null,'Y') meaning_different
from
(select flv.* from fnd_lookup_values flv where 1=1) flv
full join
(select flv.* from fnd_lookup_values@&database_link flv where 1=1) flv2
on
flv.lookup_type=flv2.lookup_type and
flv.lookup_code=flv2.lookup_code and
flv.language=flv2.language and
flv.view_application_id=flv2.view_application_id and
flv.security_group_id=flv2.security_group_id
where
2=2
Parameter Name SQL text Validation
Show Differences only
nvl(flv.source_lang,'x')<>nvl(flv2.source_lang,'x') or
nvl(flv.meaning,'x')<>nvl(flv2.meaning,'x') or
nvl(flv.description,'x')<>nvl(flv2.description,'x')
LOV
Remote Database
<parameter_value>
LOV
Language Code
flv.language=:language
LOV
Exclude Language Code
flv.language<>:exclude_language_code
LOV
Type
flv.lookup_type=:lookup_type
LOV
Code contains
upper(flv.lookup_code) like '%'||upper(:lookup_code)||'%'
LOV