[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INS.INSTRUCTOR_ID INSTRUCTOR_ID
, UOF.UOO_ID UOO_ID
, UOF.CAL_TYPE CAL_TYPE
, UOF.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, USO.MONDAY MONDAY
, USO.TUESDAY TUESDAY
, USO.WEDNESDAY WEDNESDAY
, USO.THURSDAY THURSDAY
, USO.FRIDAY FRIDAY
, USO.SATURDAY SATURDAY
, USO.SUNDAY SUNDAY
, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED
, USO.START_TIME START_TIME
, USO.END_TIME END_TIME
, UOF.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, USO.BUILDING_CODE BUILDING_ID
, BLD.DESCRIPTION BUILDING_DESCRIPTION
, USO.ROOM_CODE ROOM_ID
, ROM.DESCRIPTION ROOM_DESCRIPTION
, USO.CREATED_BY CREATED_BY
, USO.CREATION_DATE CREATION_DATE
, USO.LAST_UPDATED_BY LAST_UPDATED_BY
, USO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOF
, IGS_PS_USO_INSTRCTRS_V INS
, IGS_PS_USEC_OCCURS USO
, IGS_AD_LOCATION LOC
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
WHERE UOF.UOO_ID = USO.UOO_ID
AND USO.UNIT_SECTION_OCCURRENCE_ID=INS.UNIT_SECTION_OCCURRENCE_ID
AND UOF.LOCATION_CD = LOC.LOCATION_CD
AND USO.BUILDING_CODE = BLD.BUILDING_ID(+)
AND USO.ROOM_CODE = ROM.ROOM_ID(+)