VIEW: APPS.IGS_PS_RSV_USEC_PRF_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'