VIEW: APPS.IGS_PS_USEC_AS_V

Source

View Text - Preformatted

SELECT usas.rowid row_id, usas.unit_section_assessment_id unit_section_assessment_id, usas.uoo_id uoo_id, usas.final_exam_date final_exam_date, usas.exam_start_time exam_start_time, usas.exam_end_time exam_end_time, usas.location_cd location_cd, loc.description location_desc, usas.building_code building_code, bld.description building_desc, usas.room_code room_code, rom.description room_desc, usas.created_by created_by, usas.creation_date creation_date, usas.last_updated_by last_updated_by, usas.last_update_date last_update_date, usas.last_update_login last_update_login from igs_ps_usec_as usas, igs_ad_location loc, igs_ad_building bld, igs_ad_room rom WHERE usas.location_cd = loc.location_cd AND usas.building_code = bld.building_id (+) AND usas.room_code = rom.room_id (+)

View Text - HTML Formatted

SELECT USAS.ROWID ROW_ID
, USAS.UNIT_SECTION_ASSESSMENT_ID UNIT_SECTION_ASSESSMENT_ID
, USAS.UOO_ID UOO_ID
, USAS.FINAL_EXAM_DATE FINAL_EXAM_DATE
, USAS.EXAM_START_TIME EXAM_START_TIME
, USAS.EXAM_END_TIME EXAM_END_TIME
, USAS.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESC
, USAS.BUILDING_CODE BUILDING_CODE
, BLD.DESCRIPTION BUILDING_DESC
, USAS.ROOM_CODE ROOM_CODE
, ROM.DESCRIPTION ROOM_DESC
, USAS.CREATED_BY CREATED_BY
, USAS.CREATION_DATE CREATION_DATE
, USAS.LAST_UPDATED_BY LAST_UPDATED_BY
, USAS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USAS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_AS USAS
, IGS_AD_LOCATION LOC
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
WHERE USAS.LOCATION_CD = LOC.LOCATION_CD
AND USAS.BUILDING_CODE = BLD.BUILDING_ID (+)
AND USAS.ROOM_CODE = ROM.ROOM_ID (+)