VIEW: APPS.IGS_PS_USEC_WLST_PRF_V

Source

View Text - Preformatted

SELECT uswpr.rowid row_id, uswpr.unit_sec_waitlist_pref_id unit_sec_waitlist_pref_id, uswpr.unit_sec_waitlist_priority_id unit_sec_waitlist_priority_id, uswpr.preference_order preference_order, uswpr.preference_code preference_code, uswpr.preference_version preference_version, ou.party_name description, uswpr.created_by created_by, uswpr.creation_date creation_date, uswpr.last_updated_by last_updated_by, uswpr.last_update_date last_update_date, uswpr.last_update_login last_update_login FROM igs_ps_usec_wlst_prf uswpr, igs_or_inst_org_base_v ou, igs_ps_usec_wlst_pri uswp WHERE ou.party_number = uswpr.preference_code AND uswp.unit_sec_waitlist_priority_id = uswpr.unit_sec_waitlist_priority_id UNION SELECT uswpr.rowid row_id, uswpr.unit_sec_waitlist_pref_id unit_sec_waitlist_pref_id, uswpr.unit_sec_waitlist_priority_id unit_sec_waitlist_priority_id, uswpr.preference_order preference_order, uswpr.preference_code preference_code, uswpr.preference_version preference_version, uv.title description, uswpr.created_by created_by, uswpr.creation_date creation_date, uswpr.last_updated_by last_updated_by, uswpr.last_update_date last_update_date, uswpr.last_update_login last_update_login FROM igs_ps_usec_wlst_prf uswpr, igs_ps_ver uv, igs_ps_usec_wlst_pri uswp WHERE uv.course_cd = uswpr.preference_code AND uv.version_number = uswpr.preference_version AND uswp.unit_sec_waitlist_priority_id = uswpr.unit_sec_waitlist_priority_id UNION SELECT uswpr.rowid row_id, uswpr.unit_sec_waitlist_pref_id unit_sec_waitlist_pref_id, uswpr.unit_sec_waitlist_priority_id unit_sec_waitlist_priority_id, uswpr.preference_order preference_order, uswpr.preference_code preference_code, uswpr.preference_version preference_version, us.title description, uswpr.created_by created_by, uswpr.creation_date creation_date, uswpr.last_updated_by last_updated_by, uswpr.last_update_date last_update_date, uswpr.last_update_login last_update_login FROM igs_ps_usec_wlst_prf uswpr, igs_en_unit_set us, igs_ps_usec_wlst_pri uswp WHERE us.unit_set_cd = uswpr.preference_code AND us.version_number = uswpr.preference_version AND uswp.unit_sec_waitlist_priority_id = uswpr.unit_sec_waitlist_priority_id UNION SELECT uswpr.rowid row_id, uswpr.unit_sec_waitlist_pref_id unit_sec_waitlist_pref_id, uswpr.unit_sec_waitlist_priority_id unit_sec_waitlist_priority_id, uswpr.preference_order preference_order, uswpr.preference_code preference_code, uswpr.preference_version preference_version, cs.description description, uswpr.created_by created_by, uswpr.creation_date creation_date, uswpr.last_updated_by last_updated_by, uswpr.last_update_date last_update_date, uswpr.last_update_login last_update_login FROM igs_ps_usec_wlst_prf uswpr, igs_ps_stage_type cs, igs_ps_usec_wlst_pri uswp WHERE cs.course_stage_type = uswpr.preference_code AND uswp.unit_sec_waitlist_priority_id = uswpr.unit_sec_waitlist_priority_id

View Text - HTML Formatted

SELECT USWPR.ROWID ROW_ID
, USWPR.UNIT_SEC_WAITLIST_PREF_ID UNIT_SEC_WAITLIST_PREF_ID
, USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNIT_SEC_WAITLIST_PRIORITY_ID
, USWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, USWPR.PREFERENCE_CODE PREFERENCE_CODE
, USWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, OU.PARTY_NAME DESCRIPTION
, USWPR.CREATED_BY CREATED_BY
, USWPR.CREATION_DATE CREATION_DATE
, USWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, USWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_WLST_PRF USWPR
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PS_USEC_WLST_PRI USWP
WHERE OU.PARTY_NUMBER = USWPR.PREFERENCE_CODE
AND USWP.UNIT_SEC_WAITLIST_PRIORITY_ID = USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNION SELECT USWPR.ROWID ROW_ID
, USWPR.UNIT_SEC_WAITLIST_PREF_ID UNIT_SEC_WAITLIST_PREF_ID
, USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNIT_SEC_WAITLIST_PRIORITY_ID
, USWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, USWPR.PREFERENCE_CODE PREFERENCE_CODE
, USWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, UV.TITLE DESCRIPTION
, USWPR.CREATED_BY CREATED_BY
, USWPR.CREATION_DATE CREATION_DATE
, USWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, USWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_WLST_PRF USWPR
, IGS_PS_VER UV
, IGS_PS_USEC_WLST_PRI USWP
WHERE UV.COURSE_CD = USWPR.PREFERENCE_CODE
AND UV.VERSION_NUMBER = USWPR.PREFERENCE_VERSION
AND USWP.UNIT_SEC_WAITLIST_PRIORITY_ID = USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNION SELECT USWPR.ROWID ROW_ID
, USWPR.UNIT_SEC_WAITLIST_PREF_ID UNIT_SEC_WAITLIST_PREF_ID
, USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNIT_SEC_WAITLIST_PRIORITY_ID
, USWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, USWPR.PREFERENCE_CODE PREFERENCE_CODE
, USWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, US.TITLE DESCRIPTION
, USWPR.CREATED_BY CREATED_BY
, USWPR.CREATION_DATE CREATION_DATE
, USWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, USWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_WLST_PRF USWPR
, IGS_EN_UNIT_SET US
, IGS_PS_USEC_WLST_PRI USWP
WHERE US.UNIT_SET_CD = USWPR.PREFERENCE_CODE
AND US.VERSION_NUMBER = USWPR.PREFERENCE_VERSION
AND USWP.UNIT_SEC_WAITLIST_PRIORITY_ID = USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNION SELECT USWPR.ROWID ROW_ID
, USWPR.UNIT_SEC_WAITLIST_PREF_ID UNIT_SEC_WAITLIST_PREF_ID
, USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID UNIT_SEC_WAITLIST_PRIORITY_ID
, USWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, USWPR.PREFERENCE_CODE PREFERENCE_CODE
, USWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, CS.DESCRIPTION DESCRIPTION
, USWPR.CREATED_BY CREATED_BY
, USWPR.CREATION_DATE CREATION_DATE
, USWPR.LAST_UPDATED_BY LAST_UPDATED_BY
, USWPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USWPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_WLST_PRF USWPR
, IGS_PS_STAGE_TYPE CS
, IGS_PS_USEC_WLST_PRI USWP
WHERE CS.COURSE_STAGE_TYPE = USWPR.PREFERENCE_CODE
AND USWP.UNIT_SEC_WAITLIST_PRIORITY_ID = USWPR.UNIT_SEC_WAITLIST_PRIORITY_ID