VIEW: APPS.IEC_O_ALG_EXPR_DEFS_VL

Source

View Text - Preformatted

SELECT b.expr_code, tl.description, tl.subst_text, tl.created_by, tl.creation_date, tl.last_updated_by, tl.last_update_date, tl.last_update_login, b.object_version_number FROM iec_o_alg_expr_defs_b b, iec_o_alg_expr_defs_tl tl WHERE b.expr_code = tl.expr_code AND tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.EXPR_CODE
, TL.DESCRIPTION
, TL.SUBST_TEXT
, TL.CREATED_BY
, TL.CREATION_DATE
, TL.LAST_UPDATED_BY
, TL.LAST_UPDATE_DATE
, TL.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
FROM IEC_O_ALG_EXPR_DEFS_B B
, IEC_O_ALG_EXPR_DEFS_TL TL
WHERE B.EXPR_CODE = TL.EXPR_CODE
AND TL.LANGUAGE = USERENV('LANG')