Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view contains the preferences for a given priority for the reserved seating at Unit Section Level .Case and Seed document: PS201_Enhancments_Nov03_PS_3045069_CS_DP2.doc - Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT USPF.ROWID
, USPF.RSV_USEC_PRF_ID
, USPF.RSV_USEC_PRI_ID
, USPF.PREFERENCE_ORDER
, USPF.PREFERENCE_CODE
, USPF.PREFERENCE_VERSION
, OU.PARTY_NAME DESCRIPTION
, USPF.PERCENTAGE_RESERVED
, USPF.GROUP_ID
, USPF.CREATED_BY
, USPF.CREATION_DATE
, USPF.LAST_UPDATED_BY
, USPF.LAST_UPDATE_DATE
, USPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_USEC_PRF USPF
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PS_RSV_USEC_PRI USPR
WHERE OU.PARTY_NUMBER = USPF.PREFERENCE_CODE
AND USPF.RSV_USEC_PRI_ID = USPR.RSV_USEC_PRI_ID
AND USPR.PRIORITY_VALUE = 'ORG_UNIT' UNION SELECT USPF.ROWID
, USPF.RSV_USEC_PRF_ID
, USPF.RSV_USEC_PRI_ID
, USPF.PREFERENCE_ORDER
, USPF.PREFERENCE_CODE
, USPF.PREFERENCE_VERSION
, PV.TITLE
, USPF.PERCENTAGE_RESERVED
, USPF.GROUP_ID
, USPF.CREATED_BY
, USPF.CREATION_DATE
, USPF.LAST_UPDATED_BY
, USPF.LAST_UPDATE_DATE
, USPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_USEC_PRF USPF
, IGS_PS_VER PV
, IGS_PS_RSV_USEC_PRI USPR
WHERE PV.COURSE_CD = USPF.PREFERENCE_CODE
AND PV.VERSION_NUMBER = USPF.PREFERENCE_VERSION
AND USPF.RSV_USEC_PRI_ID = USPR.RSV_USEC_PRI_ID
AND USPR.PRIORITY_VALUE = 'PROGRAM' UNION SELECT USPF.ROWID
, USPF.RSV_USEC_PRF_ID
, USPF.RSV_USEC_PRI_ID
, USPF.PREFERENCE_ORDER
, USPF.PREFERENCE_CODE
, USPF.PREFERENCE_VERSION
, PST.DESCRIPTION
, USPF.PERCENTAGE_RESERVED
, USPF.GROUP_ID
, USPF.CREATED_BY
, USPF.CREATION_DATE
, USPF.LAST_UPDATED_BY
, USPF.LAST_UPDATE_DATE
, USPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_USEC_PRF USPF
, IGS_PS_STAGE_TYPE PST
, IGS_PS_RSV_USEC_PRI USPR
WHERE PST.COURSE_STAGE_TYPE = USPF.PREFERENCE_CODE
AND USPF.RSV_USEC_PRI_ID = USPR.RSV_USEC_PRI_ID
AND USPR.PRIORITY_VALUE = 'PROGRAM_STAGE' UNION SELECT USPF.ROWID
, USPF.RSV_USEC_PRF_ID
, USPF.RSV_USEC_PRI_ID
, USPF.PREFERENCE_ORDER
, USPF.PREFERENCE_CODE
, USPF.PREFERENCE_VERSION
, EUS.TITLE
, USPF.PERCENTAGE_RESERVED
, USPF.GROUP_ID
, USPF.CREATED_BY
, USPF.CREATION_DATE
, USPF.LAST_UPDATED_BY
, USPF.LAST_UPDATE_DATE
, USPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_USEC_PRF USPF
, IGS_EN_UNIT_SET EUS
, IGS_PS_RSV_USEC_PRI USPR
WHERE EUS.UNIT_SET_CD= USPF.PREFERENCE_CODE
AND EUS.VERSION_NUMBER = USPF.PREFERENCE_VERSION
AND USPF.RSV_USEC_PRI_ID = USPR.RSV_USEC_PRI_ID
AND USPR.PRIORITY_VALUE = 'UNIT_SET' UNION SELECT USPF.ROWID
, USPF.RSV_USEC_PRF_ID
, USPF.RSV_USEC_PRI_ID
, USPF.PREFERENCE_ORDER
, USPF.PREFERENCE_CODE
, USPF.PREFERENCE_VERSION
, PPG.DESCRIPTION
, USPF.PERCENTAGE_RESERVED
, USPF.GROUP_ID
, USPF.CREATED_BY
, USPF.CREATION_DATE
, USPF.LAST_UPDATED_BY
, USPF.LAST_UPDATE_DATE
, USPF.LAST_UPDATE_LOGIN FROM IGS_PS_RSV_USEC_PRF USPF
, IGS_PE_PERSID_GROUP PPG
, IGS_PS_RSV_USEC_PRI USPR
WHERE PPG.GROUP_ID = USPF.GROUP_ID
AND USPF.RSV_USEC_PRI_ID = USPR.RSV_USEC_PRI_ID
AND USPR.PRIORITY_VALUE = 'PERSON_GRP'