View: IGS_PS_USEC_OCCURS_FULL_V

View Text

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

Columns