VIEW: APPS.IEC_O_ALG_OP_DEFS_VL

Source

View Text - Preformatted

SELECT b.operator_code, tl.name, b.is_unary_flag, b.sql_operator, 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_op_defs_b b, iec_o_alg_op_defs_tl tl WHERE b.operator_code = tl.operator_code AND tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.OPERATOR_CODE
, TL.NAME
, B.IS_UNARY_FLAG
, B.SQL_OPERATOR
, 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_OP_DEFS_B B
, IEC_O_ALG_OP_DEFS_TL TL
WHERE B.OPERATOR_CODE = TL.OPERATOR_CODE
AND TL.LANGUAGE = USERENV('LANG')