VIEW: APPS.IGS_PR_STD_PRG_AWD_AIM_V

Source

View Text - Preformatted

SELECT SCA.ROWID, SCA.PERSON_ID, PE.PARTY_NUMBER, SCA.COURSE_CD, SCA.VERSION_NUMBER, SCA.COURSE_CD || '/' || SCA.VERSION_NUMBER, SPA.AWARD_CD, PE.PARTY_NAME, CRV.COURSE_TYPE, SUSA.UNIT_SET_CD, SUSA.US_VERSION_NUMBER, SCA.CREATED_BY, SCA.CREATION_DATE, SCA.LAST_UPDATED_BY, SCA.LAST_UPDATE_DATE, SCA.LAST_UPDATE_LOGIN, SPA.START_DT, SPA.END_DT, SPA.AWARD_MARK, SPA.AWARD_GRADE, SPA.GRADING_SCHEMA_CD, SPA.GS_VERSION_NUMBER, SCA.COURSE_RQRMNT_COMPLETE_IND, SPA.COMPLETE_IND, SPA.CONFERRAL_DATE FROM HZ_PARTIES PE, IGS_EN_STDNT_PS_ATT_SV SCA, IGS_EN_SPA_AWD_AIM_V SPA, IGS_PS_VER CRV, IGS_AS_SU_SETATMPT SUSA WHERE SCA.PERSON_ID = SPA.PERSON_ID(+) AND SCA.COURSE_CD = SPA.COURSE_CD(+) AND SCA.PERSON_ID = PE.PARTY_ID AND SCA.COURSE_CD = CRV.COURSE_CD AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER AND SUSA.PERSON_ID (+) = SCA.PERSON_ID AND SUSA.COURSE_CD (+) = SCA.COURSE_CD AND SUSA.STUDENT_CONFIRMED_IND (+) = 'Y' AND SUSA.END_DT (+) IS NULL AND SCA.COURSE_ATTEMPT_STATUS IN ('INACTIVE', 'ENROLLED', 'COMPLETED')

View Text - HTML Formatted

SELECT SCA.ROWID
, SCA.PERSON_ID
, PE.PARTY_NUMBER
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, SCA.COURSE_CD || '/' || SCA.VERSION_NUMBER
, SPA.AWARD_CD
, PE.PARTY_NAME
, CRV.COURSE_TYPE
, SUSA.UNIT_SET_CD
, SUSA.US_VERSION_NUMBER
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
, SPA.START_DT
, SPA.END_DT
, SPA.AWARD_MARK
, SPA.AWARD_GRADE
, SPA.GRADING_SCHEMA_CD
, SPA.GS_VERSION_NUMBER
, SCA.COURSE_RQRMNT_COMPLETE_IND
, SPA.COMPLETE_IND
, SPA.CONFERRAL_DATE
FROM HZ_PARTIES PE
, IGS_EN_STDNT_PS_ATT_SV SCA
, IGS_EN_SPA_AWD_AIM_V SPA
, IGS_PS_VER CRV
, IGS_AS_SU_SETATMPT SUSA
WHERE SCA.PERSON_ID = SPA.PERSON_ID(+)
AND SCA.COURSE_CD = SPA.COURSE_CD(+)
AND SCA.PERSON_ID = PE.PARTY_ID
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUSA.PERSON_ID (+) = SCA.PERSON_ID
AND SUSA.COURSE_CD (+) = SCA.COURSE_CD
AND SUSA.STUDENT_CONFIRMED_IND (+) = 'Y'
AND SUSA.END_DT (+) IS NULL
AND SCA.COURSE_ATTEMPT_STATUS IN ('INACTIVE'
, 'ENROLLED'
, 'COMPLETED')