VIEW: APPS.IGSBV_STUDENT_PRG_AWARD_AIMS

Source

View Text - Preformatted

SELECT SAA.PERSON_ID, HP.PARTY_NUMBER, HP.PARTY_NAME, SAA.COURSE_CD, PV.TITLE, SAA.AWARD_CD, PA.AWARD_TITLE, SAA.START_DT, SAA.END_DT, SAA.COMPLETE_IND, '_LA:COMPLETE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', SAA.CONFERRAL_DATE, SAA.AWARD_MARK, SAA.AWARD_GRADE, SAA.GRADING_SCHEMA_CD, SAA.GS_VERSION_NUMBER, SAA.CREATED_BY, SAA.CREATION_DATE, SAA.LAST_UPDATED_BY, SAA.LAST_UPDATE_DATE FROM IGS_EN_SPA_AWD_AIM SAA, IGS_EN_STDNT_PS_ATT_ALL SPA, HZ_PARTIES HP, IGS_PS_VER_ALL PV, IGS_PS_AWD PA WHERE SAA.AWARD_CD = PA.AWARD_CD AND SAA.PERSON_ID = SPA.PERSON_ID AND SAA.COURSE_CD = SPA.COURSE_CD AND PV.COURSE_CD = SPA.COURSE_CD AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER AND SAA.PERSON_ID = HP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT SAA.PERSON_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, SAA.COURSE_CD
, PV.TITLE
, SAA.AWARD_CD
, PA.AWARD_TITLE
, SAA.START_DT
, SAA.END_DT
, SAA.COMPLETE_IND
, '_LA:COMPLETE_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SAA.CONFERRAL_DATE
, SAA.AWARD_MARK
, SAA.AWARD_GRADE
, SAA.GRADING_SCHEMA_CD
, SAA.GS_VERSION_NUMBER
, SAA.CREATED_BY
, SAA.CREATION_DATE
, SAA.LAST_UPDATED_BY
, SAA.LAST_UPDATE_DATE
FROM IGS_EN_SPA_AWD_AIM SAA
, IGS_EN_STDNT_PS_ATT_ALL SPA
, HZ_PARTIES HP
, IGS_PS_VER_ALL PV
, IGS_PS_AWD PA
WHERE SAA.AWARD_CD = PA.AWARD_CD
AND SAA.PERSON_ID = SPA.PERSON_ID
AND SAA.COURSE_CD = SPA.COURSE_CD
AND PV.COURSE_CD = SPA.COURSE_CD
AND PV.VERSION_NUMBER = SPA.VERSION_NUMBER
AND SAA.PERSON_ID = HP.PARTY_ID WITH READ ONLY