VIEW: APPS.IGS_PS_FAC_USEC_HIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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