VIEW: APPS.IGS_PS_FAC_USEC_TCH_HIST_V

Source

View Text - Preformatted

SELECT utr.instructor_id instructor_id, uof.uoo_id uoo_id, uof.cal_type cal_type, uof.ci_sequence_number ci_sequence_number, uof.unit_cd unit_cd, uof.version_number version_number, uof.unit_class unit_class, al.description location_description, uv.title unit_title, utr.instructional_load_lecture instructional_load_lecture, utr.instructional_load_lab instructional_load_lab, utr.instructional_load instructional_load, NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points, IGS_PS_FAC_CREDT_WRKLOAD.prgp_get_lead_instructor(uof.uoo_id) lead_instructor, utr.created_by created_by, utr.creation_date creation_date, utr.last_updated_by last_updated_by, utr.last_update_date last_update_date, utr.last_update_login last_update_login FROM igs_ps_unit_ofr_opt uof, igs_ps_usec_tch_resp utr, igs_ps_unit_ver uv , igs_ad_location al, igs_ps_usec_cps cps WHERE uof.uoo_id = utr.uoo_id AND uof.unit_cd = uv.unit_cd AND uof.version_number = uv.version_number AND uof.location_cd=al.location_cd AND uof.uoo_id = cps.uoo_id(+)

View Text - HTML Formatted

SELECT UTR.INSTRUCTOR_ID INSTRUCTOR_ID
, UOF.UOO_ID UOO_ID
, UOF.CAL_TYPE CAL_TYPE
, UOF.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UOF.UNIT_CD UNIT_CD
, UOF.VERSION_NUMBER VERSION_NUMBER
, UOF.UNIT_CLASS UNIT_CLASS
, AL.DESCRIPTION LOCATION_DESCRIPTION
, UV.TITLE UNIT_TITLE
, UTR.INSTRUCTIONAL_LOAD_LECTURE INSTRUCTIONAL_LOAD_LECTURE
, UTR.INSTRUCTIONAL_LOAD_LAB INSTRUCTIONAL_LOAD_LAB
, UTR.INSTRUCTIONAL_LOAD INSTRUCTIONAL_LOAD
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV.ENROLLED_CREDIT_POINTS) ENROLLED_CREDIT_POINTS
, IGS_PS_FAC_CREDT_WRKLOAD.PRGP_GET_LEAD_INSTRUCTOR(UOF.UOO_ID) LEAD_INSTRUCTOR
, UTR.CREATED_BY CREATED_BY
, UTR.CREATION_DATE CREATION_DATE
, UTR.LAST_UPDATED_BY LAST_UPDATED_BY
, UTR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UTR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOF
, IGS_PS_USEC_TCH_RESP UTR
, IGS_PS_UNIT_VER UV
, IGS_AD_LOCATION AL
, IGS_PS_USEC_CPS CPS
WHERE UOF.UOO_ID = UTR.UOO_ID
AND UOF.UNIT_CD = UV.UNIT_CD
AND UOF.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOF.LOCATION_CD=AL.LOCATION_CD
AND UOF.UOO_ID = CPS.UOO_ID(+)