Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UL.ROWID ROW_ID
, UL.UNIT_LOCATION_ID UNIT_LOCATION_ID
, UL.UNIT_CODE UNIT_CODE
, UL.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, UL.LOCATION_CODE LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, UL.BUILDING_ID BUILDING_ID
, BLD.BUILDING_CD BUILDING_CD
, BLD.DESCRIPTION BUILDING_DESCRIPTION
, UL.ROOM_ID ROOM_ID
, ROM.ROOM_CD ROOM_CD
, ROM.DESCRIPTION ROOM_DESCRIPTION
, UL.CREATED_BY CREATED_BY
, UL.CREATION_DATE CREATION_DATE
, UL.LAST_UPDATED_BY LAST_UPDATED_BY
, UL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_LOCATION UL
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
, IGS_AD_LOCATION LOC
WHERE UL.LOCATION_CODE = LOC.LOCATION_CD
AND UL.BUILDING_ID = BLD.BUILDING_ID (+)
AND UL.ROOM_ID = ROM.ROOM_ID (+)