VIEW: APPS.IGS_PS_UOFR_WLST_PRF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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