View: IGS_PS_US_EXAM_MEET_V

View Text

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(+)

Columns