VIEW: APPS.IGS_PS_USEC_OCCURS_V

Source

View Text - Preformatted

SELECT uso.rowid row_id, uso.unit_section_occurrence_id unit_section_occurrence_id, uso.uoo_id uoo_id, uso.monday monday, uso.tuesday tuesday, uso.wednesday wednesday, uso.thursday thursday, uso.friday friday, uso.saturday saturday, uso.sunday sunday, uso.start_time start_time, uso.end_time end_time, uso.building_code building_code, bld1.description building_desc, uso.building_code scheduled_building_code, bld1.description scheduled_building_desc, uso.room_code scheduled_room_code, rom1.description scheduled_room_desc, uso.dedicated_building_code dedicated_building_code, bld2.description dedicated_building_desc, uso.dedicated_room_code dedicated_room_code, rom2.description dedicated_room_description, uso.preferred_building_code preferred_building_code, bld3.description preferred_building_desc, uso.preferred_room_code preferred_room_code, rom3.description preferred_room_desc, uso.room_code room_code, rom1.description room_desc, uso.schedule_status, lkup.meaning schedule_status_desc, uso.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, uso.start_date start_date, uso.end_date end_date, uso.to_be_announced to_be_announced, uso.inst_notify_ind inst_notify_ind, uso.notify_status notify_status, uso.preferred_region_code preferred_region_code, lkup1.meaning preferred_region_desc, uso.no_set_day_ind no_set_day_ind, uso.cancel_flag cancel_flag, uso.occurrence_identifier occurrence_identifier, uso.abort_flag abort_flag FROM igs_ps_usec_occurs uso, igs_ad_building bld1, igs_ad_room rom1, igs_ad_building bld2, igs_ad_room rom2, igs_ad_building bld3, igs_ad_room rom3, igs_lookup_values lkup, igs_lookup_values lkupb, igs_lookup_values lkup1 WHERE uso.building_code = bld1.building_id (+) AND uso.room_code = rom1.room_id (+) AND uso.dedicated_building_code = bld2.building_id (+) AND uso.dedicated_room_code = rom2.room_id (+) AND uso.preferred_building_code = bld3.building_id (+) AND uso.preferred_room_code = rom3.room_id (+) AND lkup.lookup_type(+) ='SCHEDULE_TYPE' AND lkup.lookup_code(+) = uso.schedule_status AND lkupb.lookup_type (+) = 'NOTIFY_TYPE' AND lkupb.lookup_code (+) = uso.notify_status AND lkup1.lookup_type(+) = 'IGS_OR_LOC_REGION' AND lkup1.lookup_code (+) = uso.preferred_region_code

View Text - HTML Formatted

SELECT USO.ROWID ROW_ID
, USO.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, USO.UOO_ID UOO_ID
, USO.MONDAY MONDAY
, USO.TUESDAY TUESDAY
, USO.WEDNESDAY WEDNESDAY
, USO.THURSDAY THURSDAY
, USO.FRIDAY FRIDAY
, USO.SATURDAY SATURDAY
, USO.SUNDAY SUNDAY
, USO.START_TIME START_TIME
, USO.END_TIME END_TIME
, USO.BUILDING_CODE BUILDING_CODE
, BLD1.DESCRIPTION BUILDING_DESC
, USO.BUILDING_CODE SCHEDULED_BUILDING_CODE
, BLD1.DESCRIPTION SCHEDULED_BUILDING_DESC
, USO.ROOM_CODE SCHEDULED_ROOM_CODE
, ROM1.DESCRIPTION SCHEDULED_ROOM_DESC
, USO.DEDICATED_BUILDING_CODE DEDICATED_BUILDING_CODE
, BLD2.DESCRIPTION DEDICATED_BUILDING_DESC
, USO.DEDICATED_ROOM_CODE DEDICATED_ROOM_CODE
, ROM2.DESCRIPTION DEDICATED_ROOM_DESCRIPTION
, USO.PREFERRED_BUILDING_CODE PREFERRED_BUILDING_CODE
, BLD3.DESCRIPTION PREFERRED_BUILDING_DESC
, USO.PREFERRED_ROOM_CODE PREFERRED_ROOM_CODE
, ROM3.DESCRIPTION PREFERRED_ROOM_DESC
, USO.ROOM_CODE ROOM_CODE
, ROM1.DESCRIPTION ROOM_DESC
, USO.SCHEDULE_STATUS
, LKUP.MEANING SCHEDULE_STATUS_DESC
, USO.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
, USO.START_DATE START_DATE
, USO.END_DATE END_DATE
, USO.TO_BE_ANNOUNCED TO_BE_ANNOUNCED
, USO.INST_NOTIFY_IND INST_NOTIFY_IND
, USO.NOTIFY_STATUS NOTIFY_STATUS
, USO.PREFERRED_REGION_CODE PREFERRED_REGION_CODE
, LKUP1.MEANING PREFERRED_REGION_DESC
, USO.NO_SET_DAY_IND NO_SET_DAY_IND
, USO.CANCEL_FLAG CANCEL_FLAG
, USO.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER
, USO.ABORT_FLAG ABORT_FLAG
FROM IGS_PS_USEC_OCCURS USO
, IGS_AD_BUILDING BLD1
, IGS_AD_ROOM ROM1
, IGS_AD_BUILDING BLD2
, IGS_AD_ROOM ROM2
, IGS_AD_BUILDING BLD3
, IGS_AD_ROOM ROM3
, IGS_LOOKUP_VALUES LKUP
, IGS_LOOKUP_VALUES LKUPB
, IGS_LOOKUP_VALUES LKUP1
WHERE USO.BUILDING_CODE = BLD1.BUILDING_ID (+)
AND USO.ROOM_CODE = ROM1.ROOM_ID (+)
AND USO.DEDICATED_BUILDING_CODE = BLD2.BUILDING_ID (+)
AND USO.DEDICATED_ROOM_CODE = ROM2.ROOM_ID (+)
AND USO.PREFERRED_BUILDING_CODE = BLD3.BUILDING_ID (+)
AND USO.PREFERRED_ROOM_CODE = ROM3.ROOM_ID (+)
AND LKUP.LOOKUP_TYPE(+) ='SCHEDULE_TYPE'
AND LKUP.LOOKUP_CODE(+) = USO.SCHEDULE_STATUS
AND LKUPB.LOOKUP_TYPE (+) = 'NOTIFY_TYPE'
AND LKUPB.LOOKUP_CODE (+) = USO.NOTIFY_STATUS
AND LKUP1.LOOKUP_TYPE(+) = 'IGS_OR_LOC_REGION'
AND LKUP1.LOOKUP_CODE (+) = USO.PREFERRED_REGION_CODE