VIEW: APPS.IGS_PS_RSV_ORGUN_PRF_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'