VIEW: APPS.IGS_EN_USEC_EXAM_SCH_V

Source

View Text - Preformatted

SELECT uoov.row_id row_id, uoov.unit_cd, uoov.unit_class, uoov.call_number, uoov.title, uoov.uoo_id, usas.final_exam_date, usas.exam_start_time, usas.exam_end_time , INITCAP(TO_CHAR(usas.final_exam_date,'DAY') ), usas.location_cd , usas.location_desc , usas.building_code , usas.building_desc , usas.room_code , usas.room_desc , utr. person_number, utr.surname, usas.created_by , usas.creation_date , usas.last_updated_by , usas.last_update_date , usas.last_update_login FROM igs_ps_usec_as_v usas, igs_ps_unit_ofr_opt_v uoov, igs_ps_usec_tch_resp_v utr WHERE usas.uoo_id = uoov.uoo_id AND usas.uoo_id = utr.uoo_id AND utr.lead_instructor_flag = 'Y'

View Text - HTML Formatted

SELECT UOOV.ROW_ID ROW_ID
, UOOV.UNIT_CD
, UOOV.UNIT_CLASS
, UOOV.CALL_NUMBER
, UOOV.TITLE
, UOOV.UOO_ID
, USAS.FINAL_EXAM_DATE
, USAS.EXAM_START_TIME
, USAS.EXAM_END_TIME
, INITCAP(TO_CHAR(USAS.FINAL_EXAM_DATE
, 'DAY') )
, USAS.LOCATION_CD
, USAS.LOCATION_DESC
, USAS.BUILDING_CODE
, USAS.BUILDING_DESC
, USAS.ROOM_CODE
, USAS.ROOM_DESC
, UTR. PERSON_NUMBER
, UTR.SURNAME
, USAS.CREATED_BY
, USAS.CREATION_DATE
, USAS.LAST_UPDATED_BY
, USAS.LAST_UPDATE_DATE
, USAS.LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_AS_V USAS
, IGS_PS_UNIT_OFR_OPT_V UOOV
, IGS_PS_USEC_TCH_RESP_V UTR
WHERE USAS.UOO_ID = UOOV.UOO_ID
AND USAS.UOO_ID = UTR.UOO_ID
AND UTR.LEAD_INSTRUCTOR_FLAG = 'Y'