View: IGS_PS_USEC_OCCURS_V

View Text

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

Columns