VIEW: APPS.IGS_AS_USEC_CLASSLIST_V

Source

View Text - Preformatted

SELECT ttl.load_description, ttl.teach_description, uoo.unit_cd, uoo.unit_class, uoo.location_description, uoo.call_number, uoo.title, hz.person_last_name || ', ' || hz.person_first_name || ' ' || hz.person_middle_name instructor_name, uoo.uoo_id, ustr.instructor_id, ttl.load_cal_type, ttl.load_ci_sequence_number, ttl.load_start_dt, ttl.load_end_dt, uoo.cal_type, uoo.ci_sequence_number FROM igs_ps_unit_ofr_opt_v uoo, hz_parties hz, igs_ca_teach_to_load_v ttl, igs_ps_usec_tch_resp ustr WHERE uoo.uoo_id=ustr.uoo_id AND uoo.unit_section_status IN ('OPEN','CLOSED','HOLD','FULLWAITOK') AND ustr.lead_instructor_flag ='Y' AND ustr.instructor_id = hz.party_id AND uoo.cal_type = ttl.teach_cal_type AND uoo.ci_sequence_number = ttl.teach_ci_sequence_number

View Text - HTML Formatted

SELECT TTL.LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION
, UOO.UNIT_CD
, UOO.UNIT_CLASS
, UOO.LOCATION_DESCRIPTION
, UOO.CALL_NUMBER
, UOO.TITLE
, HZ.PERSON_LAST_NAME || '
, ' || HZ.PERSON_FIRST_NAME || ' ' || HZ.PERSON_MIDDLE_NAME INSTRUCTOR_NAME
, UOO.UOO_ID
, USTR.INSTRUCTOR_ID
, TTL.LOAD_CAL_TYPE
, TTL.LOAD_CI_SEQUENCE_NUMBER
, TTL.LOAD_START_DT
, TTL.LOAD_END_DT
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
FROM IGS_PS_UNIT_OFR_OPT_V UOO
, HZ_PARTIES HZ
, IGS_CA_TEACH_TO_LOAD_V TTL
, IGS_PS_USEC_TCH_RESP USTR
WHERE UOO.UOO_ID=USTR.UOO_ID
AND UOO.UNIT_SECTION_STATUS IN ('OPEN'
, 'CLOSED'
, 'HOLD'
, 'FULLWAITOK')
AND USTR.LEAD_INSTRUCTOR_FLAG ='Y'
AND USTR.INSTRUCTOR_ID = HZ.PARTY_ID
AND UOO.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER