Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains the statistic details of unit section. |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOO.ROWID
, UOO.UOO_ID
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UV.UNIT_STATUS
, UV.TITLE TITLE
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, UOO.UNIT_CLASS
, UC.UNIT_MODE
, UOO.LOCATION_CD
, LOC.DESCRIPTION
, UOO.OWNER_ORG_UNIT_CD
, OU.DESCRIPTION
, NVL(UELM.ENROLLMENT_MAXIMUM
, UV.ENROLLMENT_MAXIMUM)
, UOO.WAITLIST_ACTUAL
, IGS_AU_GEN_003.AUDP_GET_ENRS_STAT('SEATS_RESERVED'
, UOO.UOO_ID )
, UOO.DIR_ENROLLMENT
, UOO.ENR_FROM_WLST
, UOO.INQ_NOT_WLST
, IGS_AU_GEN_003.AUDP_GET_ENRS_STAT('DROPPED'
, UOO.UOO_ID )
, IGS_AU_GEN_003.AUDP_GET_ENRS_STAT('DISCONTINUED'
, UOO.UOO_ID )
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN
, UOO.REQUEST_ID REQUEST_ID
, UOO.PROGRAM_APPLICATION_ID
, UOO.PROGRAM_ID PROGRAM_ID
, UOO.PROGRAM_UPDATE_DATE
FROM IGS_PS_UNIT_OFR_OPT_SV UOO
, IGS_PS_UNIT_VER UV
, IGS_CA_INST CI
, IGS_AD_LOCATION LOC
, IGS_AS_UNIT_CLASS UC
, IGS_PS_USEC_LIM_WLST UELM
, IGS_OR_UNIT OU
WHERE UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND OU.ORG_UNIT_CD = UOO.OWNER_ORG_UNIT_CD
AND UELM.UOO_ID(+) = UOO.UOO_ID