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