VIEW: APPS.IGS_EN_OR_UNIT_WLST_PRF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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