VIEW: APPS.IGS_AS_USEC_ATTEND_ENTRY_V

Source

View Text - Preformatted

SELECT ttl.load_description, ttl.teach_description, uoo.unit_cd, uoo.unit_class, uoo.location_description location, 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 teach_cal_type, uoo.ci_sequence_number teach_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 AND sysdate > (SELECT max(cdi.alias_val) attendance_start_dt FROM igs_ca_da_inst_v cdi, igs_as_cal_conf cac WHERE cdi.dt_alias = cac.final_mgs_start_dt_alias AND cdi.cal_type = uoo.cal_type AND cdi.ci_sequence_number = uoo.ci_sequence_number)

View Text - HTML Formatted

SELECT TTL.LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION
, UOO.UNIT_CD
, UOO.UNIT_CLASS
, UOO.LOCATION_DESCRIPTION LOCATION
, 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 TEACH_CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER TEACH_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
AND SYSDATE > (SELECT MAX(CDI.ALIAS_VAL) ATTENDANCE_START_DT
FROM IGS_CA_DA_INST_V CDI
, IGS_AS_CAL_CONF CAC
WHERE CDI.DT_ALIAS = CAC.FINAL_MGS_START_DT_ALIAS
AND CDI.CAL_TYPE = UOO.CAL_TYPE
AND CDI.CI_SEQUENCE_NUMBER = UOO.CI_SEQUENCE_NUMBER)