Blitz Report Column Translation Comparison between environments

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Shows differences in Blitz Report column translations between the local and a remote database server
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
Parameter NameSQL textValidation
Remote Database
<parameter_value>
LOV
Language
xrct.language in (select flv.language_code from fnd_languages_vl flv where flv.description=:language)
LOV
Show Differences only
nvl(xrct.translation,'x')<>nvl(xrct2.translation,'x')
LOV
Download
Related Blitz Reports
CAC WIP Account Value CAC Receiving Value (Period-End) CAC Cost vs. Planning Item Controls CAC Items Without This Level Material Overhead CAC Calculate ICP PII Item Costs GL Account Distribution Analysis PO Requisition Template Upload Blitz Upload Data QP Price List Upload CST Item Standard Cost Upload
Blitz Report™