VIEW: APPS.IEC_O_ALG_ACTION_DEFS_VL

Source

View Text - Preformatted

SELECT b.action_code, b.action_type_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_action_defs_b b, iec_o_alg_action_defs_tl tl WHERE tl.action_code=b.action_code and tl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ACTION_CODE
, B.ACTION_TYPE_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_ACTION_DEFS_B B
, IEC_O_ALG_ACTION_DEFS_TL TL
WHERE TL.ACTION_CODE=B.ACTION_CODE
AND TL.LANGUAGE = USERENV('LANG')