andy column translation test

Description
Categories: andy 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)
Parameter Name SQL text Validation
ewfref
erwfff