View: IGS_EN_OR_UNIT_WLST_PRF_V

Product:	IGS - Student System
Description:	This view holds the wait list preferences associated to each wait list priority.
Implementation/DBA Data:	APPS.IGS_EN_OR_UNIT_WLST_PRF_V

View Text

SELECT UWPR.ROWID ROW_ID
, UWPR.ORG_UNIT_WLST_PRF_ID ORG_UNIT_WLST_PRF_ID
, UWPR.ORG_UNIT_WLST_PRI_ID ORG_UNIT_WLST_PRI_ID
, UWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, UWPR.PREFERENCE_CODE PREFERENCE_CODE
, UWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, OU.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_EN_ORUN_WLST_PRF UWPR
, IGS_OR_UNIT OU
, IGS_EN_ORUN_WLST_PRI UWP
WHERE OU.ORG_UNIT_CD = UWPR.PREFERENCE_CODE
AND UWP.ORG_UNIT_WLST_PRI_ID = UWPR.ORG_UNIT_WLST_PRI_ID UNION SELECT UWPR.ROWID ROW_ID
, UWPR.ORG_UNIT_WLST_PRF_ID ORG_UNIT_WLST_PRF_ID
, UWPR.ORG_UNIT_WLST_PRI_ID ORG_UNIT_WLST_PRI_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_EN_ORUN_WLST_PRF UWPR
, IGS_PS_VER UV
, IGS_EN_ORUN_WLST_PRI UWP
WHERE UV.COURSE_CD = UWPR.PREFERENCE_CODE
AND UV.VERSION_NUMBER = UWPR.PREFERENCE_VERSION
AND UWP.ORG_UNIT_WLST_PRI_ID = UWPR.ORG_UNIT_WLST_PRI_ID UNION SELECT UWPR.ROWID ROW_ID
, UWPR.ORG_UNIT_WLST_PRF_ID ORG_UNIT_WLST_PRF_ID
, UWPR.ORG_UNIT_WLST_PRI_ID ORG_UNIT_WLST_PRI_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_EN_ORUN_WLST_PRF UWPR
, IGS_EN_UNIT_SET US
, IGS_EN_ORUN_WLST_PRI UWP
WHERE US.UNIT_SET_CD = UWPR.PREFERENCE_CODE
AND UWP.ORG_UNIT_WLST_PRI_ID = UWPR.ORG_UNIT_WLST_PRI_ID UNION SELECT UWPR.ROWID ROW_ID
, UWPR.ORG_UNIT_WLST_PRF_ID ORG_UNIT_WLST_PRF_ID
, UWPR.ORG_UNIT_WLST_PRI_ID ORG_UNIT_WLST_PRI_ID
, UWPR.PREFERENCE_ORDER PREFERENCE_ORDER
, UWPR.PREFERENCE_CODE PREFERENCE_CODE
, UWPR.PREFERENCE_VERSION PREFERENCE_VERSION
, CT.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_EN_ORUN_WLST_PRF UWPR
, IGS_PS_STAGE_TYPE CT
, IGS_EN_ORUN_WLST_PRI UWP
WHERE CT.COURSE_STAGE_TYPE = UWPR.PREFERENCE_CODE
AND UWP.ORG_UNIT_WLST_PRI_ID = UWPR.ORG_UNIT_WLST_PRI_ID

Columns