Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOO.ROWID
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, UOO.UOO_ID
, PE.PARTY_NUMBER
, UOO.IVRS_AVAILABLE_IND
, UOO.OFFERED_IND
, UOO.GRADING_SCHEMA_PRCDNCE_IND
, UOO.UNIT_QUOTA
, UOO.UNIT_QUOTA_RESERVED_PLACES
, UOO.UNIT_CONTACT
, UOO.GRADING_SCHEMA_CD
, UOO.GS_VERSION_NUMBER
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN
, UOO.REQUEST_ID
, UOO.PROGRAM_APPLICATION_ID
, UOO.PROGRAM_ID
, UOO.PROGRAM_UPDATE_DATE
, UOO.CALL_NUMBER
, UOO.UNIT_SECTION_STATUS
, UOO.UNIT_SECTION_START_DATE
, UOO.UNIT_SECTION_END_DATE
, UOO.ENROLLMENT_ACTUAL
, UOO.WAITLIST_ACTUAL
, UOO.STATE_FINANCIAL_AID
, UOO.FEDERAL_FINANCIAL_AID
, UOO.INSTITUTIONAL_FINANCIAL_AID
, UOO.SS_ENROL_IND
, UOO.OWNER_ORG_UNIT_CD
, UOO.ATTENDANCE_REQUIRED_IND
, UOO.RESERVED_SEATING_ALLOWED
, UOO.SPECIAL_PERMISSION_IND
, UOO.SS_DISPLAY_IND
, UOO.DIR_ENROLLMENT
, UOO.ENR_FROM_WLST
, UOO.INQ_NOT_WLST
, UOO.REV_ACCOUNT_CD
, UOO.ANON_UNIT_GRADING_IND
, UOO.ANON_ASSESS_GRADING_IND
, UOO.NON_STD_USEC_IND
, UOO.AUDITABLE_IND
, UOO.AUDIT_PERMISSION_IND
, UOO.NOT_MULTIPLE_SECTION_FLAG
, UOO.SUP_UOO_ID SUP_UOO_ID
, UOO.RELATION_TYPE RELATION_TYPE
, UOO.DEFAULT_ENROLL_FLAG DEFAULT_ENROLL_FLAG
, UOO.ABORT_FLAG ABORT_FLAG
FROM IGS_PS_UNIT_OFR_OPT UOO
, HZ_PARTIES PE
WHERE UOO.UNIT_CONTACT = PE.PARTY_ID(+)