VIEW: APPS.IGS_SS_EN_USEC_EXAM_SCH_V

Source

View Text - Preformatted

SELECT uoov.row_id row_id, uoov.uoo_id, sca.course_cd, sca.version_number, sua.cal_type, sua.ci_sequence_number, sua.person_id, sua.unit_attempt_status, uoov.unit_cd, uoov.unit_class, uoov.call_number, igs_ss_enr_details.get_title_section(sua.person_id, sua.uoo_id,sua.unit_cd,sua.version_number,sua.course_cd) Title, usas.final_exam_date ||'
' || to_char(usas.exam_start_time,'hh:miam')||' - ' || to_char(usas.exam_end_time,'hh:miam') exam_date_time, INITCAP(TO_CHAR(usas.final_exam_date,'DAY') ), usas.location_cd , usas.location_desc , usas.building_desc ||'
'|| usas.room_desc , pe.party_number, decode(pe.party_number,NULL,NULL,pe.person_last_name||', '||pe.person_first_name||' '||pe.person_middle_name), usas.created_by , usas.creation_date , usas.last_updated_by , usas.last_update_date , usas.last_update_login, uoov.location_cd sua_location_cd, sua.core_indicator_code, USAS.FINAL_EXAM_DATE ||' ' || TO_CHAR(USAS.EXAM_START_TIME,'HH:MIAM')||' - ' || TO_CHAR(USAS.EXAM_END_TIME,'HH:MIAM') EXAM_TIMETABLE, NVL(USAS.LOCATION_CD,'-') || '/' || NVL(USAS.BUILDING_DESC,'-') ||'/'|| NVL(USAS.ROOM_DESC,'-') FROM igs_ps_usec_as_v usas, igs_ps_unit_ofr_opt uoov, igs_ps_usec_tch_resp utr, hz_parties pe, igs_en_su_attempt sua, igs_en_stdnt_ps_att sca WHERE usas.uoo_id(+) = uoov.uoo_id AND usas.uoo_id = utr.uoo_id(+) AND utr.lead_instructor_flag(+) = 'Y' AND utr.instructor_id = pe.party_id(+) AND sca.person_id = sua.person_id AND sca.course_cd = sua.course_cd AND uoov.uoo_id =sua.uoo_id AND sua.unit_attempt_status NOT IN ('UNCONFIRM')

View Text - HTML Formatted

SELECT UOOV.ROW_ID ROW_ID
, UOOV.UOO_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.PERSON_ID
, SUA.UNIT_ATTEMPT_STATUS
, UOOV.UNIT_CD
, UOOV.UNIT_CLASS
, UOOV.CALL_NUMBER
, IGS_SS_ENR_DETAILS.GET_TITLE_SECTION(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD) TITLE
, USAS.FINAL_EXAM_DATE ||'
' || TO_CHAR(USAS.EXAM_START_TIME
, 'HH:MIAM')||' - ' || TO_CHAR(USAS.EXAM_END_TIME
, 'HH:MIAM') EXAM_DATE_TIME
, INITCAP(TO_CHAR(USAS.FINAL_EXAM_DATE
, 'DAY') )
, USAS.LOCATION_CD
, USAS.LOCATION_DESC
, USAS.BUILDING_DESC ||'
'|| USAS.ROOM_DESC
, PE.PARTY_NUMBER
, DECODE(PE.PARTY_NUMBER
, NULL
, NULL
, PE.PERSON_LAST_NAME||'
, '||PE.PERSON_FIRST_NAME||' '||PE.PERSON_MIDDLE_NAME)
, USAS.CREATED_BY
, USAS.CREATION_DATE
, USAS.LAST_UPDATED_BY
, USAS.LAST_UPDATE_DATE
, USAS.LAST_UPDATE_LOGIN
, UOOV.LOCATION_CD SUA_LOCATION_CD
, SUA.CORE_INDICATOR_CODE
, USAS.FINAL_EXAM_DATE ||' ' || TO_CHAR(USAS.EXAM_START_TIME
, 'HH:MIAM')||' - ' || TO_CHAR(USAS.EXAM_END_TIME
, 'HH:MIAM') EXAM_TIMETABLE
, NVL(USAS.LOCATION_CD
, '-') || '/' || NVL(USAS.BUILDING_DESC
, '-') ||'/'|| NVL(USAS.ROOM_DESC
, '-')
FROM IGS_PS_USEC_AS_V USAS
, IGS_PS_UNIT_OFR_OPT UOOV
, IGS_PS_USEC_TCH_RESP UTR
, HZ_PARTIES PE
, IGS_EN_SU_ATTEMPT SUA
, IGS_EN_STDNT_PS_ATT SCA
WHERE USAS.UOO_ID(+) = UOOV.UOO_ID
AND USAS.UOO_ID = UTR.UOO_ID(+)
AND UTR.LEAD_INSTRUCTOR_FLAG(+) = 'Y'
AND UTR.INSTRUCTOR_ID = PE.PARTY_ID(+)
AND SCA.PERSON_ID = SUA.PERSON_ID
AND SCA.COURSE_CD = SUA.COURSE_CD
AND UOOV.UOO_ID =SUA.UOO_ID
AND SUA.UNIT_ATTEMPT_STATUS NOT IN ('UNCONFIRM')