VIEW: APPS.IGS_FI_SCAH_EFFECTIVE_H_CAT_V

Source

View Text - Preformatted

SELECT SEH.person_id, SEH.course_cd, SEH.EFFECTIVE_START_DT, SEH.EFFECTIVE_END_DT, SEH.VERSION_NUMBER, SEH.CAL_TYPE, SEH.LOCATION_CD, SEH.ATTENDANCE_MODE, SEH.ATTENDANCE_TYPE, SEH.STUDENT_CONFIRMED_IND, SEH.COMMENCEMENT_DT, SEH.COURSE_ATTEMPT_STATUS, SEH.DERIVED_ATT_TYPE, SEH.DERIVED_ATT_MODE, SEH.PROVISIONAL_IND, SEH.DISCONTINUED_DT, SEH.DISCONTINUATION_REASON_CD, SEH.FUNDING_SOURCE, SEH.EXAM_LOCATION_CD, SEH.DERIVED_COMPLETION_YR, SEH.DERIVED_COMPLETION_PERD, SEH.NOMINATED_COMPLETION_YR, SEH.NOMINATED_COMPLETION_PERD, SEH.RULE_CHECK_IND, SEH.WAIVE_OPTION_CHECK_IND, SEH.LAST_RULE_CHECK_DT, SEH.PUBLISH_OUTCOMES_IND, SEH.COURSE_RQRMNT_COMPLETE_IND, SEH.OVERRIDE_TIME_LIMITATION, SEH.ADVANCED_STANDING_IND, FCCR.FEE_CAT, SEH.CORRESPONDENCE_CAT, SEH.SELF_HELP_GROUP_IND, SEH.created_by, SEH.creation_date, SEH.last_updated_by, SEH.last_update_date, SEH.last_update_login, FCCR.FEE_CAL_TYPE, FCCR.FEE_CI_SEQUENCE_NUMBER FROM IGS_AS_SCAH_EFFECTIVE_H_V SEH, IGS_FI_F_CAT_CAL_REL FCCR WHERE FCCR.PERSON_ID = SEH.PERSON_ID AND FCCR.COURSE_CD = SEH.COURSE_CD AND FCCR.VERSION_NUMBER = SEH.VERSION_NUMBER

View Text - HTML Formatted

SELECT SEH.PERSON_ID
, SEH.COURSE_CD
, SEH.EFFECTIVE_START_DT
, SEH.EFFECTIVE_END_DT
, SEH.VERSION_NUMBER
, SEH.CAL_TYPE
, SEH.LOCATION_CD
, SEH.ATTENDANCE_MODE
, SEH.ATTENDANCE_TYPE
, SEH.STUDENT_CONFIRMED_IND
, SEH.COMMENCEMENT_DT
, SEH.COURSE_ATTEMPT_STATUS
, SEH.DERIVED_ATT_TYPE
, SEH.DERIVED_ATT_MODE
, SEH.PROVISIONAL_IND
, SEH.DISCONTINUED_DT
, SEH.DISCONTINUATION_REASON_CD
, SEH.FUNDING_SOURCE
, SEH.EXAM_LOCATION_CD
, SEH.DERIVED_COMPLETION_YR
, SEH.DERIVED_COMPLETION_PERD
, SEH.NOMINATED_COMPLETION_YR
, SEH.NOMINATED_COMPLETION_PERD
, SEH.RULE_CHECK_IND
, SEH.WAIVE_OPTION_CHECK_IND
, SEH.LAST_RULE_CHECK_DT
, SEH.PUBLISH_OUTCOMES_IND
, SEH.COURSE_RQRMNT_COMPLETE_IND
, SEH.OVERRIDE_TIME_LIMITATION
, SEH.ADVANCED_STANDING_IND
, FCCR.FEE_CAT
, SEH.CORRESPONDENCE_CAT
, SEH.SELF_HELP_GROUP_IND
, SEH.CREATED_BY
, SEH.CREATION_DATE
, SEH.LAST_UPDATED_BY
, SEH.LAST_UPDATE_DATE
, SEH.LAST_UPDATE_LOGIN
, FCCR.FEE_CAL_TYPE
, FCCR.FEE_CI_SEQUENCE_NUMBER
FROM IGS_AS_SCAH_EFFECTIVE_H_V SEH
, IGS_FI_F_CAT_CAL_REL FCCR
WHERE FCCR.PERSON_ID = SEH.PERSON_ID
AND FCCR.COURSE_CD = SEH.COURSE_CD
AND FCCR.VERSION_NUMBER = SEH.VERSION_NUMBER