[Home] [Help]
View: IGS_OR_LOC_REGION_V
Product: | IGS - Student System (Obsolete) |
Description: | Stores the Region Information for a Location. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LOR.ROWID
, LOR.LOCATION_CD
, LOR.REGION_CD
, LOV.MEANING
, LOR.CREATED_BY
, LOR.CREATION_DATE
, LOR.LAST_UPDATED_BY
, LOR.LAST_UPDATE_DATE
, LOR.LAST_UPDATE_LOGIN
FROM IGS_OR_LOC_REGION LOR
, IGS_LOOKUP_VALUES LOV
WHERE LOR.REGION_CD = LOV.LOOKUP_CODE
AND LOV.LOOKUP_TYPE = 'IGS_OR_LOC_REGION'
Columns
Name |
ROW_ID |
LOCATION_CD |
REGION_CD |
REGION_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |