[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 |