Blitz Report Column Translations

Description
Categories: Enginatics
Repository: Github
Run Blitz Report Column Translations and other Oracle EBS reports with Blitz Report™ on our demo environment
select
xrc.column_name,
xrc.number_format,
flv.description language,
xrct.translation,
xrct.language language_code,
xxen_util.user_name(xrc.created_by) column_created_by,
xxen_util.client_time(xrc.creation_date) column_creation_date,
xxen_util.user_name(xrc.last_updated_by) column_last_updated_by,
xxen_util.client_time(xrc.last_update_date) column_last_update_date,
xxen_util.user_name(xrct.created_by) translation_created_by,
xxen_util.client_time(xrct.creation_date) translation_creation_date,
xxen_util.user_name(xrct.last_updated_by) translation_last_updated_by,
xxen_util.client_time(xrct.last_update_date) translation_last_update_date
from
xxen_report_columns xrc,
xxen_report_columns_tl xrct,
fnd_languages_vl flv
where
1=1 and
xrc.column_id=xrct.column_id(+) and
xrct.language=flv.language_code(+)
order by
xrc.column_name,
flv.description
Parameter Name SQL text Validation
Language Code
flv.language_code=:language_code
LOV
Language
flv.description=:language
LOV
Last Updated By
xrct.last_updated_by=xxen_util.user_id(:last_updated_by)
LOV
Last Update Date From
xrct.last_update_date>=:last_update_date_from
Date
Show obsolete only
(
xxen_report.underscore_to_space(xrc.column_name)=xrct.translation or
lower(xxen_report.underscore_to_space(xrc.column_name))=lower(xrct.translation) and xrct.language<>'US'
)
LOV