VIEW: APPS.IGS_AS_SUA_ASS_V

Source

View Text - Preformatted

SELECT sua.rowid ROW_ID, sua.person_id, sua.course_cd, sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number, SUBSTR(IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua.cal_type,sua.ci_sequence_number),1,10), SUBSTR(IGS_CA_GEN_001.calp_get_alt_cd(sua.cal_type,sua.ci_sequence_number),1,10), sua.location_cd, sua.unit_class, SUBSTR(IGS_PS_GEN_006.crsp_get_ucl_mode(sua.UNIT_CLASS),1,10), sua.ci_start_dt, sua.ci_end_dt, sua.uoo_id, sua.enrolled_dt, sua.unit_attempt_status, sua.administrative_unit_status, sua.discontinued_dt, sua.rule_waived_dt, sua.rule_waived_person_id, pdv2.party_number, sua.no_assessment_ind, sua.sup_unit_cd, sua.sup_version_number, sua.exam_location_cd, sua.alternative_title, sua.override_enrolled_cp, sua.override_eftsu, sua.override_achievable_cp, sua.override_outcome_due_dt, sua.override_credit_reason, pdv1.person_number, pdv1.full_name, pdv1.sex_meaning, pdv1.birth_dt, pdv1.api_person_id, sua.created_by, sua.creation_date, sua.last_updated_by, sua.last_update_date, sua.last_update_login, sua.waitlist_dt, sua.administrative_priority, UOO.CALL_NUMBER CALL_NUMBER , pdv1.FULL_NAME ,sua.deg_aud_detail_id ,cai.description teach_cal_description FROM IGS_EN_SU_ATTEMPT_SV sua, IGS_PS_UNIT_OFR_OPT UOO, igs_pe_person PDV1 , HZ_PARTIES PDV2 , igs_ca_inst cai WHERE PDV1.person_id = SUA.PERSON_ID AND PDV2.PARTY_ID(+) = SUA. RULE_WAIVED_PERSON_ID AND UOO.UOO_ID = SUA.UOO_ID AND cai.cal_type = sua.cal_type AND cai.sequence_number = sua.ci_sequence_number

View Text - HTML Formatted

SELECT SUA.ROWID ROW_ID
, SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, SUBSTR(IGS_PS_GEN_006.CRSP_GET_UCL_MODE(SUA.UNIT_CLASS)
, 1
, 10)
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUA.UOO_ID
, SUA.ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT
, SUA.RULE_WAIVED_DT
, SUA.RULE_WAIVED_PERSON_ID
, PDV2.PARTY_NUMBER
, SUA.NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD
, SUA.ALTERNATIVE_TITLE
, SUA.OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON
, PDV1.PERSON_NUMBER
, PDV1.FULL_NAME
, PDV1.SEX_MEANING
, PDV1.BIRTH_DT
, PDV1.API_PERSON_ID
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN
, SUA.WAITLIST_DT
, SUA.ADMINISTRATIVE_PRIORITY
, UOO.CALL_NUMBER CALL_NUMBER
, PDV1.FULL_NAME
, SUA.DEG_AUD_DETAIL_ID
, CAI.DESCRIPTION TEACH_CAL_DESCRIPTION
FROM IGS_EN_SU_ATTEMPT_SV SUA
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PE_PERSON PDV1
, HZ_PARTIES PDV2
, IGS_CA_INST CAI
WHERE PDV1.PERSON_ID = SUA.PERSON_ID
AND PDV2.PARTY_ID(+) = SUA. RULE_WAIVED_PERSON_ID
AND UOO.UOO_ID = SUA.UOO_ID
AND CAI.CAL_TYPE = SUA.CAL_TYPE
AND CAI.SEQUENCE_NUMBER = SUA.CI_SEQUENCE_NUMBER