VIEW: APPS.IGS_PS_FAC_CAL_INST_V

Source

View Text - Preformatted

SELECT pev.person_id instructor_id, pev.person_number person_number, pev.full_name instructor_name, pev.birth_date birth_dt, pev.gender sex, ci.cal_type cal_type, ci.sequence_number sequence_number, ci.alternate_code alternate_cd, ci.start_dt start_dt, ci.end_dt end_dt, pev.created_by created_by, pev.creation_date creation_date, pev.last_updated_by last_updated_by, pev.last_update_date last_update_date, pev.last_update_login last_update_login FROM igs_ca_inst ci, igs_pe_person_base_v pev, igs_ps_usec_tch_resp usr, igs_ps_unit_ofr_opt_all uoo WHERE pev.person_id=usr.instructor_id AND usr.uoo_id=uoo.uoo_id AND uoo.cal_type=ci.cal_type AND uoo.ci_sequence_number=ci.sequence_number AND uoo.uoo_id = ( SELECT MAX(uoo1.uoo_id) FROM igs_ps_usec_tch_resp usr1, igs_ps_unit_ofr_opt_all uoo1 WHERE uoo1.uoo_id = usr1.uoo_id AND usr1.instructor_id = usr.instructor_id AND uoo.cal_type = uoo1.cal_type AND uoo.ci_sequence_number = uoo1.ci_sequence_number )

View Text - HTML Formatted

SELECT PEV.PERSON_ID INSTRUCTOR_ID
, PEV.PERSON_NUMBER PERSON_NUMBER
, PEV.FULL_NAME INSTRUCTOR_NAME
, PEV.BIRTH_DATE BIRTH_DT
, PEV.GENDER SEX
, CI.CAL_TYPE CAL_TYPE
, CI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CD
, CI.START_DT START_DT
, CI.END_DT END_DT
, PEV.CREATED_BY CREATED_BY
, PEV.CREATION_DATE CREATION_DATE
, PEV.LAST_UPDATED_BY LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI
, IGS_PE_PERSON_BASE_V PEV
, IGS_PS_USEC_TCH_RESP USR
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE PEV.PERSON_ID=USR.INSTRUCTOR_ID
AND USR.UOO_ID=UOO.UOO_ID
AND UOO.CAL_TYPE=CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER
AND UOO.UOO_ID = ( SELECT MAX(UOO1.UOO_ID)
FROM IGS_PS_USEC_TCH_RESP USR1
, IGS_PS_UNIT_OFR_OPT_ALL UOO1
WHERE UOO1.UOO_ID = USR1.UOO_ID
AND USR1.INSTRUCTOR_ID = USR.INSTRUCTOR_ID
AND UOO.CAL_TYPE = UOO1.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = UOO1.CI_SEQUENCE_NUMBER )