Product: | OKR - Contracts for Rights (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT JLAB.ROWID ROW_ID
, JLAB.LOCATION_AREA_ID
, JLAB.LAST_UPDATE_DATE
, JLAB.LAST_UPDATED_BY
, JLAB.CREATION_DATE
, JLAB.CREATED_BY
, JLAB.LAST_UPDATE_LOGIN
, JLAB.REQUEST_ID
, JLAB.PROGRAM_APPLICATION_ID
, JLAB.PROGRAM_ID
, JLAB.PROGRAM_UPDATE_DATE
, JLAB.OBJECT_VERSION_NUMBER
, JLAB.LOCATION_TYPE_CODE
, JLTV.LOCATION_TYPE_NAME
, JLAB.START_DATE_ACTIVE
, JLAB.END_DATE_ACTIVE
, JLAB.LOCATION_AREA_CODE
, JLAB.ORIG_SYSTEM_ID
, JLAB.ORIG_SYSTEM_REF
, JLAB.PARENT_LOCATION_AREA_ID
, JLAT.LOCATION_AREA_NAME
, JLAT.LOCATION_AREA_DESCRIPTION
FROM JTF_LOC_AREAS_TL JLAT
, JTF_LOC_AREAS_B JLAB
, JTF_LOC_TYPES_VL JLTV
WHERE JLAB.LOCATION_AREA_ID = JLAT.LOCATION_AREA_ID
AND JLAB.LOCATION_TYPE_CODE = JLTV.LOCATION_TYPE_CODE
AND JLAT.LANGUAGE = USERENV('LANG')