VIEW: APPS.IGS_SS_USEC_V

Source

View Text - Preformatted

SELECT a.unit_cd , a.version_number , a.unit_status , a.title , a.short_title , a.title_override_ind, a.abbreviation , a.owner_org_unit_cd, b.uoo_id, b.cal_type , b.ci_sequence_number , b.call_number, b.unit_section_status, b.unit_class, b.location_cd, b.enrollment_actual, b.waitlist_actual, b.unit_section_start_date, b.unit_section_end_date, to_char(c.start_dt,'DD-MON-YYYY') start_date, to_char(c.end_dt,'DD-MON-YYYY') end_date, c.description teach_cal_description , nvl(d.enrollment_minimum,a.enrollment_minimum), nvl(d.enrollment_maximum,a.enrollment_maximum), nvl( d.max_students_per_waitlist,NVL(e.max_students_per_waitlist,igs_ss_enr_details.get_max_std_wait_org_level(a.owner_org_unit_cd,b.cal_type,b.ci_sequence_number))) max_students_per_waitlist, b.SS_DISPLAY_IND, b.SS_ENROL_IND, b.auditable_ind, b.sup_uoo_id, b.relation_type, a.practical_ind, b.non_std_usec_ind NON_STD_USEC_FLAG from igs_ps_unit_ver a , igs_ps_unit_ofr_opt b, igs_ca_inst c, igs_ps_usec_lim_wlst d , igs_ps_unit_ofr_pat e WHERE b.unit_cd = a.unit_cd and b.version_number = a.version_number and b.cal_type = c.cal_type and b.ci_sequence_number = c.sequence_number and d.uoo_id(+) = b.uoo_id AND b.unit_cd = e.unit_cd AND b.version_number = e.version_number AND b.cal_type = e.cal_type AND b.ci_sequence_number = e.ci_sequence_number AND e.delete_flag = 'N'

View Text - HTML Formatted

SELECT A.UNIT_CD
, A.VERSION_NUMBER
, A.UNIT_STATUS
, A.TITLE
, A.SHORT_TITLE
, A.TITLE_OVERRIDE_IND
, A.ABBREVIATION
, A.OWNER_ORG_UNIT_CD
, B.UOO_ID
, B.CAL_TYPE
, B.CI_SEQUENCE_NUMBER
, B.CALL_NUMBER
, B.UNIT_SECTION_STATUS
, B.UNIT_CLASS
, B.LOCATION_CD
, B.ENROLLMENT_ACTUAL
, B.WAITLIST_ACTUAL
, B.UNIT_SECTION_START_DATE
, B.UNIT_SECTION_END_DATE
, TO_CHAR(C.START_DT
, 'DD-MON-YYYY') START_DATE
, TO_CHAR(C.END_DT
, 'DD-MON-YYYY') END_DATE
, C.DESCRIPTION TEACH_CAL_DESCRIPTION
, NVL(D.ENROLLMENT_MINIMUM
, A.ENROLLMENT_MINIMUM)
, NVL(D.ENROLLMENT_MAXIMUM
, A.ENROLLMENT_MAXIMUM)
, NVL( D.MAX_STUDENTS_PER_WAITLIST
, NVL(E.MAX_STUDENTS_PER_WAITLIST
, IGS_SS_ENR_DETAILS.GET_MAX_STD_WAIT_ORG_LEVEL(A.OWNER_ORG_UNIT_CD
, B.CAL_TYPE
, B.CI_SEQUENCE_NUMBER))) MAX_STUDENTS_PER_WAITLIST
, B.SS_DISPLAY_IND
, B.SS_ENROL_IND
, B.AUDITABLE_IND
, B.SUP_UOO_ID
, B.RELATION_TYPE
, A.PRACTICAL_IND
, B.NON_STD_USEC_IND NON_STD_USEC_FLAG
FROM IGS_PS_UNIT_VER A
, IGS_PS_UNIT_OFR_OPT B
, IGS_CA_INST C
, IGS_PS_USEC_LIM_WLST D
, IGS_PS_UNIT_OFR_PAT E
WHERE B.UNIT_CD = A.UNIT_CD
AND B.VERSION_NUMBER = A.VERSION_NUMBER
AND B.CAL_TYPE = C.CAL_TYPE
AND B.CI_SEQUENCE_NUMBER = C.SEQUENCE_NUMBER
AND D.UOO_ID(+) = B.UOO_ID
AND B.UNIT_CD = E.UNIT_CD
AND B.VERSION_NUMBER = E.VERSION_NUMBER
AND B.CAL_TYPE = E.CAL_TYPE
AND B.CI_SEQUENCE_NUMBER = E.CI_SEQUENCE_NUMBER
AND E.DELETE_FLAG = 'N'