eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGS_EN_SS_SCHEDULE_DISP_V

Source

View Text - Preformatted


SELECT sca.person_id, sca.course_cd program_cd, sca.version_number, pv.course_type career, igs_en_spa_terms_api.get_spat_att_type(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), igs_en_spa_terms_api.get_spat_att_type_desc(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), igs_en_spa_terms_api.get_spat_att_mode(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), igs_en_spa_terms_api.get_spat_att_mode_desc(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), igs_en_spa_terms_api.get_spat_location(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), igs_en_spa_terms_api.get_spat_location_desc(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), cir.sub_cal_type, cir.sub_ci_sequence_number, ci1.description term_description, ci1.start_dt, cir.sup_cal_type, cir.sup_ci_sequence_number, ci2.description academic_description, DECODE((SELECT 'Y' FROM igs_en_su_attempt sua WHERE sua.person_id = sca.person_id AND sua.course_cd = sca.course_cd AND sua.unit_attempt_status = 'UNCONFIRM' AND rownum = 1 AND (sua.cal_type,sua.ci_sequence_number) IN(SELECT teach_cal_type,teach_ci_sequence_number FROM igs_ca_load_to_teach_v WHERE load_cal_type = ci1.cal_type AND load_ci_sequence_number = ci1.sequence_number)),'Y','Y','N') unconf_sua, Igs_En_Elgbl_Program.get_applied_min_cp(sca.person_id,ci1.cal_type,ci1.sequence_number,sca.course_cd,sca.version_number), Igs_En_Elgbl_Program.get_applied_max_cp(sca.person_id,ci1.cal_type,ci1.sequence_number,sca.course_cd,sca.version_number), Igs_En_Prc_Load.enrp_get_inst_attendance(sca.person_id,ci1.cal_type,ci1.sequence_number), Igs_En_Prc_Load.enrp_get_inst_cp(sca.person_id,ci1.cal_type,ci1.sequence_number), Igs_Ss_Enr_Details.get_pri_prg_title(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), Igs_Ss_Enr_Details.get_sec_prg_title(sca.person_id,sca.course_cd,sca.version_number,ci1.cal_type,ci1.sequence_number), Igs_Ss_Enr_Details.get_stud_yop_unit_set(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number), igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id,sca.course_cd,ci1.cal_type,ci1.sequence_number) FROM igs_en_stdnt_ps_att sca, igs_ps_ver pv, igs_ca_inst_rel cir, igs_ca_inst ci1, igs_ca_inst ci2, igs_ca_type ct WHERE sca.course_cd = pv.course_cd AND sca.version_number = pv.version_number AND sca.cal_type = cir.sup_cal_type AND cir.sub_cal_type = ci1.cal_type AND cir.sub_ci_sequence_number = ci1.sequence_number AND cir.sub_cal_type = ct.cal_type AND ct.s_cal_cat = 'LOAD' AND ci1.ss_displayed = 'Y' AND cir.sup_cal_type = ci2.cal_type AND cir.sup_ci_sequence_number = ci2.sequence_number AND sca.course_attempt_status IN ('ENROLLED','INACTIVE','INTERMIT')

View Text - HTML Formatted

SELECT SCA.PERSON_ID
, SCA.COURSE_CD PROGRAM_CD
, SCA.VERSION_NUMBER
, PV.COURSE_TYPE CAREER
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_TYPE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_TYPE_DESC(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_MODE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_ATT_MODE_DESC(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_LOCATION(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_LOCATION_DESC(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, CIR.SUB_CAL_TYPE
, CIR.SUB_CI_SEQUENCE_NUMBER
, CI1.DESCRIPTION TERM_DESCRIPTION
, CI1.START_DT
, CIR.SUP_CAL_TYPE
, CIR.SUP_CI_SEQUENCE_NUMBER
, CI2.DESCRIPTION ACADEMIC_DESCRIPTION
, DECODE((SELECT 'Y'
FROM IGS_EN_SU_ATTEMPT SUA
WHERE SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND SUA.UNIT_ATTEMPT_STATUS = 'UNCONFIRM'
AND ROWNUM = 1
AND (SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER) IN(SELECT TEACH_CAL_TYPE
, TEACH_CI_SEQUENCE_NUMBER
FROM IGS_CA_LOAD_TO_TEACH_V
WHERE LOAD_CAL_TYPE = CI1.CAL_TYPE
AND LOAD_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER))
, 'Y'
, 'Y'
, 'N') UNCONF_SUA
, IGS_EN_ELGBL_PROGRAM.GET_APPLIED_MIN_CP(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER)
, IGS_EN_ELGBL_PROGRAM.GET_APPLIED_MAX_CP(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER)
, IGS_EN_PRC_LOAD.ENRP_GET_INST_ATTENDANCE(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_PRC_LOAD.ENRP_GET_INST_CP(SCA.PERSON_ID
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_SS_ENR_DETAILS.GET_PRI_PRG_TITLE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_SS_ENR_DETAILS.GET_SEC_PRG_TITLE(SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_SS_ENR_DETAILS.GET_STUD_YOP_UNIT_SET(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
, IGS_EN_SPA_TERMS_API.GET_SPAT_PRIMARY_PRG(SCA.PERSON_ID
, SCA.COURSE_CD
, CI1.CAL_TYPE
, CI1.SEQUENCE_NUMBER)
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_VER PV
, IGS_CA_INST_REL CIR
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, IGS_CA_TYPE CT
WHERE SCA.COURSE_CD = PV.COURSE_CD
AND SCA.VERSION_NUMBER = PV.VERSION_NUMBER
AND SCA.CAL_TYPE = CIR.SUP_CAL_TYPE
AND CIR.SUB_CAL_TYPE = CI1.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER
AND CIR.SUB_CAL_TYPE = CT.CAL_TYPE
AND CT.S_CAL_CAT = 'LOAD'
AND CI1.SS_DISPLAYED = 'Y'
AND CIR.SUP_CAL_TYPE = CI2.CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER
AND SCA.COURSE_ATTEMPT_STATUS IN ('ENROLLED'
, 'INACTIVE'
, 'INTERMIT')