View: IGSBV_USEC_FINAL_EXAMS

Product:	IGS - Student System
Description:	This is the base view, which describes the relation between unit sections and assessments done in it.
Implementation/DBA Data:	APPS.IGSBV_USEC_FINAL_EXAMS

View Text

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

Columns