andy column translation test

select
xrc.column_name,
xrct.language,
xctr.db_lang_code,
xxen_util.user_name(xrct.last_updated_by) last_updated_by,
xrct.last_update_date,
xrct.translation,
xrct.column_id,
xctr.dpl_trnsltd_text,
xctr.ggl_trnsltd_text
from
xxen_report_columns xrc,
xxen_report_columns_tl xrct,
xxen_cols_trnslns_rk xctr
where
1=1 and
--xrc.column_name='acct_flexval' and
--xrct.language='JA' and
xrc.column_id=xrct.column_id and
xrct.column_id=xctr.xxen_col_id and
xrct.language=xctr.db_lang_code and
xrct.translation<>nvl(xctr.dpl_trnsltd_text,xctr.ggl_trnsltd_text)

select xrc.column_name, xrct.language, xctr.db_lang_code, xxen_util.user_name(xrct.last_updated_by) last_updated_by, xrct.last_update_date, xrct.translation, xrct.column_id, xctr.dpl_trnsltd_text, xctr.ggl_trnsltd_text from xxen_report_columns xrc, xxen_report_columns_tl xrct, xxen_cols_trnslns_rk xctr where 1=1 and --xrc.column_name='acct_flexval' and --xrct.language='JA' and xrc.column_id=xrct.column_id and xrct.column_id=xctr.xxen_col_id and xrct.language=xctr.db_lang_code and xrct.translation<>nvl(xctr.dpl_trnsltd_text,xctr.ggl_trnsltd_text)