FUN_SENSORS_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
SENSOR_ID SENSOR_CODE SENSOR_TYPE NAME DESCRIPTION MODULE_ID DEFAULT_COUNT_THRESHOLD DEFAULT_TIME_THRESHOLD MAX_FETCH_SIZE MINIMUM_TIME_THRESHOLD SENSOR_PARAMETER SENSOR_ACTION_TYPE_CODE SEED_DATA_SOURCE OBJECT_VERSION_NUMBER LAST_UPDATE_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.SENSOR_ID, B.SENSOR_CODE, B.SENSOR_TYPE, TL.NAME, TL.DESCRIPTION, B.MODULE_ID, B.DEFAULT_COUNT_THRESHOLD, B.DEFAULT_TIME_THRESHOLD, B.MAX_FETCH_SIZE, B.MINIMUM_TIME_THRESHOLD, B.SENSOR_PARAMETER, B.SENSOR_ACTION_TYPE_CODE, B.SEED_DATA_SOURCE, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN FROM FUN_SENSORS_B B, FUN_SENSORS_TL TL WHERE TL.SENSOR_ID = B.SENSOR_ID AND TL.LANGUAGE = USERENV('LANG')