VIEW: APPS.IGSBV_USEC_FINAL_EXAMS

Source

View Text - Preformatted

SELECT US.UNIT_SECTION_ASSESSMENT_ID, US.UOO_ID UNIT_SECTION_ID, US.FINAL_EXAM_DATE, US.LOCATION_CD EXAM_LOCATION_CODE, US.BUILDING_CODE EXAM_BUILDING_CODE, US.ROOM_CODE EXAM_ROOM_CODE, US.EXAM_START_TIME, US.EXAM_END_TIME, LO.DESCRIPTION, BU.DESCRIPTION, RO.DESCRIPTION, UN.UNIT_CD, UN.VERSION_NUMBER, UN.CAL_TYPE, UN.CI_SEQUENCE_NUMBER, UN.LOCATION_CD, UN.UNIT_CLASS, US.CREATED_BY, US.CREATION_DATE, US.LAST_UPDATED_BY, US.LAST_UPDATE_DATE FROM IGS_PS_USEC_AS US, IGS_AD_LOCATION_ALL LO, IGS_AD_BUILDING_ALL BU, IGS_AD_ROOM_ALL RO, IGS_PS_UNIT_OFR_OPT_ALL UN WHERE US.LOCATION_CD = LO.LOCATION_CD AND US.UOO_ID = UN.UOO_ID AND US.BUILDING_CODE = BU.BUILDING_ID (+) AND US.ROOM_CODE = RO.ROOM_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT US.UNIT_SECTION_ASSESSMENT_ID
, US.UOO_ID UNIT_SECTION_ID
, US.FINAL_EXAM_DATE
, US.LOCATION_CD EXAM_LOCATION_CODE
, US.BUILDING_CODE EXAM_BUILDING_CODE
, US.ROOM_CODE EXAM_ROOM_CODE
, US.EXAM_START_TIME
, US.EXAM_END_TIME
, LO.DESCRIPTION
, BU.DESCRIPTION
, RO.DESCRIPTION
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_AS US
, IGS_AD_LOCATION_ALL LO
, IGS_AD_BUILDING_ALL BU
, IGS_AD_ROOM_ALL RO
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE US.LOCATION_CD = LO.LOCATION_CD
AND US.UOO_ID = UN.UOO_ID
AND US.BUILDING_CODE = BU.BUILDING_ID (+)
AND US.ROOM_CODE = RO.ROOM_ID (+) WITH READ ONLY