VIEW: APPS.IGS_EN_USEC_STAT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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