HWR_SYNONYMS_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
SYNONYM_ID SYNONYM_ATTR_1 SYNONYM_ATTR_2 DISPLAY_TEXT DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.SYNONYM_ID, B.SYNONYM_ATTR_1, B.SYNONYM_ATTR_2, T.DISPLAY_TEXT, T.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HWR_SYNONYMS_B B, HWR_SYNONYMS_TL T WHERE B.SYNONYM_ID = T.SYNONYM_ID AND T.LANGUAGE = USERENV('LANG')