Oracle-EBS-SQL/Blitz Report Column Translation Comparison between environments/Blitz Report Column Translation Comparison between environments.sql at master · Enginatics/Oracle-EBS-SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
/*************************************************************************/
/*                                                                       */
/*                       (c) 2010-2024 Enginatics GmbH                   */
/*                              www.enginatics.com                       */
/*                                                                       */
/*************************************************************************/
-- Report Name: Blitz Report Column Translation Comparison between environments
-- Description: Shows differences in Blitz Report column translations between the local and a remote database server
-- Excel Examle Output: https://www.enginatics.com/example/blitz-report-column-translation-comparison-between-environments/
-- Library Link: https://www.enginatics.com/reports/blitz-report-column-translation-comparison-between-environments/
-- Run Report: https://demo.enginatics.com/

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