VIEW: APPS.IGS_PS_UNIT_OFR_OPT_SV

Source

View Text - Preformatted

SELECT ROWID row_id, unit_cd, version_number, cal_type, ci_sequence_number, location_cd, unit_class, uoo_id, ivrs_available_ind, call_number, unit_section_status, unit_section_start_date, unit_section_end_date, enrollment_actual, waitlist_actual, offered_ind, state_financial_aid, grading_schema_prcdnce_ind, federal_financial_aid, unit_quota, unit_quota_reserved_places, institutional_financial_aid, grading_schema_cd, gs_version_number, unit_contact, ss_enrol_ind, created_by, creation_date, last_updated_by, last_update_date, last_update_login, request_id, program_application_id, program_id, program_update_date, org_id, owner_org_unit_cd, attendance_required_ind, reserved_seating_allowed, special_permission_ind, ss_display_ind, dir_enrollment, enr_from_wlst, inq_not_wlst, rev_account_cd, anon_unit_grading_ind, anon_assess_grading_ind, non_std_usec_ind, auditable_ind, audit_permission_ind, not_multiple_section_flag, sup_uoo_id, relation_type, default_enroll_flag FROM igs_ps_unit_ofr_opt_all

View Text - HTML Formatted

SELECT ROWID ROW_ID
, UNIT_CD
, VERSION_NUMBER
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, LOCATION_CD
, UNIT_CLASS
, UOO_ID
, IVRS_AVAILABLE_IND
, CALL_NUMBER
, UNIT_SECTION_STATUS
, UNIT_SECTION_START_DATE
, UNIT_SECTION_END_DATE
, ENROLLMENT_ACTUAL
, WAITLIST_ACTUAL
, OFFERED_IND
, STATE_FINANCIAL_AID
, GRADING_SCHEMA_PRCDNCE_IND
, FEDERAL_FINANCIAL_AID
, UNIT_QUOTA
, UNIT_QUOTA_RESERVED_PLACES
, INSTITUTIONAL_FINANCIAL_AID
, GRADING_SCHEMA_CD
, GS_VERSION_NUMBER
, UNIT_CONTACT
, SS_ENROL_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, OWNER_ORG_UNIT_CD
, ATTENDANCE_REQUIRED_IND
, RESERVED_SEATING_ALLOWED
, SPECIAL_PERMISSION_IND
, SS_DISPLAY_IND
, DIR_ENROLLMENT
, ENR_FROM_WLST
, INQ_NOT_WLST
, REV_ACCOUNT_CD
, ANON_UNIT_GRADING_IND
, ANON_ASSESS_GRADING_IND
, NON_STD_USEC_IND
, AUDITABLE_IND
, AUDIT_PERMISSION_IND
, NOT_MULTIPLE_SECTION_FLAG
, SUP_UOO_ID
, RELATION_TYPE
, DEFAULT_ENROLL_FLAG
FROM IGS_PS_UNIT_OFR_OPT_ALL