Blitz Report Column Translations

Description
Categories: Enginatics
Repository: Github Columns: Column Name, Number Format, Language, Translation, Language Code, Column Created By, Column Creation Date, Column Last Updated By, Column Last Update Date, Translation Created By ...
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
Last Updated By
xrct.last_updated_by=xxen_util.user_id(:last_updated_by)
LOV
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
Language
flv.description=:language
LOV
Language Code
flv.language_code=:language_code
LOV
Last Update Date From
xrct.last_update_date>=:last_update_date_from
Date