VIEW: APPS.IGS_SS_EN_SUA_DTLS_V

Source

View Text - Preformatted

SELECT sua.ROW_ID, sua.person_id, sua.unit_cd, sua.unit_class, uoo.call_number, uoo.unit_section_status, igs_ss_enr_details.get_title_section(sua.person_id,sua.uoo_id,sua.unit_cd,sua.version_number,sua.course_cd), ci.description semester, igs_ss_enr_details.get_occur_cd_details(sua.uoo_id) meetingpattern, igs_ss_enr_details.get_credit_points(sua.person_id, sua.uoo_id, sua.unit_cd, sua.version_number,sua.course_cd), igs_ss_enr_details.get_grading_schema(sua.person_id,sua.uoo_id,sua.unit_cd,sua.version_number,sua.course_cd), sua.unit_attempt_status, flv.meaning||DECODE(sua.unit_attempt_status,'WAITLISTED', '('||sua.administrative_priority||')', NULL)||DECODE(no_assessment_ind,'Y','('||lkp1.meaning||')',NULL), flv.meaning||DECODE(sua.unit_attempt_status,'WAITLISTED', '('||sua.administrative_priority||'/'||uoo.waitlist_actual||')', NULL)||DECODE(no_assessment_ind,'Y','('||lkp1.meaning||')',NULL), sua.version_number, sua.uoo_id, sua.cal_type, sua.ci_sequence_number, sua.location_cd, sua.course_cd, sua.ci_start_dt, sua.ci_end_dt, sua.enrolled_dt, sua.administrative_unit_status, sua.discontinued_dt, sua.rule_waived_dt, sua.rule_waived_person_id, sua.no_assessment_ind, sua.sup_unit_cd, sua.sup_version_number, sua.exam_location_cd, sua.override_eftsu, sua.override_achievable_cp, sua.override_outcome_due_dt, sua.override_credit_reason, sua.administrative_priority, sua.waitlist_dt, sua.dcnt_reason_cd, sua.created_by, sua.creation_date, sua.last_updated_by, sua.last_update_date, sua.last_update_login, sua.request_id, sua.program_application_id, sua.program_id, sua.program_update_date, sua.cart, sua.org_unit_cd, sua.rsv_seat_ext_id, sua.gs_version_number, sua.enr_method_type, sua.failed_unit_rule, sua.grading_schema_code, sua.override_enrolled_cp, sua.alternative_title, sua.subtitle, igs_en_gen_008.enrp_val_chg_grd_sch_wrapper(sua.uoo_id,sua.cal_type,sua.ci_sequence_number), decode(sua.no_assessment_ind,'Y','N', igs_en_gen_008.enrp_val_chg_cp(sua.person_id, sua.uoo_id, sua.cal_type, sua.ci_sequence_number)), igs_ss_enr_details.get_grading_schema(sua.person_id,sua.uoo_id,sua.unit_cd,sua.version_number,sua.course_cd)||'-'|| TO_CHAR(igs_ss_enr_details.get_grading_schema_ver(sua.person_id,sua.uoo_id,sua.unit_cd,sua.version_number,sua.course_cd)), igs_ss_enr_details.get_usec_eff_dates(sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number, sua.location_cd,sua.unit_class), igs_ss_enr_details.enrp_val_subttl_chg(sua.person_id,sua.uoo_id), igs_ss_enr_details.get_title(sua.person_id, sua.uoo_id, sua.unit_cd,sua.version_number,sua.course_cd), igs_ss_enr_details.get_subtitle(sua.person_id,sua.uoo_id,sua.unit_cd,sua.version_number,sua.course_cd), flv.meaning, igs_ss_enr_details.get_lead_instructor_name(sua.uoo_id), sua.SESSION_ID , sua.DEG_AUD_DETAIL_ID , sua.STUDENT_CAREER_TRANSCRIPT, sua.STUDENT_CAREER_STATISTICS, sua.WAITLIST_MANUAL_IND , 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, uv.PRACTICAL_IND, uoo.RELATION_TYPE, uoo.SUP_UOO_ID, IGS_SS_ENR_DETAILS.GET_SUP_SUB_DETAILS(UOO.UOO_ID,UOO.SUP_UOO_ID,UOO.RELATION_TYPE), uoo.DEFAULT_ENROLL_FLAG, IGS_SS_ENR_DETAILS.GET_ENROLLMENT_CAPACITY(SUA.UOO_ID) ENROLL_CAPACITY, IGS_SS_ENR_DETAILS.GET_WAITLIST_CAPACITY(SUA.UOO_ID , SUA.UNIT_CD , SUA.VERSION_NUMBER , SUA.CAL_TYPE , SUA.CI_SEQUENCE_NUMBER,SUA.ORG_UNIT_CD) WAITLIST_CAPACITY, IGS_SS_ENR_DETAILS.IS_UNIT_RULE_DEFINED(SUA.UOO_ID,'PREREQ') PREREQ_FLAG, IGS_SS_ENR_DETAILS.IS_UNIT_RULE_DEFINED(SUA.UOO_ID,'COREQ') COREQ_FLAG, NULL AUDIT_ALLOWED, IGS_SS_ENR_DETAILS.GET_CREDIT_POINTS(SUA.PERSON_ID,UOO.UOO_ID,UOO.UNIT_CD, UOO.VERSION_NUMBER,SUA.COURSE_CD) TOTAL_CREDIT_POINTS, IGS_SS_ENR_DETAILS. get_billable_credit_points (SUA.UOO_ID) BILLABLE_CREDITS, IGS_SS_ENR_DETAILS.GET_SPECIAL_AUDIT_STATUS(SUA.UOO_ID) SPECIAL_AUDIT_FLAG, IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA(SUA.PERSON_ID,SUA.UOO_ID,SUA.UNIT_CD, SUA.VERSION_NUMBER,SUA.COURSE_CD)|| ',' || IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA_VER(SUA.PERSON_ID, SUA.UOO_ID,SUA.UNIT_CD,SUA.VERSION_NUMBER,SUA.COURSE_CD) GRADING_SCHEMA_CODE_VER, SUA.UPD_AUDIT_FLAG, SUA.SS_SOURCE_IND ss_source_indicator FROM igs_en_su_attempt sua, igs_ps_unit_ofr_opt uoo, igs_ps_unit_ver uv, igs_lookup_values flv, igs_ca_inst ci, igs_lookup_values lkp1 WHERE sua.uoo_id = uoo.uoo_id AND flv.lookup_type = 'UNIT_ATTEMPT_STATUS' AND flv.lookup_code = sua.unit_attempt_status AND ci.cal_type = sua.cal_type AND ci.sequence_number = sua.ci_sequence_number AND lkp1.lookup_type ='LEGACY_TOKENS' AND lkp1.lookup_code='AUDIT' AND uv.unit_cd = uoo.unit_cd AND uv.version_number = uoo.version_number

View Text - HTML Formatted

SELECT SUA.ROW_ID
, SUA.PERSON_ID
, SUA.UNIT_CD
, SUA.UNIT_CLASS
, UOO.CALL_NUMBER
, UOO.UNIT_SECTION_STATUS
, IGS_SS_ENR_DETAILS.GET_TITLE_SECTION(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)
, CI.DESCRIPTION SEMESTER
, IGS_SS_ENR_DETAILS.GET_OCCUR_CD_DETAILS(SUA.UOO_ID) MEETINGPATTERN
, IGS_SS_ENR_DETAILS.GET_CREDIT_POINTS(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)
, IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)
, SUA.UNIT_ATTEMPT_STATUS
, FLV.MEANING||DECODE(SUA.UNIT_ATTEMPT_STATUS
, 'WAITLISTED'
, '('||SUA.ADMINISTRATIVE_PRIORITY||')'
, NULL)||DECODE(NO_ASSESSMENT_IND
, 'Y'
, '('||LKP1.MEANING||')'
, NULL)
, FLV.MEANING||DECODE(SUA.UNIT_ATTEMPT_STATUS
, 'WAITLISTED'
, '('||SUA.ADMINISTRATIVE_PRIORITY||'/'||UOO.WAITLIST_ACTUAL||')'
, NULL)||DECODE(NO_ASSESSMENT_IND
, 'Y'
, '('||LKP1.MEANING||')'
, NULL)
, SUA.VERSION_NUMBER
, SUA.UOO_ID
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.LOCATION_CD
, SUA.COURSE_CD
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUA.ENROLLED_DT
, SUA.ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT
, SUA.RULE_WAIVED_DT
, SUA.RULE_WAIVED_PERSON_ID
, SUA.NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD
, SUA.OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON
, SUA.ADMINISTRATIVE_PRIORITY
, SUA.WAITLIST_DT
, SUA.DCNT_REASON_CD
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN
, SUA.REQUEST_ID
, SUA.PROGRAM_APPLICATION_ID
, SUA.PROGRAM_ID
, SUA.PROGRAM_UPDATE_DATE
, SUA.CART
, SUA.ORG_UNIT_CD
, SUA.RSV_SEAT_EXT_ID
, SUA.GS_VERSION_NUMBER
, SUA.ENR_METHOD_TYPE
, SUA.FAILED_UNIT_RULE
, SUA.GRADING_SCHEMA_CODE
, SUA.OVERRIDE_ENROLLED_CP
, SUA.ALTERNATIVE_TITLE
, SUA.SUBTITLE
, IGS_EN_GEN_008.ENRP_VAL_CHG_GRD_SCH_WRAPPER(SUA.UOO_ID
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, DECODE(SUA.NO_ASSESSMENT_IND
, 'Y'
, 'N'
, IGS_EN_GEN_008.ENRP_VAL_CHG_CP(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER))
, IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)||'-'|| TO_CHAR(IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA_VER(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD))
, IGS_SS_ENR_DETAILS.GET_USEC_EFF_DATES(SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.LOCATION_CD
, SUA.UNIT_CLASS)
, IGS_SS_ENR_DETAILS.ENRP_VAL_SUBTTL_CHG(SUA.PERSON_ID
, SUA.UOO_ID)
, IGS_SS_ENR_DETAILS.GET_TITLE(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)
, IGS_SS_ENR_DETAILS.GET_SUBTITLE(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)
, FLV.MEANING
, IGS_SS_ENR_DETAILS.GET_LEAD_INSTRUCTOR_NAME(SUA.UOO_ID)
, SUA.SESSION_ID
, SUA.DEG_AUD_DETAIL_ID
, SUA.STUDENT_CAREER_TRANSCRIPT
, SUA.STUDENT_CAREER_STATISTICS
, SUA.WAITLIST_MANUAL_IND
, 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
, UV.PRACTICAL_IND
, UOO.RELATION_TYPE
, UOO.SUP_UOO_ID
, IGS_SS_ENR_DETAILS.GET_SUP_SUB_DETAILS(UOO.UOO_ID
, UOO.SUP_UOO_ID
, UOO.RELATION_TYPE)
, UOO.DEFAULT_ENROLL_FLAG
, IGS_SS_ENR_DETAILS.GET_ENROLLMENT_CAPACITY(SUA.UOO_ID) ENROLL_CAPACITY
, IGS_SS_ENR_DETAILS.GET_WAITLIST_CAPACITY(SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.ORG_UNIT_CD) WAITLIST_CAPACITY
, IGS_SS_ENR_DETAILS.IS_UNIT_RULE_DEFINED(SUA.UOO_ID
, 'PREREQ') PREREQ_FLAG
, IGS_SS_ENR_DETAILS.IS_UNIT_RULE_DEFINED(SUA.UOO_ID
, 'COREQ') COREQ_FLAG
, NULL AUDIT_ALLOWED
, IGS_SS_ENR_DETAILS.GET_CREDIT_POINTS(SUA.PERSON_ID
, UOO.UOO_ID
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, SUA.COURSE_CD) TOTAL_CREDIT_POINTS
, IGS_SS_ENR_DETAILS. GET_BILLABLE_CREDIT_POINTS (SUA.UOO_ID) BILLABLE_CREDITS
, IGS_SS_ENR_DETAILS.GET_SPECIAL_AUDIT_STATUS(SUA.UOO_ID) SPECIAL_AUDIT_FLAG
, IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD)|| '
, ' || IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA_VER(SUA.PERSON_ID
, SUA.UOO_ID
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.COURSE_CD) GRADING_SCHEMA_CODE_VER
, SUA.UPD_AUDIT_FLAG
, SUA.SS_SOURCE_IND SS_SOURCE_INDICATOR
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_VER UV
, IGS_LOOKUP_VALUES FLV
, IGS_CA_INST CI
, IGS_LOOKUP_VALUES LKP1
WHERE SUA.UOO_ID = UOO.UOO_ID
AND FLV.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'
AND FLV.LOOKUP_CODE = SUA.UNIT_ATTEMPT_STATUS
AND CI.CAL_TYPE = SUA.CAL_TYPE
AND CI.SEQUENCE_NUMBER = SUA.CI_SEQUENCE_NUMBER
AND LKP1.LOOKUP_TYPE ='LEGACY_TOKENS'
AND LKP1.LOOKUP_CODE='AUDIT'
AND UV.UNIT_CD = UOO.UNIT_CD
AND UV.VERSION_NUMBER = UOO.VERSION_NUMBER