VIEW: APPS.IGS_PS_UNIT_OFR_OPT_V

Source

View Text - Preformatted

SELECT uoo.row_id row_id, uoo.uoo_id uoo_id, uoo.unit_cd unit_cd, uoo.version_number version_number, uv.unit_status unit_status, uv.title title, uoo.call_number call_number, uoo.cal_type cal_type, uoo.ci_sequence_number ci_sequence_number, ci.alternate_code alternate_code, ci.start_dt cal_start_dt, ci.end_dt cal_end_dt, uoo.unit_class unit_class, uc.unit_mode unit_mode, uoo.location_cd location_cd, loc.description location_description, uoo.unit_section_status unit_section_status, us.meaning status_description, uoo.unit_section_start_date unit_section_start_date, uoo.unit_section_end_date unit_section_end_date, uoo.enrollment_actual enrollment_actual, uoo.waitlist_actual waitlist_actual, uoo.state_financial_aid state_financial_aid, uoo.federal_financial_aid federal_financial_aid, uoo.institutional_financial_aid institutional_financial_aid, uoo.ivrs_available_ind ivrs_available_ind, uoo.grading_schema_prcdnce_ind grading_schema_prcdnce_ind, uoo.unit_quota unit_quota, uoo.unit_quota_reserved_places unit_quota_reserved_places, uoo.grading_schema_cd grading_schema_cd, uoo.gs_version_number gs_version_number, uoo.unit_contact unit_contact, uoo.offered_ind offered_ind, uoo.owner_org_unit_cd, ou.start_dt, ou.party_name, uoo.attendance_required_ind, uoo.anon_unit_grading_ind, uoo.anon_assess_grading_ind, uoo.non_std_usec_ind, uoo.reserved_seating_allowed, uoo.special_permission_ind, uoo.ss_display_ind , uoo.ss_enrol_ind, NVL(cps.achievable_credit_points,uv.achievable_credit_points) achievable_credit_points, NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points , uoo.DIR_ENROLLMENT , uoo.ENR_FROM_WLST , uoo.INQ_NOT_WLST , uoo.created_by created_by , uoo.creation_date creation_date, uoo.last_updated_by last_updated_by, uoo.last_update_date last_update_date, uoo.last_update_login last_update_login, uoo.request_id request_id, uoo.program_application_id program_application_id, uoo.program_id program_id, uoo.program_update_date program_update_date , uoo.rev_account_cd , uoo.auditable_ind auditable_ind, uoo.audit_permission_ind audit_permission_ind, uoo.not_multiple_section_flag not_multiple_section_flag, uoo.sup_uoo_id sup_uoo_id, uoo.relation_type relation_type, urel.meaning relation_type_meaning, uoo.default_enroll_flag default_enroll_flag, ci.description cal_inst_description, cps.billing_hrs, uoo.abort_flag abort_flag FROM igs_ps_unit_ofr_opt uoo, igs_ps_unit_ver uv, igs_ca_inst ci, igs_ad_location loc, igs_as_unit_class uc, igs_lookup_values us, igs_or_inst_org_base_v ou, igs_ps_usec_cps cps, igs_lookup_values urel WHERE uoo.unit_cd = uv.unit_cd AND uoo.version_number = uv.version_number AND uoo.cal_type = ci.cal_type AND uoo.ci_sequence_number = ci.sequence_number AND uoo.location_cd = loc.location_cd AND uoo.unit_class = uc.unit_class AND uoo.unit_section_status = us.lookup_code AND us.lookup_type = 'UNIT_SECTION_STATUS' AND ou.inst_org_ind(+) = 'O' AND uoo.owner_org_unit_cd = ou.party_number(+) AND uoo.uoo_id = cps.uoo_id(+) AND uoo.relation_type=urel.lookup_code AND urel.lookup_type='UOO_RELATION_TYPE'

View Text - HTML Formatted

SELECT UOO.ROW_ID ROW_ID
, UOO.UOO_ID UOO_ID
, UOO.UNIT_CD UNIT_CD
, UOO.VERSION_NUMBER VERSION_NUMBER
, UV.UNIT_STATUS UNIT_STATUS
, UV.TITLE TITLE
, UOO.CALL_NUMBER CALL_NUMBER
, UOO.CAL_TYPE CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.START_DT CAL_START_DT
, CI.END_DT CAL_END_DT
, UOO.UNIT_CLASS UNIT_CLASS
, UC.UNIT_MODE UNIT_MODE
, UOO.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, UOO.UNIT_SECTION_STATUS UNIT_SECTION_STATUS
, US.MEANING STATUS_DESCRIPTION
, UOO.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, UOO.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, UOO.ENROLLMENT_ACTUAL ENROLLMENT_ACTUAL
, UOO.WAITLIST_ACTUAL WAITLIST_ACTUAL
, UOO.STATE_FINANCIAL_AID STATE_FINANCIAL_AID
, UOO.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID
, UOO.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID
, UOO.IVRS_AVAILABLE_IND IVRS_AVAILABLE_IND
, UOO.GRADING_SCHEMA_PRCDNCE_IND GRADING_SCHEMA_PRCDNCE_IND
, UOO.UNIT_QUOTA UNIT_QUOTA
, UOO.UNIT_QUOTA_RESERVED_PLACES UNIT_QUOTA_RESERVED_PLACES
, UOO.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, UOO.GS_VERSION_NUMBER GS_VERSION_NUMBER
, UOO.UNIT_CONTACT UNIT_CONTACT
, UOO.OFFERED_IND OFFERED_IND
, UOO.OWNER_ORG_UNIT_CD
, OU.START_DT
, OU.PARTY_NAME
, UOO.ATTENDANCE_REQUIRED_IND
, UOO.ANON_UNIT_GRADING_IND
, UOO.ANON_ASSESS_GRADING_IND
, UOO.NON_STD_USEC_IND
, UOO.RESERVED_SEATING_ALLOWED
, UOO.SPECIAL_PERMISSION_IND
, UOO.SS_DISPLAY_IND
, UOO.SS_ENROL_IND
, NVL(CPS.ACHIEVABLE_CREDIT_POINTS
, UV.ACHIEVABLE_CREDIT_POINTS) ACHIEVABLE_CREDIT_POINTS
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV.ENROLLED_CREDIT_POINTS) ENROLLED_CREDIT_POINTS
, UOO.DIR_ENROLLMENT
, UOO.ENR_FROM_WLST
, UOO.INQ_NOT_WLST
, UOO.CREATED_BY CREATED_BY
, UOO.CREATION_DATE CREATION_DATE
, UOO.LAST_UPDATED_BY LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, UOO.REQUEST_ID REQUEST_ID
, UOO.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, UOO.PROGRAM_ID PROGRAM_ID
, UOO.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, UOO.REV_ACCOUNT_CD
, UOO.AUDITABLE_IND AUDITABLE_IND
, UOO.AUDIT_PERMISSION_IND AUDIT_PERMISSION_IND
, UOO.NOT_MULTIPLE_SECTION_FLAG NOT_MULTIPLE_SECTION_FLAG
, UOO.SUP_UOO_ID SUP_UOO_ID
, UOO.RELATION_TYPE RELATION_TYPE
, UREL.MEANING RELATION_TYPE_MEANING
, UOO.DEFAULT_ENROLL_FLAG DEFAULT_ENROLL_FLAG
, CI.DESCRIPTION CAL_INST_DESCRIPTION
, CPS.BILLING_HRS
, UOO.ABORT_FLAG ABORT_FLAG
FROM IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_VER UV
, IGS_CA_INST CI
, IGS_AD_LOCATION LOC
, IGS_AS_UNIT_CLASS UC
, IGS_LOOKUP_VALUES US
, IGS_OR_INST_ORG_BASE_V OU
, IGS_PS_USEC_CPS CPS
, IGS_LOOKUP_VALUES UREL
WHERE UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UC.UNIT_CLASS
AND UOO.UNIT_SECTION_STATUS = US.LOOKUP_CODE
AND US.LOOKUP_TYPE = 'UNIT_SECTION_STATUS'
AND OU.INST_ORG_IND(+) = 'O'
AND UOO.OWNER_ORG_UNIT_CD = OU.PARTY_NUMBER(+)
AND UOO.UOO_ID = CPS.UOO_ID(+)
AND UOO.RELATION_TYPE=UREL.LOOKUP_CODE
AND UREL.LOOKUP_TYPE='UOO_RELATION_TYPE'