VIEW: APPS.IGS_EN_TIMESLOT_PREF_V

Source

View Text - Preformatted

SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, pt.description DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_ps_type pt WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value = 'PROG_TYPE' AND pt.course_type = etp.preference_code UNION SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, ou.description DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_or_unit ou WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value = 'ORG_UNIT' AND ou.org_unit_cd = etp.preference_code UNION SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, pv.title DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_ps_ver pv WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value = 'PROGRAM' AND pv.course_cd = etp.preference_code AND pv.version_number = etp.preference_version UNION SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, ppg.description DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_pe_persid_group ppg WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value = 'PERSON_GRP' AND ppg.group_cd = etp.preference_code UNION SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, pst.description DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_ps_stage_type pst WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value = 'PROG_STAGE' AND pst.course_stage_type = etp.preference_code UNION SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, lkup.meaning DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_lookups_view lkup WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value IN ('TOTAL_CP','GPA') AND lkup.lookup_code = etp.preference_code AND lkup.lookup_type = 'ASC_DESC' UNION SELECT etp.rowid ROW_ID, etp.igs_en_timeslot_pref_id IGS_EN_TIMESLOT_PREF_ID, etp.igs_en_timeslot_prty_id IGS_EN_TIMESLOT_PRTY_ID, etp.preference_order PREFERENCE_ORDER, etp.preference_code PREFERENCE_CODE, etp.preference_version PREFERENCE_VERSION, etp.sequence_number SEQUENCE_NUMBER, ct.description DESCRIPTION, etp.created_by CREATED_BY, etp.creation_date CREATION_DATE, etp.last_updated_by LAST_UPDATED_BY, etp.last_update_date LAST_UPDATE_DATE, etp.last_update_login LAST_UPDATE_LOGIN FROM igs_en_timeslot_pref etp, igs_en_timeslot_prty etpy, igs_ca_inst ci, igs_ca_type ct WHERE etp.igs_en_timeslot_prty_id = etpy.igs_en_timeslot_prty_id AND etpy.priority_value IN ('ENRCP_ASC','ENRCP_DESC') AND ci.cal_type = etp.preference_code AND ci.sequence_number = etp.sequence_number AND ci.cal_type = ct.cal_type

View Text - HTML Formatted

SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PT.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PS_TYPE PT
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PROG_TYPE'
AND PT.COURSE_TYPE = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, OU.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_OR_UNIT OU
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'ORG_UNIT'
AND OU.ORG_UNIT_CD = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PV.TITLE DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PS_VER PV
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PROGRAM'
AND PV.COURSE_CD = ETP.PREFERENCE_CODE
AND PV.VERSION_NUMBER = ETP.PREFERENCE_VERSION UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PPG.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PE_PERSID_GROUP PPG
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PERSON_GRP'
AND PPG.GROUP_CD = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PST.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_PS_STAGE_TYPE PST
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE = 'PROG_STAGE'
AND PST.COURSE_STAGE_TYPE = ETP.PREFERENCE_CODE UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, LKUP.MEANING DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_LOOKUPS_VIEW LKUP
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE IN ('TOTAL_CP'
, 'GPA')
AND LKUP.LOOKUP_CODE = ETP.PREFERENCE_CODE
AND LKUP.LOOKUP_TYPE = 'ASC_DESC' UNION SELECT ETP.ROWID ROW_ID
, ETP.IGS_EN_TIMESLOT_PREF_ID IGS_EN_TIMESLOT_PREF_ID
, ETP.IGS_EN_TIMESLOT_PRTY_ID IGS_EN_TIMESLOT_PRTY_ID
, ETP.PREFERENCE_ORDER PREFERENCE_ORDER
, ETP.PREFERENCE_CODE PREFERENCE_CODE
, ETP.PREFERENCE_VERSION PREFERENCE_VERSION
, ETP.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CT.DESCRIPTION DESCRIPTION
, ETP.CREATED_BY CREATED_BY
, ETP.CREATION_DATE CREATION_DATE
, ETP.LAST_UPDATED_BY LAST_UPDATED_BY
, ETP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ETP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_TIMESLOT_PREF ETP
, IGS_EN_TIMESLOT_PRTY ETPY
, IGS_CA_INST CI
, IGS_CA_TYPE CT
WHERE ETP.IGS_EN_TIMESLOT_PRTY_ID = ETPY.IGS_EN_TIMESLOT_PRTY_ID
AND ETPY.PRIORITY_VALUE IN ('ENRCP_ASC'
, 'ENRCP_DESC')
AND CI.CAL_TYPE = ETP.PREFERENCE_CODE
AND CI.SEQUENCE_NUMBER = ETP.SEQUENCE_NUMBER
AND CI.CAL_TYPE = CT.CAL_TYPE