VIEW: APPS.IGS_EN_SUA_V

Source

View Text - Preformatted

SELECT sua.row_id, sua.person_id, pe1.party_number, sua.course_cd, sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number, IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua.cal_type,sua.ci_sequence_number), IGS_CA_GEN_001.calp_get_alt_cd(sua.cal_type,sua.ci_sequence_number), sua.location_cd, sua.unit_class, 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, null, 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, sua.created_by, sua.creation_date, sua.last_updated_by, sua.last_update_date, sua.last_update_login, sua.administrative_priority, sua.waitlist_dt, sua.waitlist_manual_ind, sua.dcnt_reason_cd ,sua. GS_VERSION_NUMBER, sua.ENR_METHOD_TYPE , sua.FAILED_UNIT_RULE, sua.CART, sua.RSV_SEAT_EXT_ID, sua.ORG_UNIT_CD , sua.session_id , sua.grading_schema_code GRADING_SCHEMA_CODE ,sua.deg_aud_detail_id DEG_AUD_DETAIL_ID ,sua.student_career_transcript ,sua.student_career_statistics ,sua.subtitle ,sua.ATTRIBUTE_CATEGORY ,sua.ATTRIBUTE1 ,sua.ATTRIBUTE2 ,sua.ATTRIBUTE3 ,sua.ATTRIBUTE4 ,sua.ATTRIBUTE5 ,sua.ATTRIBUTE6 ,sua.ATTRIBUTE7 ,sua.ATTRIBUTE8 ,sua.ATTRIBUTE9 ,sua.ATTRIBUTE10 ,sua.ATTRIBUTE11 ,sua.ATTRIBUTE12 ,sua.ATTRIBUTE13 ,sua.ATTRIBUTE14 ,sua.ATTRIBUTE15 ,sua.ATTRIBUTE16 ,sua.ATTRIBUTE17 ,sua.ATTRIBUTE18 ,sua.ATTRIBUTE19 ,sua.ATTRIBUTE20 ,sua.WLST_PRIORITY_WEIGHT_NUM ,sua.WLST_PREFERENCE_WEIGHT_NUM ,sua.CORE_INDICATOR_CODE, sua.UPD_AUDIT_FLAG, sua.SS_SOURCE_IND FROM IGS_EN_SU_ATTEMPT sua, HZ_PARTIES pe1 WHERE sua.rule_waived_person_id IS NULL AND pe1.party_id = sua.person_id union select sua2.rowid, sua2.person_id, pe3.party_number, sua2.course_cd, sua2.unit_cd, sua2.version_number, sua2.cal_type, sua2.ci_sequence_number, IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua2.cal_type,sua2.ci_sequence_number), IGS_CA_GEN_001.calp_get_alt_cd(sua2.cal_type,sua2.ci_sequence_number), sua2.location_cd, sua2.unit_class, sua2.ci_start_dt, sua2.ci_end_dt, sua2.uoo_id, sua2.enrolled_dt, sua2.unit_attempt_status, sua2.administrative_unit_status, sua2.discontinued_dt, sua2.rule_waived_dt, sua2.rule_waived_person_id, pe2.party_number, sua2.no_assessment_ind, sua2.sup_unit_cd, sua2.sup_version_number, sua2.exam_location_cd, sua2.alternative_title, sua2.override_enrolled_cp, sua2.override_eftsu, sua2.override_achievable_cp, sua2.override_outcome_due_dt, sua2.override_credit_reason, sua2.created_by, sua2.creation_date, sua2.last_updated_by, sua2.last_update_date, sua2.last_update_login, sua2.administrative_priority, sua2.waitlist_dt, sua2.waitlist_manual_ind, sua2.dcnt_reason_cd, sua2. GS_VERSION_NUMBER, sua2.ENR_METHOD_TYPE , sua2.FAILED_UNIT_RULE, sua2.CART, sua2.RSV_SEAT_EXT_ID , sua2.ORG_UNIT_CD ,sua2.SESSION_ID , sua2.grading_schema_code GRADING_SCHEMA_CODE ,sua2.deg_aud_detail_id DEG_AUD_DETAIL_ID ,sua2.student_career_transcript ,sua2.student_career_statistics ,sua2.subtitle ,sua2.ATTRIBUTE_CATEGORY ,sua2.ATTRIBUTE1 ,sua2.ATTRIBUTE2 ,sua2.ATTRIBUTE3 ,sua2.ATTRIBUTE4 ,sua2.ATTRIBUTE5 ,sua2.ATTRIBUTE6 ,sua2.ATTRIBUTE7 ,sua2.ATTRIBUTE8 ,sua2.ATTRIBUTE9 ,sua2.ATTRIBUTE10 ,sua2.ATTRIBUTE11 ,sua2.ATTRIBUTE12 ,sua2.ATTRIBUTE13 ,sua2.ATTRIBUTE14 ,sua2.ATTRIBUTE15 ,sua2.ATTRIBUTE16 ,sua2.ATTRIBUTE17 ,sua2.ATTRIBUTE18 ,sua2.ATTRIBUTE19 ,sua2.ATTRIBUTE20 ,sua2.WLST_PRIORITY_WEIGHT_NUM ,sua2.WLST_PREFERENCE_WEIGHT_NUM ,sua2.CORE_INDICATOR_CODE, sua2.UPD_AUDIT_FLAG, sua2.SS_SOURCE_IND FROM IGS_EN_SU_ATTEMPT sua2, HZ_PARTIES pe2, HZ_PARTIES pe3 where sua2.rule_waived_person_id IS NOT NULL AND sua2.rule_waived_person_id = pe2.party_id AND sua2.person_id = pe3.party_id

View Text - HTML Formatted

SELECT SUA.ROW_ID
, SUA.PERSON_ID
, PE1.PARTY_NUMBER
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, 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
, NULL
, 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
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN
, SUA.ADMINISTRATIVE_PRIORITY
, SUA.WAITLIST_DT
, SUA.WAITLIST_MANUAL_IND
, SUA.DCNT_REASON_CD
, SUA. GS_VERSION_NUMBER
, SUA.ENR_METHOD_TYPE
, SUA.FAILED_UNIT_RULE
, SUA.CART
, SUA.RSV_SEAT_EXT_ID
, SUA.ORG_UNIT_CD
, SUA.SESSION_ID
, SUA.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, SUA.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
, SUA.STUDENT_CAREER_TRANSCRIPT
, SUA.STUDENT_CAREER_STATISTICS
, SUA.SUBTITLE
, SUA.ATTRIBUTE_CATEGORY
, SUA.ATTRIBUTE1
, SUA.ATTRIBUTE2
, SUA.ATTRIBUTE3
, SUA.ATTRIBUTE4
, SUA.ATTRIBUTE5
, SUA.ATTRIBUTE6
, SUA.ATTRIBUTE7
, SUA.ATTRIBUTE8
, SUA.ATTRIBUTE9
, SUA.ATTRIBUTE10
, SUA.ATTRIBUTE11
, SUA.ATTRIBUTE12
, SUA.ATTRIBUTE13
, SUA.ATTRIBUTE14
, SUA.ATTRIBUTE15
, SUA.ATTRIBUTE16
, SUA.ATTRIBUTE17
, SUA.ATTRIBUTE18
, SUA.ATTRIBUTE19
, SUA.ATTRIBUTE20
, SUA.WLST_PRIORITY_WEIGHT_NUM
, SUA.WLST_PREFERENCE_WEIGHT_NUM
, SUA.CORE_INDICATOR_CODE
, SUA.UPD_AUDIT_FLAG
, SUA.SS_SOURCE_IND
FROM IGS_EN_SU_ATTEMPT SUA
, HZ_PARTIES PE1
WHERE SUA.RULE_WAIVED_PERSON_ID IS NULL
AND PE1.PARTY_ID = SUA.PERSON_ID UNION SELECT SUA2.ROWID
, SUA2.PERSON_ID
, PE3.PARTY_NUMBER
, SUA2.COURSE_CD
, SUA2.UNIT_CD
, SUA2.VERSION_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER)
, IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER)
, SUA2.LOCATION_CD
, SUA2.UNIT_CLASS
, SUA2.CI_START_DT
, SUA2.CI_END_DT
, SUA2.UOO_ID
, SUA2.ENROLLED_DT
, SUA2.UNIT_ATTEMPT_STATUS
, SUA2.ADMINISTRATIVE_UNIT_STATUS
, SUA2.DISCONTINUED_DT
, SUA2.RULE_WAIVED_DT
, SUA2.RULE_WAIVED_PERSON_ID
, PE2.PARTY_NUMBER
, SUA2.NO_ASSESSMENT_IND
, SUA2.SUP_UNIT_CD
, SUA2.SUP_VERSION_NUMBER
, SUA2.EXAM_LOCATION_CD
, SUA2.ALTERNATIVE_TITLE
, SUA2.OVERRIDE_ENROLLED_CP
, SUA2.OVERRIDE_EFTSU
, SUA2.OVERRIDE_ACHIEVABLE_CP
, SUA2.OVERRIDE_OUTCOME_DUE_DT
, SUA2.OVERRIDE_CREDIT_REASON
, SUA2.CREATED_BY
, SUA2.CREATION_DATE
, SUA2.LAST_UPDATED_BY
, SUA2.LAST_UPDATE_DATE
, SUA2.LAST_UPDATE_LOGIN
, SUA2.ADMINISTRATIVE_PRIORITY
, SUA2.WAITLIST_DT
, SUA2.WAITLIST_MANUAL_IND
, SUA2.DCNT_REASON_CD
, SUA2. GS_VERSION_NUMBER
, SUA2.ENR_METHOD_TYPE
, SUA2.FAILED_UNIT_RULE
, SUA2.CART
, SUA2.RSV_SEAT_EXT_ID
, SUA2.ORG_UNIT_CD
, SUA2.SESSION_ID
, SUA2.GRADING_SCHEMA_CODE GRADING_SCHEMA_CODE
, SUA2.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
, SUA2.STUDENT_CAREER_TRANSCRIPT
, SUA2.STUDENT_CAREER_STATISTICS
, SUA2.SUBTITLE
, SUA2.ATTRIBUTE_CATEGORY
, SUA2.ATTRIBUTE1
, SUA2.ATTRIBUTE2
, SUA2.ATTRIBUTE3
, SUA2.ATTRIBUTE4
, SUA2.ATTRIBUTE5
, SUA2.ATTRIBUTE6
, SUA2.ATTRIBUTE7
, SUA2.ATTRIBUTE8
, SUA2.ATTRIBUTE9
, SUA2.ATTRIBUTE10
, SUA2.ATTRIBUTE11
, SUA2.ATTRIBUTE12
, SUA2.ATTRIBUTE13
, SUA2.ATTRIBUTE14
, SUA2.ATTRIBUTE15
, SUA2.ATTRIBUTE16
, SUA2.ATTRIBUTE17
, SUA2.ATTRIBUTE18
, SUA2.ATTRIBUTE19
, SUA2.ATTRIBUTE20
, SUA2.WLST_PRIORITY_WEIGHT_NUM
, SUA2.WLST_PREFERENCE_WEIGHT_NUM
, SUA2.CORE_INDICATOR_CODE
, SUA2.UPD_AUDIT_FLAG
, SUA2.SS_SOURCE_IND
FROM IGS_EN_SU_ATTEMPT SUA2
, HZ_PARTIES PE2
, HZ_PARTIES PE3
WHERE SUA2.RULE_WAIVED_PERSON_ID IS NOT NULL
AND SUA2.RULE_WAIVED_PERSON_ID = PE2.PARTY_ID
AND SUA2.PERSON_ID = PE3.PARTY_ID