VIEW: APPS.IGS_SS_EN_ENROLL_CART_RSLT_V

Source

View Text - Preformatted

SELECT b.unit_cd, b.cal_type, b.ci_sequence_number, b.version_number, b.unit_status, b.title_override_ind, b.abbreviation, b.title, b.short_title, b.uoo_id, b.call_number, b.unit_section_status, b.unit_class, b.location_cd, b.start_date, b.end_date, b.cal_type||'
'||b.start_date||'
'||b.end_date semester, c.subtitle, c.subtitle_modifiable_flag, b.enrollment_actual, b.enrollment_minimum, b.enrollment_maximum, b.teach_cal_description, DECODE(b.NON_STD_USEC_FLAG,'Y',b.UNIT_SECTION_START_DT, NVL(b.UNIT_SECTION_START_DT,b.start_date)) UNIT_SECTION_START_DT, DECODE(b.NON_STD_USEC_FLAG,'Y',b.UNIT_SECTION_END_DT, NVL(b.UNIT_SECTION_END_DT,b.end_date)) UNIT_SECTION_END_DT, e.description, b.org_unit_cd, igs_ss_enr_details.enrp_get_enr_max_act(b.uoo_id) enroll_max_act, NVL(TO_CHAR(b.max_students_per_waitlist),'-')||'('||NVL(TO_CHAR(b.waitlist_actual),'0')||')' waitlist_max_act, igs_ss_enr_details.get_title_section ( NULL, b.uoo_id, b.unit_cd, b.version_number, NULL ) Title_Subtitle, igs_ss_enr_details.get_credit_points ( NULL , b.uoo_id, b.unit_cd, b.version_number, NULL ) Credit_Points, igs_ss_enr_details.get_grading_schema ( NULL , b.uoo_id, b.unit_cd, b.version_number, NULL ) Grading_Schema, igs_ss_enr_details.get_occur_desc_details(b.uoo_id) occur_location_desc, igs_ss_enr_details.get_occur_cd_details(b.uoo_id) occur_location_code, igs_ss_enr_details.get_occur_details_no_location(b.uoo_id) occur_no_location , b.SS_DISPLAY_IND, b.SS_ENROL_IND, b.auditable_ind, igs_ss_enr_details.enrp_chk_usec_group (b.uoo_id) usec_part_of_group, B.SUP_UOO_ID, B.RELATION_TYPE, IGS_SS_ENR_DETAILS.GET_SUP_SUB_DETAILS(B.UOO_ID,B.SUP_UOO_ID,B.RELATION_TYPE), B.PRACTICAL_IND FROM igs_ss_usec_v b, igs_ps_usec_ref c, igs_ps_usec_grd_schm d, igs_ad_location e WHERE b.uoo_id = c.uoo_id(+) AND b.uoo_id = d.uoo_id(+) AND e.location_cd = b.location_cd AND d.default_flag(+) = 'Y'

View Text - HTML Formatted

SELECT B.UNIT_CD
, B.CAL_TYPE
, B.CI_SEQUENCE_NUMBER
, B.VERSION_NUMBER
, B.UNIT_STATUS
, B.TITLE_OVERRIDE_IND
, B.ABBREVIATION
, B.TITLE
, B.SHORT_TITLE
, B.UOO_ID
, B.CALL_NUMBER
, B.UNIT_SECTION_STATUS
, B.UNIT_CLASS
, B.LOCATION_CD
, B.START_DATE
, B.END_DATE
, B.CAL_TYPE||'
'||B.START_DATE||'
'||B.END_DATE SEMESTER
, C.SUBTITLE
, C.SUBTITLE_MODIFIABLE_FLAG
, B.ENROLLMENT_ACTUAL
, B.ENROLLMENT_MINIMUM
, B.ENROLLMENT_MAXIMUM
, B.TEACH_CAL_DESCRIPTION
, DECODE(B.NON_STD_USEC_FLAG
, 'Y'
, B.UNIT_SECTION_START_DT
, NVL(B.UNIT_SECTION_START_DT
, B.START_DATE)) UNIT_SECTION_START_DT
, DECODE(B.NON_STD_USEC_FLAG
, 'Y'
, B.UNIT_SECTION_END_DT
, NVL(B.UNIT_SECTION_END_DT
, B.END_DATE)) UNIT_SECTION_END_DT
, E.DESCRIPTION
, B.ORG_UNIT_CD
, IGS_SS_ENR_DETAILS.ENRP_GET_ENR_MAX_ACT(B.UOO_ID) ENROLL_MAX_ACT
, NVL(TO_CHAR(B.MAX_STUDENTS_PER_WAITLIST)
, '-')||'('||NVL(TO_CHAR(B.WAITLIST_ACTUAL)
, '0')||')' WAITLIST_MAX_ACT
, IGS_SS_ENR_DETAILS.GET_TITLE_SECTION ( NULL
, B.UOO_ID
, B.UNIT_CD
, B.VERSION_NUMBER
, NULL ) TITLE_SUBTITLE
, IGS_SS_ENR_DETAILS.GET_CREDIT_POINTS ( NULL
, B.UOO_ID
, B.UNIT_CD
, B.VERSION_NUMBER
, NULL ) CREDIT_POINTS
, IGS_SS_ENR_DETAILS.GET_GRADING_SCHEMA ( NULL
, B.UOO_ID
, B.UNIT_CD
, B.VERSION_NUMBER
, NULL ) GRADING_SCHEMA
, IGS_SS_ENR_DETAILS.GET_OCCUR_DESC_DETAILS(B.UOO_ID) OCCUR_LOCATION_DESC
, IGS_SS_ENR_DETAILS.GET_OCCUR_CD_DETAILS(B.UOO_ID) OCCUR_LOCATION_CODE
, IGS_SS_ENR_DETAILS.GET_OCCUR_DETAILS_NO_LOCATION(B.UOO_ID) OCCUR_NO_LOCATION
, B.SS_DISPLAY_IND
, B.SS_ENROL_IND
, B.AUDITABLE_IND
, IGS_SS_ENR_DETAILS.ENRP_CHK_USEC_GROUP (B.UOO_ID) USEC_PART_OF_GROUP
, B.SUP_UOO_ID
, B.RELATION_TYPE
, IGS_SS_ENR_DETAILS.GET_SUP_SUB_DETAILS(B.UOO_ID
, B.SUP_UOO_ID
, B.RELATION_TYPE)
, B.PRACTICAL_IND
FROM IGS_SS_USEC_V B
, IGS_PS_USEC_REF C
, IGS_PS_USEC_GRD_SCHM D
, IGS_AD_LOCATION E
WHERE B.UOO_ID = C.UOO_ID(+)
AND B.UOO_ID = D.UOO_ID(+)
AND E.LOCATION_CD = B.LOCATION_CD
AND D.DEFAULT_FLAG(+) = 'Y'