VIEW: APPS.IGS_PS_UNIT_OFR_OPT_PE_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)