VIEW: APPS.IGS_PS_USEC_OCCURS

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, uso.room_code room_code, uso.building_code scheduled_building_code, uso.room_code scheduled_room_code, uso.dedicated_building_code dedicated_building_code, uso.dedicated_room_code dedicated_room_code, uso.preferred_building_code preferred_building_code, uso.preferred_room_code preferred_room_code, uso.schedule_status schedule_status, uso.status_last_updated status_last_updated, uso.instructor_id instructor_id, 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.error_text error_text, 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.org_id org_id, 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, 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_all uso WHERE NVL (uso.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

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
, USO.ROOM_CODE ROOM_CODE
, USO.BUILDING_CODE SCHEDULED_BUILDING_CODE
, USO.ROOM_CODE SCHEDULED_ROOM_CODE
, USO.DEDICATED_BUILDING_CODE DEDICATED_BUILDING_CODE
, USO.DEDICATED_ROOM_CODE DEDICATED_ROOM_CODE
, USO.PREFERRED_BUILDING_CODE PREFERRED_BUILDING_CODE
, USO.PREFERRED_ROOM_CODE PREFERRED_ROOM_CODE
, USO.SCHEDULE_STATUS SCHEDULE_STATUS
, USO.STATUS_LAST_UPDATED STATUS_LAST_UPDATED
, USO.INSTRUCTOR_ID INSTRUCTOR_ID
, 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.ERROR_TEXT ERROR_TEXT
, 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.ORG_ID ORG_ID
, 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
, 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_ALL USO
WHERE NVL (USO.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)