VIEW: APPS.IGS_AS_SC_ATTEMPT_H

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.person_id person_id, tab.course_cd course_cd, tab.hist_start_dt hist_start_dt, tab.hist_end_dt hist_end_dt, tab.hist_who hist_who, tab.version_number version_number, tab.cal_type cal_type, tab.location_cd location_cd, tab.attendance_mode attendance_mode, tab.attendance_type attendance_type, tab.student_confirmed_ind student_confirmed_ind, tab.commencement_dt commencement_dt, tab.course_attempt_status course_attempt_status, tab.progression_status progression_status, tab.derived_att_type derived_att_type, tab.derived_att_mode derived_att_mode, tab.provisional_ind provisional_ind, tab.discontinued_dt discontinued_dt, tab.discontinuation_reason_cd discontinuation_reason_cd, tab.lapsed_dt lapsed_dt, tab.funding_source funding_source, tab.fs_description fs_description, tab.exam_location_cd exam_location_cd, tab.elo_description elo_description, tab.derived_completion_yr derived_completion_yr, tab.derived_completion_perd derived_completion_perd, tab.nominated_completion_yr nominated_completion_yr, tab.nominated_completion_perd nominated_completion_perd, tab.rule_check_ind rule_check_ind, tab.waive_option_check_ind waive_option_check_ind, tab.last_rule_check_dt last_rule_check_dt, tab.publish_outcomes_ind publish_outcomes_ind, tab.course_rqrmnt_complete_ind course_rqrmnt_complete_ind, tab.course_rqrmnts_complete_dt course_rqrmnts_complete_dt, tab.s_completed_source_type s_completed_source_type, tab.override_time_limitation override_time_limitation, tab.advanced_standing_ind advanced_standing_ind, tab.fee_cat fee_cat, tab.fc_description fc_description, tab.correspondence_cat correspondence_cat, tab.cc_description cc_description, tab.self_help_group_ind self_help_group_ind, tab.adm_admission_appl_number adm_admission_appl_number, tab.adm_nominated_course_cd adm_nominated_course_cd, tab.adm_sequence_number adm_sequence_number, tab.last_date_of_attendance, tab. dropped_by, 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.org_id org_id, tab.PRIMARY_PROGRAM_TYPE, tab.PRIMARY_PROG_TYPE_SOURCE, tab.CATALOG_CAL_TYPE, tab.CATALOG_SEQ_NUM, tab.KEY_PROGRAM , tab.MANUAL_OVR_CMPL_DT_IND , tab.OVERRIDE_CMPL_DT , TAB.COO_ID ,TAB.IGS_PR_CLASS_STD_ID FROM igs_as_sc_attempt_h_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.PERSON_ID PERSON_ID
, TAB.COURSE_CD COURSE_CD
, TAB.HIST_START_DT HIST_START_DT
, TAB.HIST_END_DT HIST_END_DT
, TAB.HIST_WHO HIST_WHO
, TAB.VERSION_NUMBER VERSION_NUMBER
, TAB.CAL_TYPE CAL_TYPE
, TAB.LOCATION_CD LOCATION_CD
, TAB.ATTENDANCE_MODE ATTENDANCE_MODE
, TAB.ATTENDANCE_TYPE ATTENDANCE_TYPE
, TAB.STUDENT_CONFIRMED_IND STUDENT_CONFIRMED_IND
, TAB.COMMENCEMENT_DT COMMENCEMENT_DT
, TAB.COURSE_ATTEMPT_STATUS COURSE_ATTEMPT_STATUS
, TAB.PROGRESSION_STATUS PROGRESSION_STATUS
, TAB.DERIVED_ATT_TYPE DERIVED_ATT_TYPE
, TAB.DERIVED_ATT_MODE DERIVED_ATT_MODE
, TAB.PROVISIONAL_IND PROVISIONAL_IND
, TAB.DISCONTINUED_DT DISCONTINUED_DT
, TAB.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, TAB.LAPSED_DT LAPSED_DT
, TAB.FUNDING_SOURCE FUNDING_SOURCE
, TAB.FS_DESCRIPTION FS_DESCRIPTION
, TAB.EXAM_LOCATION_CD EXAM_LOCATION_CD
, TAB.ELO_DESCRIPTION ELO_DESCRIPTION
, TAB.DERIVED_COMPLETION_YR DERIVED_COMPLETION_YR
, TAB.DERIVED_COMPLETION_PERD DERIVED_COMPLETION_PERD
, TAB.NOMINATED_COMPLETION_YR NOMINATED_COMPLETION_YR
, TAB.NOMINATED_COMPLETION_PERD NOMINATED_COMPLETION_PERD
, TAB.RULE_CHECK_IND RULE_CHECK_IND
, TAB.WAIVE_OPTION_CHECK_IND WAIVE_OPTION_CHECK_IND
, TAB.LAST_RULE_CHECK_DT LAST_RULE_CHECK_DT
, TAB.PUBLISH_OUTCOMES_IND PUBLISH_OUTCOMES_IND
, TAB.COURSE_RQRMNT_COMPLETE_IND COURSE_RQRMNT_COMPLETE_IND
, TAB.COURSE_RQRMNTS_COMPLETE_DT COURSE_RQRMNTS_COMPLETE_DT
, TAB.S_COMPLETED_SOURCE_TYPE S_COMPLETED_SOURCE_TYPE
, TAB.OVERRIDE_TIME_LIMITATION OVERRIDE_TIME_LIMITATION
, TAB.ADVANCED_STANDING_IND ADVANCED_STANDING_IND
, TAB.FEE_CAT FEE_CAT
, TAB.FC_DESCRIPTION FC_DESCRIPTION
, TAB.CORRESPONDENCE_CAT CORRESPONDENCE_CAT
, TAB.CC_DESCRIPTION CC_DESCRIPTION
, TAB.SELF_HELP_GROUP_IND SELF_HELP_GROUP_IND
, TAB.ADM_ADMISSION_APPL_NUMBER ADM_ADMISSION_APPL_NUMBER
, TAB.ADM_NOMINATED_COURSE_CD ADM_NOMINATED_COURSE_CD
, TAB.ADM_SEQUENCE_NUMBER ADM_SEQUENCE_NUMBER
, TAB.LAST_DATE_OF_ATTENDANCE
, TAB. DROPPED_BY
, 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.ORG_ID ORG_ID
, TAB.PRIMARY_PROGRAM_TYPE
, TAB.PRIMARY_PROG_TYPE_SOURCE
, TAB.CATALOG_CAL_TYPE
, TAB.CATALOG_SEQ_NUM
, TAB.KEY_PROGRAM
, TAB.MANUAL_OVR_CMPL_DT_IND
, TAB.OVERRIDE_CMPL_DT
, TAB.COO_ID
, TAB.IGS_PR_CLASS_STD_ID
FROM IGS_AS_SC_ATTEMPT_H_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)