VIEW: APPS.IGS_AS_X_USEC_CLASSLIST_V

Source

View Text - Preformatted

SELECT ttl.load_description, ttl.teach_description, uxg.usec_x_listed_group_name, uoo.location_description, hz.person_last_name || ', ' || hz.person_first_name || ' ' || hz.person_middle_name instructor_name, ustr.instructor_id, uxg.usec_x_listed_group_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_usec_x_grp uxg, igs_ps_usec_x_grpmem uxgm, igs_ps_unit_ofr_opt_v uoo, igs_ps_usec_tch_resp ustr, hz_parties hz, igs_ca_teach_to_load_v ttl WHERE uxg.usec_x_listed_group_id = uxgm.usec_x_listed_group_id and uxgm.uoo_id = uoo.uoo_id and uxgm.parent ='Y' and uoo.unit_section_status in('OPEN','HOLD','CLOSED','FULLWAITOK') and uoo.uoo_id = ustr.uoo_id and ustr.lead_instructor_flag ='Y' and ustr.instructor_id = hz.party_id and uxg.cal_type = ttl.teach_cal_type and uxg.ci_sequence_number = ttl.teach_ci_sequence_number

View Text - HTML Formatted

SELECT TTL.LOAD_DESCRIPTION
, TTL.TEACH_DESCRIPTION
, UXG.USEC_X_LISTED_GROUP_NAME
, UOO.LOCATION_DESCRIPTION
, HZ.PERSON_LAST_NAME || '
, ' || HZ.PERSON_FIRST_NAME || ' ' || HZ.PERSON_MIDDLE_NAME INSTRUCTOR_NAME
, USTR.INSTRUCTOR_ID
, UXG.USEC_X_LISTED_GROUP_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_USEC_X_GRP UXG
, IGS_PS_USEC_X_GRPMEM UXGM
, IGS_PS_UNIT_OFR_OPT_V UOO
, IGS_PS_USEC_TCH_RESP USTR
, HZ_PARTIES HZ
, IGS_CA_TEACH_TO_LOAD_V TTL
WHERE UXG.USEC_X_LISTED_GROUP_ID = UXGM.USEC_X_LISTED_GROUP_ID
AND UXGM.UOO_ID = UOO.UOO_ID
AND UXGM.PARENT ='Y'
AND UOO.UNIT_SECTION_STATUS IN('OPEN'
, 'HOLD'
, 'CLOSED'
, 'FULLWAITOK')
AND UOO.UOO_ID = USTR.UOO_ID
AND USTR.LEAD_INSTRUCTOR_FLAG ='Y'
AND USTR.INSTRUCTOR_ID = HZ.PARTY_ID
AND UXG.CAL_TYPE = TTL.TEACH_CAL_TYPE
AND UXG.CI_SEQUENCE_NUMBER = TTL.TEACH_CI_SEQUENCE_NUMBER