Blitz Report Column Translations

select
xrc.column_name,
xrc.number_format,
xrct.language_desc 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,
(select flv.description language_desc, xrct.* from xxen_report_columns_tl xrct, fnd_languages_vl flv where 2=2 and xrct.language=flv.language_code) xrct
where
1=1 and
xrc.column_id=xrct.column_id(+)
order by
xrc.column_name,
xrct.language_desc

select xrc.column_name, xrc.number_format, xrct.language_desc 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, (select flv.description language_desc, xrct.* from xxen_report_columns_tl xrct, fnd_languages_vl flv where 2=2 and xrct.language=flv.language_code) xrct where 1=1 and xrc.column_id=xrct.column_id(+) order by xrc.column_name, xrct.language_desc