FUN_SENSOR_USAGES_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
SENSOR_USAGE_ID SENSOR_ID NAME DESCRIPTION ACTIVE_FLAG SENSOR_MODE ENABLED_FLAG COUNT_THRESHOLD TIME_THRESHOLD 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_USAGE_ID, B.SENSOR_ID, TL.NAME, TL.DESCRIPTION, B.ACTIVE_FLAG, B.SENSOR_MODE, B.ENABLED_FLAG, B.COUNT_THRESHOLD, B.TIME_THRESHOLD, 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_SENSOR_USAGES_B B, FUN_SENSOR_USAGES_TL TL WHERE TL.SENSOR_USAGE_ID = B.SENSOR_USAGE_ID AND TL.LANGUAGE = USERENV('LANG')