Blitz Report Column Translations

➜ Back to Library
Description
Categories: Enginatics, Kcapps
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
Download
Related Blitz Reports
QP Customer Pricing Engine Request GL Account Analysis (Distributions) GL Account Analysis Mrugesh: GL Balance RWB Execution History AP Invoices and Lines GL Balance XXFT GL Balance FND Flex Value Sets, Usages and Values
Blitz Report™

Blitz Report™ provides multiple benefits: