VIEW: APPS.IEC_O_ALG_DATA_DEFS_VL

Source

View Text - Preformatted

SELECT b.data_code, b.owner_code, b.owner_type_code, tl.name, b.data_type, b.is_ref_flag, b.ref_name, b.ref_value, b.ref_table, b.ref_where, tl.created_by, tl.creation_date, tl.last_update_date, tl.last_updated_by, tl.last_update_login, b.object_version_number FROM iec_o_alg_data_defs_b b, iec_o_alg_data_defs_tl tl WHERE b.data_code = tl.data_code AND b.owner_code = tl.owner_code AND b.owner_type_code = tl.owner_type_code AND tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.DATA_CODE
, B.OWNER_CODE
, B.OWNER_TYPE_CODE
, TL.NAME
, B.DATA_TYPE
, B.IS_REF_FLAG
, B.REF_NAME
, B.REF_VALUE
, B.REF_TABLE
, B.REF_WHERE
, TL.CREATED_BY
, TL.CREATION_DATE
, TL.LAST_UPDATE_DATE
, TL.LAST_UPDATED_BY
, TL.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
FROM IEC_O_ALG_DATA_DEFS_B B
, IEC_O_ALG_DATA_DEFS_TL TL
WHERE B.DATA_CODE = TL.DATA_CODE
AND B.OWNER_CODE = TL.OWNER_CODE
AND B.OWNER_TYPE_CODE = TL.OWNER_TYPE_CODE
AND TL.LANGUAGE = USERENV('LANG')