1. Tables and Views for HCM
  2. HXT_GEOFENCES_VL

HXT_GEOFENCES_VL

Details

  • Schema: FUSION

  • Object owner: HXT

  • Object type: VIEW

Columns

Name

GEOFENCE_ID

CODE

NAME

DESCRIPTION

LOCATION_ID

GEOMETRY

RADIUS

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

gbt.GEOFENCE_ID,

gbt.CODE,

gtl.NAME,

gtl.DESCRIPTION,

gbt.LOCATION_ID,

gbt.GEOMETRY,

gbt.RADIUS,

gbt.OBJECT_VERSION_NUMBER,

gbt.CREATED_BY,

gbt.CREATION_DATE,

gbt.LAST_UPDATED_BY,

gbt.LAST_UPDATE_DATE,

gbt.LAST_UPDATE_LOGIN

FROM HXT_GEOFENCES_B gbt,

HXT_GEOFENCES_TL gtl

WHERE

gbt.GEOFENCE_ID = gtl.GEOFENCE_ID

AND gtl.LANGUAGE = userenv('LANG')