VIEW: APPS.IGS_DA_XML_ORIGINALCOURSE_V

Source

View Text - Preformatted

SELECT IGS_DA_XML_PKG.GET_COURSE_ABBR_NUM(adtu.unit, 'A'), IGS_DA_XML_PKG.GET_COURSE_ABBR_NUM(adtu.unit, 'N'), adtu.unit_name, adtd.term, adtu.cp_attempted, adtu.cp_earned, decode(adtu.cp_earned, TO_NUMBER(''), TO_NUMBER(''), adtu.cp_earned), adtu.unit_grade_points, adtu.grade, '', 'N', '', '', '', dr.batch_id, asu.person_id, asu.EXEMPTION_INSTITUTION_CD, asu.av_stnd_unit_id from IGS_AD_TERM_DETAILS adtd, IGS_AD_TERM_UNITDTLS adtu, igs_av_stnd_unit_all asu, igs_da_rqst dr WHERE asu.unit_details_id = adtu.unit_details_id and adtd.TERM_DETAILS_ID = adtu.TERM_DETAILS_ID

View Text - HTML Formatted

SELECT IGS_DA_XML_PKG.GET_COURSE_ABBR_NUM(ADTU.UNIT
, 'A')
, IGS_DA_XML_PKG.GET_COURSE_ABBR_NUM(ADTU.UNIT
, 'N')
, ADTU.UNIT_NAME
, ADTD.TERM
, ADTU.CP_ATTEMPTED
, ADTU.CP_EARNED
, DECODE(ADTU.CP_EARNED
, TO_NUMBER('')
, TO_NUMBER('')
, ADTU.CP_EARNED)
, ADTU.UNIT_GRADE_POINTS
, ADTU.GRADE
, ''
, 'N'
, ''
, ''
, ''
, DR.BATCH_ID
, ASU.PERSON_ID
, ASU.EXEMPTION_INSTITUTION_CD
, ASU.AV_STND_UNIT_ID
FROM IGS_AD_TERM_DETAILS ADTD
, IGS_AD_TERM_UNITDTLS ADTU
, IGS_AV_STND_UNIT_ALL ASU
, IGS_DA_RQST DR
WHERE ASU.UNIT_DETAILS_ID = ADTU.UNIT_DETAILS_ID
AND ADTD.TERM_DETAILS_ID = ADTU.TERM_DETAILS_ID