VIEW: APPS.IGS_PS_SCH_USEC_INT

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.int_usec_id int_usec_id, tab.calendar_type calendar_type, tab.sequence_number sequence_number, 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.unit_section_start_date unit_section_start_date, tab.unit_section_end_date unit_section_end_date, tab.unit_section_status unit_section_status, tab.enrollment_maximum enrollment_maximum, tab.enrollment_actual enrollment_actual, tab.location_cd location_cd, tab.cal_start_dt cal_start_dt, tab.cal_end_dt cal_end_dt, tab.uoo_id uoo_id, tab.transaction_id transaction_id , tab.org_id org_id, tab.enrollment_expected, tab.override_enrollment_max, 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.call_number call_number, tab.subtitle subtitle, tab.org_unit_description org_unit_description, tab.teaching_cal_alternate_code teaching_cal_alternate_code , tab.int_pat_id int_pat_id FROM igs_ps_sch_usec_int_all tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.INT_USEC_ID INT_USEC_ID
, TAB.CALENDAR_TYPE CALENDAR_TYPE
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, 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.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, TAB.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, TAB.UNIT_SECTION_STATUS UNIT_SECTION_STATUS
, TAB.ENROLLMENT_MAXIMUM ENROLLMENT_MAXIMUM
, TAB.ENROLLMENT_ACTUAL ENROLLMENT_ACTUAL
, TAB.LOCATION_CD LOCATION_CD
, TAB.CAL_START_DT CAL_START_DT
, TAB.CAL_END_DT CAL_END_DT
, TAB.UOO_ID UOO_ID
, TAB.TRANSACTION_ID TRANSACTION_ID
, TAB.ORG_ID ORG_ID
, TAB.ENROLLMENT_EXPECTED
, TAB.OVERRIDE_ENROLLMENT_MAX
, 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.CALL_NUMBER CALL_NUMBER
, TAB.SUBTITLE SUBTITLE
, TAB.ORG_UNIT_DESCRIPTION ORG_UNIT_DESCRIPTION
, TAB.TEACHING_CAL_ALTERNATE_CODE TEACHING_CAL_ALTERNATE_CODE
, TAB.INT_PAT_ID INT_PAT_ID
FROM IGS_PS_SCH_USEC_INT_ALL TAB