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.

[Home] [Help]

VIEW: APPS.IGS_AS_SUAH_LOAD_V

Source

View Text - Preformatted


SELECT suaehv.person_id, suaehv.course_cd, suaehv.unit_cd, suaehv.version_number, suaehv.CAL_TYPE, suaehv.ci_sequence_number, suaehv.effective_start_dt, suaehv.effective_end_dt, suaehv.unit_attempt_status, suas.fee_ass_ind, suaehv.ADMINISTRATIVE_UNIT_STATUS, suaehv.enrolled_dt, suaehv.discontinued_dt, ci.load_CAL_TYPE, ci.load_ci_sequence_number, suaehv.created_by, suaehv.creation_date, suaehv.last_updated_by, suaehv.last_update_date, suaehv.last_update_login, SUBSTR(IGS_EN_PRC_LOAD.enrp_get_load_apply( suaehv.CAL_TYPE, suaehv.ci_sequence_number, suaehv.discontinued_dt, suaehv.ADMINISTRATIVE_UNIT_STATUS, suaehv.unit_attempt_status, suaehv.no_assessment_ind, ci.load_CAL_TYPE, ci.load_ci_sequence_number),1,1), DECODE(IGS_EN_PRC_LOAD.enrp_get_load_apply( suaehv.CAL_TYPE, suaehv.ci_sequence_number, suaehv.discontinued_dt, suaehv.ADMINISTRATIVE_UNIT_STATUS, suaehv.unit_attempt_status, suaehv.no_assessment_ind, ci.load_CAL_TYPE, ci.load_ci_sequence_number), 'Y', IGS_EN_GEN_014.enrs_clc_sua_eftsut( suaehv.person_id, suaehv.course_cd, sca.version_number, suaehv.unit_cd, suaehv.version_number, suaehv.CAL_TYPE, suaehv.ci_sequence_number, IGS_PS_GEN_006.crsp_get_uoo_id(suaehv.unit_cd, suaehv.version_number, suaehv.CAL_TYPE, suaehv.ci_sequence_number, suaehv.location_cd, suaehv.UNIT_CLASS), suaehv.override_enrolled_cp, suaehv.override_eftsu, NULL), 'N', 0), DECODE(IGS_EN_PRC_LOAD.enrp_get_load_apply( suaehv.CAL_TYPE, suaehv.ci_sequence_number, suaehv.discontinued_dt, suaehv.ADMINISTRATIVE_UNIT_STATUS, suaehv.unit_attempt_status, suaehv.no_assessment_ind, ci.load_CAL_TYPE, ci.load_ci_sequence_number), 'Y', IGS_EN_GEN_014.enrs_clc_sua_cp( suaehv.person_id, suaehv.course_cd, sca.version_number, suaehv.unit_cd, suaehv.version_number, suaehv.CAL_TYPE, suaehv.ci_sequence_number, IGS_PS_GEN_006.crsp_get_uoo_id(suaehv.unit_cd, suaehv.version_number, suaehv.CAL_TYPE, suaehv.ci_sequence_number, suaehv.location_cd, suaehv.UNIT_CLASS), ci.load_CAL_TYPE, ci.load_ci_sequence_number, suaehv.override_enrolled_cp, suaehv.override_eftsu, 'Y', NULL), 'N', 0) ,sua.deg_aud_detail_id, suaehv.uoo_id FROM IGS_AS_SUAH_EFFECTIVE_H_V suaehv, IGS_EN_SU_ATTEMPT sua, IGS_EN_STDNT_PS_ATT sca, IGS_LOOKUPS_VIEW suas, Igs_ca_teach_to_load_v ci WHERE sua.person_id = suaehv.person_id AND /*Join to sua is used to */ sua.course_cd = suaehv.course_cd AND /* prevent history being found */ sua.uoo_id = suaehv.uoo_id AND /* when the unit attempt has been deleted */ sca.person_id = suaehv.person_id AND sca.course_cd = suaehv.course_cd AND suas.LOOKUP_CODE = suaehv.unit_attempt_status AND suas.lookup_type = 'UNIT_ATTEMPT_STATUS' AND sua.CAL_TYPE = ci.teach_cal_type AND sua.ci_sequence_number = ci.teach_ci_sequence_number

View Text - HTML Formatted

SELECT SUAEHV.PERSON_ID
, SUAEHV.COURSE_CD
, SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.EFFECTIVE_START_DT
, SUAEHV.EFFECTIVE_END_DT
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAS.FEE_ASS_IND
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.ENROLLED_DT
, SUAEHV.DISCONTINUED_DT
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER
, SUAEHV.CREATED_BY
, SUAEHV.CREATION_DATE
, SUAEHV.LAST_UPDATED_BY
, SUAEHV.LAST_UPDATE_DATE
, SUAEHV.LAST_UPDATE_LOGIN
, SUBSTR(IGS_EN_PRC_LOAD.ENRP_GET_LOAD_APPLY( SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.DISCONTINUED_DT
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAEHV.NO_ASSESSMENT_IND
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER)
, 1
, 1)
, DECODE(IGS_EN_PRC_LOAD.ENRP_GET_LOAD_APPLY( SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.DISCONTINUED_DT
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAEHV.NO_ASSESSMENT_IND
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER)
, 'Y'
, IGS_EN_GEN_014.ENRS_CLC_SUA_EFTSUT( SUAEHV.PERSON_ID
, SUAEHV.COURSE_CD
, SCA.VERSION_NUMBER
, SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, IGS_PS_GEN_006.CRSP_GET_UOO_ID(SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.LOCATION_CD
, SUAEHV.UNIT_CLASS)
, SUAEHV.OVERRIDE_ENROLLED_CP
, SUAEHV.OVERRIDE_EFTSU
, NULL)
, 'N'
, 0)
, DECODE(IGS_EN_PRC_LOAD.ENRP_GET_LOAD_APPLY( SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.DISCONTINUED_DT
, SUAEHV.ADMINISTRATIVE_UNIT_STATUS
, SUAEHV.UNIT_ATTEMPT_STATUS
, SUAEHV.NO_ASSESSMENT_IND
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER)
, 'Y'
, IGS_EN_GEN_014.ENRS_CLC_SUA_CP( SUAEHV.PERSON_ID
, SUAEHV.COURSE_CD
, SCA.VERSION_NUMBER
, SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, IGS_PS_GEN_006.CRSP_GET_UOO_ID(SUAEHV.UNIT_CD
, SUAEHV.VERSION_NUMBER
, SUAEHV.CAL_TYPE
, SUAEHV.CI_SEQUENCE_NUMBER
, SUAEHV.LOCATION_CD
, SUAEHV.UNIT_CLASS)
, CI.LOAD_CAL_TYPE
, CI.LOAD_CI_SEQUENCE_NUMBER
, SUAEHV.OVERRIDE_ENROLLED_CP
, SUAEHV.OVERRIDE_EFTSU
, 'Y'
, NULL)
, 'N'
, 0)
, SUA.DEG_AUD_DETAIL_ID
, SUAEHV.UOO_ID
FROM IGS_AS_SUAH_EFFECTIVE_H_V SUAEHV
, IGS_EN_SU_ATTEMPT SUA
, IGS_EN_STDNT_PS_ATT SCA
, IGS_LOOKUPS_VIEW SUAS
, IGS_CA_TEACH_TO_LOAD_V CI
WHERE SUA.PERSON_ID = SUAEHV.PERSON_ID
AND /*JOIN TO SUA IS USED TO */ SUA.COURSE_CD = SUAEHV.COURSE_CD
AND /* PREVENT HISTORY BEING FOUND */ SUA.UOO_ID = SUAEHV.UOO_ID
AND /* WHEN THE UNIT ATTEMPT HAS BEEN DELETED */ SCA.PERSON_ID = SUAEHV.PERSON_ID
AND SCA.COURSE_CD = SUAEHV.COURSE_CD
AND SUAS.LOOKUP_CODE = SUAEHV.UNIT_ATTEMPT_STATUS
AND SUAS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'
AND SUA.CAL_TYPE = CI.TEACH_CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = CI.TEACH_CI_SEQUENCE_NUMBER