ATC_CHARACTERISTICS_VL
Details
-
Schema: FUSION
-
Object owner: ATC
-
Object type: VIEW
Columns
Name |
---|
CHARACTERISTIC_ID CHARACTERISTIC_TYPE CHARACTERISTIC_KEY CHARACTERISTIC_DISP_TEXT CHARACTERISTIC_DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CONFLICT_ID |
Query
SQL_Statement |
---|
SELECT B.CHARACTERISTIC_ID, B.CHARACTERISTIC_TYPE, B.CHARACTERISTIC_KEY, T.CHARACTERISTIC_DISP_TEXT, T.CHARACTERISTIC_DESCRIPTION, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.CONFLICT_ID FROM ATC_CHARACTERISTICS_B B, ATC_CHARACTERISTICS_TL T WHERE B.CHARACTERISTIC_ID=T.CHARACTERISTIC_ID and T.LANGUAGE=USERENV('LANG') |