VIEW: APPS.IGSFV_UNIT_OFFERING_OPTIONS

Source

View Text - Preformatted

SELECT UOO.UNIT_CD UNIT_CODE, UOO.VERSION_NUMBER, UOO.CAL_TYPE, UOO.CI_SEQUENCE_NUMBER CAL_INST_SEQUENCE_NUMBER, UOO.LOCATION_CD LOCATION_CODE, UOO.UNIT_CLASS, UOO.IVRS_AVAILABLE_IND IVR_AVAILABLE_INDICATOR, UOO.CALL_NUMBER, '_LA:UNIT_SECTION_STATUS:IGS_LOOKUP_VALUES:UNIT_SECTION_STATUS:MEANING', '_LA:RELATION_TYPE:IGS_LOOKUP_VALUES:UOO_RELATION_TYPE:MEANING', UOO.UNIT_SECTION_START_DATE, UOO.UNIT_SECTION_END_DATE, UOO.ENROLLMENT_ACTUAL, UOO.WAITLIST_ACTUAL, UOO.OFFERED_IND OFFERED_INDICATOR, UOO.STATE_FINANCIAL_AID, UOO.FEDERAL_FINANCIAL_AID, UOO.UNIT_QUOTA, UOO.UNIT_QUOTA_RESERVED_PLACES, UOO.INSTITUTIONAL_FINANCIAL_AID, UOO.GRADING_SCHEMA_PRCDNCE_IND GR_SCHEMA_PRECEDENCE_INDICATOR, UOO.UNIT_CONTACT UNIT_CONTACT_PERSON_ID, UOO.SS_ENROL_IND SELF_SERVICE_ENROL_INDICATOR, UOO.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CODE, UOO.ATTENDANCE_REQUIRED_IND ATTENDANCE_REQUIRED_INDICATOR, UOO.RESERVED_SEATING_ALLOWED, UOO.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_INDICATOR, UOO.SS_DISPLAY_IND SELF_SERVICE_DISPLAY_INDICATOR, UOO.AUDITABLE_IND AUDITABLE_INDICATOR, UOO.AUDIT_PERMISSION_IND AUDIT_PERMISSION_INDICATOR, UOO.NOT_MULTIPLE_SECTION_FLAG NOT_MULTIPLE_SECTION_FLAG, UOO.DEFAULT_ENROLL_FLAG DEFAULT_ENROLL_FLAG, UOO.DIR_ENROLLMENT DIRECT_ENROLLMENT, UOO.ENR_FROM_WLST ENROLLED_FROM_WAITLIST, UOO.INQ_NOT_WLST INQ_NOT_WAITLIST, UOO.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE, UOO.ABORT_FLAG ABORT_FLAG, PSV.TITLE UNIT_DESCRIPTION, CAI.DESCRIPTION CAL_DESCRIPTION, LOC.DESCRIPTION LOCATION_DESCRIPTION, UCL.DESCRIPTION UNIT_CLASS_DESCRIPTION, HP1.PARTY_NAME UNIT_CONTACT_PERSON_NAME, HP.PARTY_NAME OWNER_ORG_UNIT_DESC, IGA.DESCRIPTION REVENUE_ACCOUNT_DESC, UOO.ANON_UNIT_GRADING_IND ANON_UNIT_GRADING_INDICATOR, UOO.ANON_ASSESS_GRADING_IND ANON_ASSESS_GRADING_INDICATOR, UOO.NON_STD_USEC_IND NON_STANDARD_USEC_INDICATOR, UOO.UOO_ID UNIT_SECTION_ID, UOO.SUP_UOO_ID SUPERIOR_UNIT_SECTION_ID, UOO.CREATED_BY, UOO.CREATION_DATE, UOO.LAST_UPDATED_BY, UOO.LAST_UPDATE_DATE FROM IGS_PS_UNIT_OFR_OPT_ALL UOO, IGS_PS_UNIT_VER_ALL PSV, IGS_CA_INST_ALL CAI, IGS_AD_LOCATION_ALL LOC, IGS_AS_UNIT_CLASS_ALL UCL, IGS_FI_ACC_ALL IGA, IGS_OR_INST_ORG_BASE_V HP, HZ_PARTIES HP1 WHERE UOO.CAL_TYPE = CAI.CAL_TYPE AND UOO.CI_SEQUENCE_NUMBER = CAI.SEQUENCE_NUMBER AND UOO.UNIT_CD = PSV.UNIT_CD AND UOO.VERSION_NUMBER = PSV.VERSION_NUMBER AND UOO.LOCATION_CD = LOC.LOCATION_CD AND UOO.UNIT_CLASS = UCL.UNIT_CLASS AND UOO.REV_ACCOUNT_CD = IGA.ACCOUNT_CD (+) AND UOO.OWNER_ORG_UNIT_CD = HP.PARTY_NUMBER AND UOO.UNIT_CONTACT = HP1.PARTY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT UOO.UNIT_CD UNIT_CODE
, UOO.VERSION_NUMBER
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER CAL_INST_SEQUENCE_NUMBER
, UOO.LOCATION_CD LOCATION_CODE
, UOO.UNIT_CLASS
, UOO.IVRS_AVAILABLE_IND IVR_AVAILABLE_INDICATOR
, UOO.CALL_NUMBER
, '_LA:UNIT_SECTION_STATUS:IGS_LOOKUP_VALUES:UNIT_SECTION_STATUS:MEANING'
, '_LA:RELATION_TYPE:IGS_LOOKUP_VALUES:UOO_RELATION_TYPE:MEANING'
, UOO.UNIT_SECTION_START_DATE
, UOO.UNIT_SECTION_END_DATE
, UOO.ENROLLMENT_ACTUAL
, UOO.WAITLIST_ACTUAL
, UOO.OFFERED_IND OFFERED_INDICATOR
, UOO.STATE_FINANCIAL_AID
, UOO.FEDERAL_FINANCIAL_AID
, UOO.UNIT_QUOTA
, UOO.UNIT_QUOTA_RESERVED_PLACES
, UOO.INSTITUTIONAL_FINANCIAL_AID
, UOO.GRADING_SCHEMA_PRCDNCE_IND GR_SCHEMA_PRECEDENCE_INDICATOR
, UOO.UNIT_CONTACT UNIT_CONTACT_PERSON_ID
, UOO.SS_ENROL_IND SELF_SERVICE_ENROL_INDICATOR
, UOO.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CODE
, UOO.ATTENDANCE_REQUIRED_IND ATTENDANCE_REQUIRED_INDICATOR
, UOO.RESERVED_SEATING_ALLOWED
, UOO.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_INDICATOR
, UOO.SS_DISPLAY_IND SELF_SERVICE_DISPLAY_INDICATOR
, UOO.AUDITABLE_IND AUDITABLE_INDICATOR
, UOO.AUDIT_PERMISSION_IND AUDIT_PERMISSION_INDICATOR
, UOO.NOT_MULTIPLE_SECTION_FLAG NOT_MULTIPLE_SECTION_FLAG
, UOO.DEFAULT_ENROLL_FLAG DEFAULT_ENROLL_FLAG
, UOO.DIR_ENROLLMENT DIRECT_ENROLLMENT
, UOO.ENR_FROM_WLST ENROLLED_FROM_WAITLIST
, UOO.INQ_NOT_WLST INQ_NOT_WAITLIST
, UOO.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, UOO.ABORT_FLAG ABORT_FLAG
, PSV.TITLE UNIT_DESCRIPTION
, CAI.DESCRIPTION CAL_DESCRIPTION
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, UCL.DESCRIPTION UNIT_CLASS_DESCRIPTION
, HP1.PARTY_NAME UNIT_CONTACT_PERSON_NAME
, HP.PARTY_NAME OWNER_ORG_UNIT_DESC
, IGA.DESCRIPTION REVENUE_ACCOUNT_DESC
, UOO.ANON_UNIT_GRADING_IND ANON_UNIT_GRADING_INDICATOR
, UOO.ANON_ASSESS_GRADING_IND ANON_ASSESS_GRADING_INDICATOR
, UOO.NON_STD_USEC_IND NON_STANDARD_USEC_INDICATOR
, UOO.UOO_ID UNIT_SECTION_ID
, UOO.SUP_UOO_ID SUPERIOR_UNIT_SECTION_ID
, UOO.CREATED_BY
, UOO.CREATION_DATE
, UOO.LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE
FROM IGS_PS_UNIT_OFR_OPT_ALL UOO
, IGS_PS_UNIT_VER_ALL PSV
, IGS_CA_INST_ALL CAI
, IGS_AD_LOCATION_ALL LOC
, IGS_AS_UNIT_CLASS_ALL UCL
, IGS_FI_ACC_ALL IGA
, IGS_OR_INST_ORG_BASE_V HP
, HZ_PARTIES HP1
WHERE UOO.CAL_TYPE = CAI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CAI.SEQUENCE_NUMBER
AND UOO.UNIT_CD = PSV.UNIT_CD
AND UOO.VERSION_NUMBER = PSV.VERSION_NUMBER
AND UOO.LOCATION_CD = LOC.LOCATION_CD
AND UOO.UNIT_CLASS = UCL.UNIT_CLASS
AND UOO.REV_ACCOUNT_CD = IGA.ACCOUNT_CD (+)
AND UOO.OWNER_ORG_UNIT_CD = HP.PARTY_NUMBER
AND UOO.UNIT_CONTACT = HP1.PARTY_ID (+) WITH READ ONLY