VIEW: APPS.IGS_PS_RSV_UOP_PRF_V

Source

View Text - Preformatted

SELECT rupf.rowid, rupf.rsv_uop_prf_id, rupf.rsv_uop_pri_id, rupf.preference_order, rupf.preference_code, rupf.preference_version, ou.party_name description, rupf.percentage_reserved, rupf.group_id, rupf.created_by, rupf.creation_date, rupf.last_updated_by, rupf.last_update_date, rupf.last_update_login FROM igs_ps_rsv_uop_prf rupf, igs_or_inst_org_base_v ou, igs_ps_rsv_uop_pri rupr WHERE ou.party_number = rupf.preference_code AND rupf.rsv_uop_pri_id = rupr.rsv_uop_pri_id AND rupr.priority_value = 'ORG_UNIT' UNION SELECT rupf.rowid, rupf.rsv_uop_prf_id, rupf.rsv_uop_pri_id, rupf.preference_order, rupf.preference_code, rupf.preference_version, pv.title, rupf.percentage_reserved, rupf.group_id, rupf.created_by, rupf.creation_date, rupf.last_updated_by, rupf.last_update_date, rupf.last_update_login FROM igs_ps_rsv_uop_prf rupf, igs_ps_ver pv, igs_ps_rsv_uop_pri rupr WHERE pv.course_cd = rupf.preference_code AND pv.version_number = rupf.preference_version AND rupf.rsv_uop_pri_id = rupr.rsv_uop_pri_id AND rupr.priority_value = 'PROGRAM' UNION SELECT rupf.rowid, rupf.rsv_uop_prf_id, rupf.rsv_uop_pri_id, rupf.preference_order, rupf.preference_code, rupf.preference_version, pst.description, rupf.percentage_reserved, rupf.group_id,rupf.created_by, rupf.creation_date, rupf.last_updated_by, rupf.last_update_date, rupf.last_update_login FROM igs_ps_rsv_uop_prf rupf, igs_ps_stage_type pst, igs_ps_rsv_uop_pri rupr WHERE pst.course_stage_type = rupf.preference_code AND rupf.rsv_uop_pri_id = rupr.rsv_uop_pri_id AND rupr.priority_value = 'PROGRAM_STAGE' UNION SELECT rupf.rowid, rupf.rsv_uop_prf_id, rupf.rsv_uop_pri_id, rupf.preference_order, rupf.preference_code, rupf.preference_version, eus.title, rupf.percentage_reserved, rupf.group_id, rupf.created_by, rupf.creation_date, rupf.last_updated_by, rupf.last_update_date, rupf.last_update_login FROM igs_ps_rsv_uop_prf rupf, igs_en_unit_set eus, igs_ps_rsv_uop_pri rupr WHERE eus.unit_set_cd= rupf.preference_code AND eus.version_number = rupf.preference_version AND rupf.rsv_uop_pri_id = rupr.rsv_uop_pri_id AND rupr.priority_value = 'UNIT_SET' UNION SELECT rupf.rowid, rupf.rsv_uop_prf_id, rupf.rsv_uop_pri_id, rupf.preference_order, rupf.preference_code, rupf.preference_version, ppg.description, rupf.percentage_reserved, rupf.group_id,rupf.created_by, rupf.creation_date, rupf.last_updated_by, rupf.last_update_date, rupf.last_update_login FROM igs_ps_rsv_uop_prf rupf, igs_pe_persid_group ppg, igs_ps_rsv_uop_pri rupr WHERE ppg.group_id = rupf.group_id AND rupf.rsv_uop_pri_id = rupr.rsv_uop_pri_id AND rupr.priority_value = 'PERSON_GRP'

View Text - HTML Formatted

SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, OU.PARTY_NAME DESCRIPTION
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN
FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PS_RSV_UOP_PRI RUPR
WHERE OU.PARTY_NUMBER = RUPF.PREFERENCE_CODE
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'ORG_UNIT' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, PV.TITLE
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN
FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_PS_VER PV
, IGS_PS_RSV_UOP_PRI RUPR
WHERE PV.COURSE_CD = RUPF.PREFERENCE_CODE
AND PV.VERSION_NUMBER = RUPF.PREFERENCE_VERSION
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'PROGRAM' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, PST.DESCRIPTION
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN
FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_PS_STAGE_TYPE PST
, IGS_PS_RSV_UOP_PRI RUPR
WHERE PST.COURSE_STAGE_TYPE = RUPF.PREFERENCE_CODE
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'PROGRAM_STAGE' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, EUS.TITLE
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN
FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_EN_UNIT_SET EUS
, IGS_PS_RSV_UOP_PRI RUPR
WHERE EUS.UNIT_SET_CD= RUPF.PREFERENCE_CODE
AND EUS.VERSION_NUMBER = RUPF.PREFERENCE_VERSION
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'UNIT_SET' UNION SELECT RUPF.ROWID
, RUPF.RSV_UOP_PRF_ID
, RUPF.RSV_UOP_PRI_ID
, RUPF.PREFERENCE_ORDER
, RUPF.PREFERENCE_CODE
, RUPF.PREFERENCE_VERSION
, PPG.DESCRIPTION
, RUPF.PERCENTAGE_RESERVED
, RUPF.GROUP_ID
, RUPF.CREATED_BY
, RUPF.CREATION_DATE
, RUPF.LAST_UPDATED_BY
, RUPF.LAST_UPDATE_DATE
, RUPF.LAST_UPDATE_LOGIN
FROM IGS_PS_RSV_UOP_PRF RUPF
, IGS_PE_PERSID_GROUP PPG
, IGS_PS_RSV_UOP_PRI RUPR
WHERE PPG.GROUP_ID = RUPF.GROUP_ID
AND RUPF.RSV_UOP_PRI_ID = RUPR.RSV_UOP_PRI_ID
AND RUPR.PRIORITY_VALUE = 'PERSON_GRP'