Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Case and Seed document: PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT UWPR.ROWID ROW_ID
, UWPR.UNIT_OFR_WAITLIST_PREF_ID UNIT_OFR_WAITLIST_PREF_ID
, UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNIT_OFR_WAITLIST_PRIORITY_ID
, UWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, UWPR.PREFERENCE_CODE PREFERENCE_CODE
, UWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, OU.PARTY_NAME DESCRIPTION
, UWPR.CREATED_BY CREATED_BY
, UWPR.CREATION_DATE CREATION_DATE
, UWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, UWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UOFR_WLST_PRF UWPR
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PS_UOFR_WLST_PRI UWP
WHERE OU.PARTY_NUMBER = UWPR.PREFERENCE_CODE
AND UWP.UNIT_OFR_WAITLIST_PRIORITY_ID = UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNION SELECT UWPR.ROWID
, UWPR.UNIT_OFR_WAITLIST_PREF_ID UNIT_OFR_WAITLIST_PREF_ID
, UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNIT_OFR_WAITLIST_PRIORITY_ID
, UWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, UWPR.PREFERENCE_CODE PREFERENCE_CODE
, UWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, UV.TITLE DESCRIPTION
, UWPR.CREATED_BY CREATED_BY
, UWPR.CREATION_DATE CREATION_DATE
, UWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, UWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UOFR_WLST_PRF UWPR
, IGS_PS_VER UV
, IGS_PS_UOFR_WLST_PRI UWP
WHERE UV.COURSE_CD = UWPR.PREFERENCE_CODE
AND UV.VERSION_NUMBER = UWPR.PREFERENCE_VERSION
AND UWP.UNIT_OFR_WAITLIST_PRIORITY_ID = UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNION SELECT UWPR.ROWID
, UWPR.UNIT_OFR_WAITLIST_PREF_ID UNIT_OFR_WAITLIST_PREF_ID
, UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNIT_OFR_WAITLIST_PRIORITY_ID
, UWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, UWPR.PREFERENCE_CODE PREFERENCE_CODE
, UWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, US.TITLE DESCRIPTION
, UWPR.CREATED_BY CREATED_BY
, UWPR.CREATION_DATE CREATION_DATE
, UWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, UWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UOFR_WLST_PRF UWPR
, IGS_EN_UNIT_SET US
, IGS_PS_UOFR_WLST_PRI UWP
WHERE US.UNIT_SET_CD = UWPR.PREFERENCE_CODE
AND US.VERSION_NUMBER = UWPR.PREFERENCE_VERSION
AND UWP.UNIT_OFR_WAITLIST_PRIORITY_ID = UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNION SELECT UWPR.ROWID
, UWPR.UNIT_OFR_WAITLIST_PREF_ID UNIT_OFR_WAITLIST_PREF_ID
, UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID UNIT_OFR_WAITLIST_PRIORITY_ID
, UWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, UWPR.PREFERENCE_CODE PREFERENCE_CODE
, UWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, CS.DESCRIPTION DESCRIPTION
, UWPR.CREATED_BY CREATED_BY
, UWPR.CREATION_DATE CREATION_DATE
, UWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, UWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UOFR_WLST_PRF UWPR
, IGS_PS_STAGE CS
, IGS_PS_UOFR_WLST_PRI UWP
WHERE CS.COURSE_STAGE_TYPE = UWPR.PREFERENCE_CODE
AND UWP.UNIT_OFR_WAITLIST_PRIORITY_ID = UWPR.UNIT_OFR_WAITLIST_PRIORITY_ID