VIEW: APPS.IGS_PS_US_UNSCHED_CL_V

Source

View Text - Preformatted

SELECT usucl.rowid row_id, usucl.us_unscheduled_cl_id us_unscheduled_cl_id, usucl.uoo_id uoo_id, usucl.activity_type_id activity_type_id, usat.activity_type_description activity_type_description, usucl.location_cd location_cd, loc.description location_description, usucl.building_id building_id, bld.description building_description, usucl.room_id room_id, rom.description room_description, usucl.number_of_students number_of_students, usucl.hours_per_student hours_per_student, usucl.hours_per_faculty hours_per_faculty, usucl.instructor_id instructor_id, hz.party_number instructor_number, hz.party_name instructor_name, usucl.created_by created_by, usucl.creation_date creation_date, usucl.last_updated_by last_updated_by, usucl.last_update_date last_update_date, usucl.last_update_login last_update_login FROM igs_ps_us_unsched_cl usucl, hz_parties hz, igs_ps_usec_act_type usat, igs_ad_location loc, igs_ad_building bld, igs_ad_room rom WHERE usucl.instructor_id = hz.party_id(+) AND usucl.activity_type_id = usat.activity_type_id AND usucl.location_cd = loc.location_cd AND usucl.building_id = bld.building_id AND usucl.room_id = rom.room_id

View Text - HTML Formatted

SELECT USUCL.ROWID ROW_ID
, USUCL.US_UNSCHEDULED_CL_ID US_UNSCHEDULED_CL_ID
, USUCL.UOO_ID UOO_ID
, USUCL.ACTIVITY_TYPE_ID ACTIVITY_TYPE_ID
, USAT.ACTIVITY_TYPE_DESCRIPTION ACTIVITY_TYPE_DESCRIPTION
, USUCL.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, USUCL.BUILDING_ID BUILDING_ID
, BLD.DESCRIPTION BUILDING_DESCRIPTION
, USUCL.ROOM_ID ROOM_ID
, ROM.DESCRIPTION ROOM_DESCRIPTION
, USUCL.NUMBER_OF_STUDENTS NUMBER_OF_STUDENTS
, USUCL.HOURS_PER_STUDENT HOURS_PER_STUDENT
, USUCL.HOURS_PER_FACULTY HOURS_PER_FACULTY
, USUCL.INSTRUCTOR_ID INSTRUCTOR_ID
, HZ.PARTY_NUMBER INSTRUCTOR_NUMBER
, HZ.PARTY_NAME INSTRUCTOR_NAME
, USUCL.CREATED_BY CREATED_BY
, USUCL.CREATION_DATE CREATION_DATE
, USUCL.LAST_UPDATED_BY LAST_UPDATED_BY
, USUCL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USUCL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_US_UNSCHED_CL USUCL
, HZ_PARTIES HZ
, IGS_PS_USEC_ACT_TYPE USAT
, IGS_AD_LOCATION LOC
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
WHERE USUCL.INSTRUCTOR_ID = HZ.PARTY_ID(+)
AND USUCL.ACTIVITY_TYPE_ID = USAT.ACTIVITY_TYPE_ID
AND USUCL.LOCATION_CD = LOC.LOCATION_CD
AND USUCL.BUILDING_ID = BLD.BUILDING_ID
AND USUCL.ROOM_ID = ROM.ROOM_ID