Blitz Report Column Translation Comparison between environments

select
nvl(xrct.column_name,xrct2.column_name) column_name,
nvl(xrct.language,xrct2.language) language,
xrct.translation,
xrct2.translation translation_remote
from
(
select
xrc.column_name,
xrct.language,
xrct.translation
from
xxen_report_columns xrc,
xxen_report_columns_tl xrct
where
1=1 and
xrc.column_id=xrct.column_id
) xrct
full join
(
select
xrc.column_name,
xrct.language,
xrct.translation
from
xxen_report_columns@&database_link xrc,
xxen_report_columns_tl@&database_link xrct
where
1=1 and
xrc.column_id=xrct.column_id
) xrct2
on
xrct.column_name=xrct2.column_name and
xrct.language=xrct2.language
where
2=2

select nvl(xrct.column_name,xrct2.column_name) column_name, nvl(xrct.language,xrct2.language) language, xrct.translation, xrct2.translation translation_remote from ( select xrc.column_name, xrct.language, xrct.translation from xxen_report_columns xrc, xxen_report_columns_tl xrct where 1=1 and xrc.column_id=xrct.column_id ) xrct full join ( select xrc.column_name, xrct.language, xrct.translation from xxen_report_columns@&database_link xrc, xxen_report_columns_tl@&database_link xrct where 1=1 and xrc.column_id=xrct.column_id ) xrct2 on xrct.column_name=xrct2.column_name and xrct.language=xrct2.language where 2=2