View: IGS_PS_FAC_USEC_HIST_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PS_FAC_USEC_HIST_V

View Text

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(+)

Columns