VIEW: APPS.IGS_PS_US_EXAM_MEET_V

Source

View Text - Preformatted

SELECT em.rowid row_id, em.exam_meet_id exam_meet_id, em.exam_meet_group_id exam_meet_group_id, em.uoo_id uoo_id, uoo.unit_cd || ' - ' || uoo.version_number || ' - ' || uoo.location_cd || ' - ' || uoo.unit_class || ' - ' || uoo.unit_mode || ' - ' || uoo.alternate_code || DECODE (NVL (usa.final_exam_date, SYSDATE), SYSDATE, '', ' - ' || TO_CHAR (usa.final_exam_date, 'DD-MON-YYYY')) || DECODE (NVL (usa.exam_start_time, SYSDATE), SYSDATE, '', ' - ' || TO_CHAR (usa.exam_start_time, 'HH24:MI')) || DECODE (NVL (usa.exam_end_time, SYSDATE), SYSDATE, '', ' - ' || TO_CHAR (usa.exam_end_time, 'HH24:MI') || DECODE (NVL (usa.location_desc, '-'), '-', '', ' - ' || usa.location_desc) || DECODE (NVL (usa.building_desc, '-'), '-', '', ' - ' || usa.building_desc) || DECODE (NVL (usa.room_desc, '-'), '-', '', ' - ' || usa.room_desc)) unit_section, NVL (NVL (ulw.enrollment_maximum, uv.enrollment_maximum), 0) enrollment_maximum, em.host host, em.created_by created_by, em.creation_date creation_date, em.last_updated_by last_updated_by, em.last_update_date last_update_date, em.last_update_login last_update_login FROM igs_ps_us_exam_meet em, igs_ps_usec_lim_wlst ulw, igs_ps_usec_as_v usa, igs_ps_unit_ofr_opt_v uoo, igs_ps_unit_ver uv WHERE em.uoo_id = uoo.uoo_id AND em.uoo_id = usa.uoo_id AND uoo.unit_cd = uv.unit_cd AND uoo.version_number = uv.version_number AND em.uoo_id = ulw.uoo_id(+)

View Text - HTML Formatted

SELECT EM.ROWID ROW_ID
, EM.EXAM_MEET_ID EXAM_MEET_ID
, EM.EXAM_MEET_GROUP_ID EXAM_MEET_GROUP_ID
, EM.UOO_ID UOO_ID
, UOO.UNIT_CD || ' - ' || UOO.VERSION_NUMBER || ' - ' || UOO.LOCATION_CD || ' - ' || UOO.UNIT_CLASS || ' - ' || UOO.UNIT_MODE || ' - ' || UOO.ALTERNATE_CODE || DECODE (NVL (USA.FINAL_EXAM_DATE
, SYSDATE)
, SYSDATE
, ''
, ' - ' || TO_CHAR (USA.FINAL_EXAM_DATE
, 'DD-MON-YYYY')) || DECODE (NVL (USA.EXAM_START_TIME
, SYSDATE)
, SYSDATE
, ''
, ' - ' || TO_CHAR (USA.EXAM_START_TIME
, 'HH24:MI')) || DECODE (NVL (USA.EXAM_END_TIME
, SYSDATE)
, SYSDATE
, ''
, ' - ' || TO_CHAR (USA.EXAM_END_TIME
, 'HH24:MI') || DECODE (NVL (USA.LOCATION_DESC
, '-')
, '-'
, ''
, ' - ' || USA.LOCATION_DESC) || DECODE (NVL (USA.BUILDING_DESC
, '-')
, '-'
, ''
, ' - ' || USA.BUILDING_DESC) || DECODE (NVL (USA.ROOM_DESC
, '-')
, '-'
, ''
, ' - ' || USA.ROOM_DESC)) UNIT_SECTION
, NVL (NVL (ULW.ENROLLMENT_MAXIMUM
, UV.ENROLLMENT_MAXIMUM)
, 0) ENROLLMENT_MAXIMUM
, EM.HOST HOST
, EM.CREATED_BY CREATED_BY
, EM.CREATION_DATE CREATION_DATE
, EM.LAST_UPDATED_BY LAST_UPDATED_BY
, EM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_US_EXAM_MEET EM
, IGS_PS_USEC_LIM_WLST ULW
, IGS_PS_USEC_AS_V USA
, IGS_PS_UNIT_OFR_OPT_V UOO
, IGS_PS_UNIT_VER UV
WHERE EM.UOO_ID = UOO.UOO_ID
AND EM.UOO_ID = USA.UOO_ID
AND UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND EM.UOO_ID = ULW.UOO_ID(+)