VIEW: APPS.IGSFV_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,GSG.FULL_GRADE_NAME,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, IGS_AS_GRD_SCH_GRADE GSG, IGS_AS_GRD_SCHEMA GS 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 AND SAA.AWARD_GRADE = GSG.GRADE (+) AND SAA.GRADING_SCHEMA_CD = GSG.GRADING_SCHEMA_CD (+) AND SAA.GS_VERSION_NUMBER = GSG.VERSION_NUMBER (+) AND SAA.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD (+) AND SAA.GS_VERSION_NUMBER = GS.VERSION_NUMBER (+) 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
, GSG.FULL_GRADE_NAME
, 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
, IGS_AS_GRD_SCH_GRADE GSG
, IGS_AS_GRD_SCHEMA GS
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
AND SAA.AWARD_GRADE = GSG.GRADE (+)
AND SAA.GRADING_SCHEMA_CD = GSG.GRADING_SCHEMA_CD (+)
AND SAA.GS_VERSION_NUMBER = GSG.VERSION_NUMBER (+)
AND SAA.GRADING_SCHEMA_CD = GS.GRADING_SCHEMA_CD (+)
AND SAA.GS_VERSION_NUMBER = GS.VERSION_NUMBER (+) WITH READ ONLY