View: IGS_PS_UNIT_OFR_OPT

View Text

SELECT TAB.ROWID ROW_ID
, TAB.UNIT_CD UNIT_CD
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.CAL_TYPE CAL_TYPE
, TAB.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, TAB.LOCATION_CD LOCATION_CD
, TAB.UNIT_CLASS UNIT_CLASS
, TAB.UOO_ID UOO_ID
, TAB.IVRS_AVAILABLE_IND IVRS_AVAILABLE_IND
, TAB.OFFERED_IND OFFERED_IND
, TAB.GRADING_SCHEMA_PRCDNCE_IND GRADING_SCHEMA_PRCDNCE_IND
, TAB.UNIT_QUOTA UNIT_QUOTA
, TAB.UNIT_QUOTA_RESERVED_PLACES UNIT_QUOTA_RESERVED_PLACES
, TAB.UNIT_CONTACT UNIT_CONTACT
, TAB.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, TAB.GS_VERSION_NUMBER GS_VERSION_NUMBER
, TAB.CALL_NUMBER CALL_NUMBER
, TAB.UNIT_SECTION_STATUS UNIT_SECTION_STATUS
, TAB.UNIT_SECTION_START_DATE UNIT_SECTION_START_DATE
, TAB.UNIT_SECTION_END_DATE UNIT_SECTION_END_DATE
, TAB.ENROLLMENT_ACTUAL ENROLLMENT_ACTUAL
, TAB.WAITLIST_ACTUAL WAITLIST_ACTUAL
, TAB.STATE_FINANCIAL_AID STATE_FINANCIAL_AID
, TAB.FEDERAL_FINANCIAL_AID FEDERAL_FINANCIAL_AID
, TAB.INSTITUTIONAL_FINANCIAL_AID INSTITUTIONAL_FINANCIAL_AID
, TAB.OWNER_ORG_UNIT_CD OWNER_ORG_UNIT_CD
, TAB.ATTENDANCE_REQUIRED_IND ATTENDANCE_REQUIRED_IND
, TAB.NON_STD_USEC_IND
, TAB.RESERVED_SEATING_ALLOWED RESERVED_SEATING_ALLOWED
, TAB.SPECIAL_PERMISSION_IND SPECIAL_PERMISSION_IND
, TAB.SS_DISPLAY_IND SS_DISPLAY_IND
, TAB.SS_ENROL_IND SS_ENROL_IND
, TAB.DIR_ENROLLMENT
, TAB.ENR_FROM_WLST
, TAB.INQ_NOT_WLST
, TAB.REV_ACCOUNT_CD REV_ACCOUNT_CD
, TAB.ANON_UNIT_GRADING_IND
, TAB.ANON_ASSESS_GRADING_IND
, TAB.CREATED_BY CREATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.ORG_ID ORG_ID
, TAB.AUDITABLE_IND AUDITABLE_IND
, TAB.AUDIT_PERMISSION_IND AUDIT_PERMISSION_IND
, TAB.NOT_MULTIPLE_SECTION_FLAG NOT_MULTIPLE_SECTION_FLAG
, TAB.SUP_UOO_ID SUP_UOO_ID
, TAB.RELATION_TYPE RELATION_TYPE
, TAB.DEFAULT_ENROLL_FLAG DEFAULT_ENROLL_FLAG
, TAB.ABORT_FLAG ABORT_FLAG
FROM IGS_PS_UNIT_OFR_OPT_ALL TAB
WHERE NVL (TAB.ORG_ID
, NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB ( USERENV ( 'CLIENT_INFO' )
, 1
, 10 ) ) )
, -99 ) ) = NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ( 'CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB ( USERENV ( 'CLIENT_INFO' )
, 1
, 10 ) ) )
, -99 )

Columns