[Home] [Help]
View: IGS_EN_OR_UNIT_WLST_PRF_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | This view holds the wait list preferences associated to each wait list priority. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
| Name |
| ROW_ID |
| ORG_UNIT_WLST_PRF_ID |
| ORG_UNIT_WLST_PRI_ID |
| PREFERENCE_ORDER |
| PREFERENCE_CODE |
| PREFERENCE_VERSION |
| DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |