VIEW: APPS.IGS_PS_SCH_INT

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.calendar_type calendar_type, tab.sequence_number sequence_number, tab.transaction_type transaction_type, tab.unit_section_occurrence_id unit_section_occurrence_id, tab.unit_cd unit_cd, tab.version_number version_number, tab.unit_title unit_title, tab.owner_org_unit_cd owner_org_unit_cd, tab.unit_class unit_class, tab.monday monday, tab.tuesday tuesday, tab.wednesday wednesday, tab.thursday thursday, tab.friday friday, tab.saturday saturday, tab.sunday sunday, tab.unit_section_start_date unit_section_start_date, tab.unit_section_end_date unit_section_end_date, tab.start_time start_time, tab.end_time end_time, tab.enrollment_maximum enrollment_maximum, tab.enrollment_actual enrollment_actual, tab.instructor_id instructor_id, tab.surname surname, tab.building_code building_code, tab.room_code room_code, tab.location_cd location_cd, tab.unit_sec_cross_unit_sec_id unit_sec_cross_unit_sec_id, tab.uoo_id uoo_id, tab.schedule_status schedule_status, tab.error_text error_text, tab.transaction_id transaction_id , tab.org_id org_id, tab.int_occurs_id, tab.int_usec_id, tab.given_names, tab.middle_name, tab.dedicated_building_code, tab.dedicated_room_code, tab.preferred_building_code, tab.preferred_room_code, tab.tba_status, tab.uso_start_date, tab.uso_end_date, tab.building_id building_id, tab.room_id room_id, tab.dedicated_building_id dedicated_building_id, tab.dedicated_room_id dedicated_room_id, tab.preferred_building_id preferred_building_id, tab.preferred_room_id preferred_room_id, tab.created_by created_by, tab.creation_date creation_date, tab.last_updated_by last_updated_by, tab.last_update_date last_update_date, tab.last_update_login last_update_login, tab.abort_flag abort_flag, tab.import_done_flag import_done_flag, tab.occurrence_identifier occurrence_identifier FROM igs_ps_sch_int_all tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.CALENDAR_TYPE CALENDAR_TYPE
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.TRANSACTION_TYPE TRANSACTION_TYPE
, TAB.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, TAB.UNIT_CD UNIT_CD
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.UNIT_TITLE UNIT_TITLE
, TAB.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, TAB.UNIT_CLASS UNIT_CLASS
, TAB.MONDAY MONDAY
, TAB.TUESDAY TUESDAY
, TAB.WEDNESDAY WEDNESDAY
, TAB.THURSDAY THURSDAY
, TAB.FRIDAY FRIDAY
, TAB.SATURDAY SATURDAY
, TAB.SUNDAY SUNDAY
, TAB.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, TAB.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, TAB.START_TIME START_TIME
, TAB.END_TIME END_TIME
, TAB.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM
, TAB.ENROLLMENT_ACTUAL ENROLLMENT_ACTUAL
, TAB.INSTRUCTOR_ID INSTRUCTOR_ID
, TAB.SURNAME SURNAME
, TAB.BUILDING_CODE BUILDING_CODE
, TAB.ROOM_CODE ROOM_CODE
, TAB.LOCATION_CD LOCATION_CD
, TAB.UNIT_SEC_CROSS_UNIT_SEC_ID UNIT_SEC_CROSS_UNIT_SEC_ID
, TAB.UOO_ID UOO_ID
, TAB.SCHEDULE_STATUS SCHEDULE_STATUS
, TAB.ERROR_TEXT ERROR_TEXT
, TAB.TRANSACTION_ID TRANSACTION_ID
, TAB.ORG_ID ORG_ID
, TAB.INT_OCCURS_ID
, TAB.INT_USEC_ID
, TAB.GIVEN_NAMES
, TAB.MIDDLE_NAME
, TAB.DEDICATED_BUILDING_CODE
, TAB.DEDICATED_ROOM_CODE
, TAB.PREFERRED_BUILDING_CODE
, TAB.PREFERRED_ROOM_CODE
, TAB.TBA_STATUS
, TAB.USO_START_DATE
, TAB.USO_END_DATE
, TAB.BUILDING_ID BUILDING_ID
, TAB.ROOM_ID ROOM_ID
, TAB.DEDICATED_BUILDING_ID DEDICATED_BUILDING_ID
, TAB.DEDICATED_ROOM_ID DEDICATED_ROOM_ID
, TAB.PREFERRED_BUILDING_ID PREFERRED_BUILDING_ID
, TAB.PREFERRED_ROOM_ID PREFERRED_ROOM_ID
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.ABORT_FLAG ABORT_FLAG
, TAB.IMPORT_DONE_FLAG IMPORT_DONE_FLAG
, TAB.OCCURRENCE_IDENTIFIER OCCURRENCE_IDENTIFIER
FROM IGS_PS_SCH_INT_ALL TAB