View: IGS_PS_UNIT_OFR_OPT_V

View Text

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'

Columns