View: IGS_SS_EN_ENROLL_CART_RSLT_V

View Text

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'

Columns