Blitz Report Column Translations

Description
Categories: Enginatics
Repository: Github

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
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