VIEW: APPS.IGS_PS_UNIT_OFR_OPT

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )