VIEW: APPS.IGS_PS_USEC_OCCURS_FULL_V

Source

View Text - Preformatted

SELECT uso.rowid row_id, uso.unit_section_occurrence_id unit_section_occurrence_id, uso.uoo_id uoo_id, uoov.unit_cd unit_cd, uoov.version_number version_number, uoov.status_description us_status_desc, uoov.unit_section_status unit_section_status, uoov.title title, uoov.call_number call_number, uoov.cal_type cal_type, uoov.ci_sequence_number ci_sequence_number, uoov.alternate_code alternate_code, uoov.cal_start_dt cal_start_dt, uoov.cal_end_dt cal_end_dt, uoov.unit_class unit_class, uoov.unit_mode unit_mode, uoov.location_cd location_cd, uoov.location_description location_description, uoov.unit_section_start_date unit_section_start_date, uoov.unit_section_end_date unit_section_end_date, uso.to_be_announced to_be_announced, uso.monday monday, uso.tuesday tuesday, uso.wednesday wednesday, uso.thursday thursday, uso.friday friday, uso.saturday saturday, uso.sunday sunday, uso.start_date uso_start_date, uso.end_date uso_end_date, uso.start_time start_time, uso.end_time end_time, uso.building_code building_code, bld.description building_description, uso.room_code room_code, rom.description room_description, uso.schedule_status, lkup.meaning schedule_status_desc, uso.status_last_updated status_last_updated, uso.instructor_id instructor_id, NULL surname, NULL person_number, uso.error_text error_text, uso.attribute_category attribute_category, uso.attribute1 attribute1, uso.attribute2 attribute2, uso.attribute3 attribute3, uso.attribute4 attribute4, uso.attribute5 attribute5, uso.attribute6 attribute6, uso.attribute7 attribute7, uso.attribute8 attribute8, uso.attribute9 attribute9, uso.attribute10 attribute10, uso.attribute11 attribute11, uso.attribute12 attribute12, uso.attribute13 attribute13, uso.attribute14 attribute14, uso.attribute15 attribute15, uso.attribute16 attribute16, uso.attribute17 attribute17, uso.attribute18 attribute18, uso.attribute19 attribute19, uso.attribute20 attribute20, uso.created_by created_by, uso.creation_date creation_date, uso.last_updated_by last_updated_by, uso.last_update_date last_update_date, uso.last_update_login last_update_login, uso.request_id request_id, uso.program_application_id program_application_id, uso.program_id program_id, uso.program_update_date program_update_date FROM igs_ps_usec_occurs uso, igs_ad_building bld, igs_ad_room rom, igs_lookup_values lkup, igs_ps_unit_ofr_opt_v uoov WHERE uso.building_code = bld.building_id (+) AND uso.room_code = rom.room_id (+) AND lkup.lookup_type(+) ='SCHEDULE_TYPE' AND lkup.lookup_code(+) = uso.schedule_status AND uso.uoo_id = uoov.uoo_id

View Text - HTML Formatted

SELECT USO.ROWID ROW_ID
, USO.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, USO.UOO_ID UOO_ID
, UOOV.UNIT_CD UNIT_CD
, UOOV.VERSION_NUMBER VERSION_NUMBER
, UOOV.STATUS_DESCRIPTION US_STATUS_DESC
, UOOV.UNIT_SECTION_STATUS UNIT_SECTION_STATUS
, UOOV.TITLE TITLE
, UOOV.CALL_NUMBER CALL_NUMBER
, UOOV.CAL_TYPE CAL_TYPE
, UOOV.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UOOV.ALTERNATE_CODE ALTERNATE_CODE
, UOOV.CAL_START_DT CAL_START_DT
, UOOV.CAL_END_DT CAL_END_DT
, UOOV.UNIT_CLASS UNIT_CLASS
, UOOV.UNIT_MODE UNIT_MODE
, UOOV.LOCATION_CD LOCATION_CD
, UOOV.LOCATION_DESCRIPTION LOCATION_DESCRIPTION
, UOOV.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, UOOV.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED
, USO.MONDAY MONDAY
, USO.TUESDAY TUESDAY
, USO.WEDNESDAY WEDNESDAY
, USO.THURSDAY THURSDAY
, USO.FRIDAY FRIDAY
, USO.SATURDAY SATURDAY
, USO.SUNDAY SUNDAY
, USO.START_DATE USO_START_DATE
, USO.END_DATE USO_END_DATE
, USO.START_TIME START_TIME
, USO.END_TIME END_TIME
, USO.BUILDING_CODE BUILDING_CODE
, BLD.DESCRIPTION BUILDING_DESCRIPTION
, USO.ROOM_CODE ROOM_CODE
, ROM.DESCRIPTION ROOM_DESCRIPTION
, USO.SCHEDULE_STATUS
, LKUP.MEANING SCHEDULE_STATUS_DESC
, USO.STATUS_LAST_UPDATED STATUS_LAST_UPDATED
, USO.INSTRUCTOR_ID INSTRUCTOR_ID
, NULL SURNAME
, NULL PERSON_NUMBER
, USO.ERROR_TEXT ERROR_TEXT
, USO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, USO.ATTRIBUTE1 ATTRIBUTE1
, USO.ATTRIBUTE2 ATTRIBUTE2
, USO.ATTRIBUTE3 ATTRIBUTE3
, USO.ATTRIBUTE4 ATTRIBUTE4
, USO.ATTRIBUTE5 ATTRIBUTE5
, USO.ATTRIBUTE6 ATTRIBUTE6
, USO.ATTRIBUTE7 ATTRIBUTE7
, USO.ATTRIBUTE8 ATTRIBUTE8
, USO.ATTRIBUTE9 ATTRIBUTE9
, USO.ATTRIBUTE10 ATTRIBUTE10
, USO.ATTRIBUTE11 ATTRIBUTE11
, USO.ATTRIBUTE12 ATTRIBUTE12
, USO.ATTRIBUTE13 ATTRIBUTE13
, USO.ATTRIBUTE14 ATTRIBUTE14
, USO.ATTRIBUTE15 ATTRIBUTE15
, USO.ATTRIBUTE16 ATTRIBUTE16
, USO.ATTRIBUTE17 ATTRIBUTE17
, USO.ATTRIBUTE18 ATTRIBUTE18
, USO.ATTRIBUTE19 ATTRIBUTE19
, USO.ATTRIBUTE20 ATTRIBUTE20
, USO.CREATED_BY CREATED_BY
, USO.CREATION_DATE CREATION_DATE
, USO.LAST_UPDATED_BY LAST_UPDATED_BY
, USO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, USO.REQUEST_ID REQUEST_ID
, USO.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, USO.PROGRAM_ID PROGRAM_ID
, USO.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_PS_USEC_OCCURS USO
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
, IGS_LOOKUP_VALUES LKUP
, IGS_PS_UNIT_OFR_OPT_V UOOV
WHERE USO.BUILDING_CODE = BLD.BUILDING_ID (+)
AND USO.ROOM_CODE = ROM.ROOM_ID (+)
AND LKUP.LOOKUP_TYPE(+) ='SCHEDULE_TYPE'
AND LKUP.LOOKUP_CODE(+) = USO.SCHEDULE_STATUS
AND USO.UOO_ID = UOOV.UOO_ID