VIEW: APPS.IGS_EN_SPAA_V

Source

View Text - Preformatted

SELECT sca.rowid , sca.person_id , p.person_number , p.full_name , sca.course_cd , sca.version_number , p.api_person_id , pv.title course_title , sca.course_cd || ' '|| sca.version_number course_cd_version , spaaa.award_cd , spaaa.description , sca.created_by , sca.creation_date , sca.last_updated_by , sca.last_update_date , sca.last_update_login FROM igs_en_stdnt_ps_att_SV sca, igs_pe_person_v p, igs_ps_ver_all pv, igs_en_spa_awd_aim_v spaaa WHERE sca.person_id = p.person_id AND sca.course_cd = pv.course_cd AND sca.version_number = pv.version_number AND sca.person_id = spaaa.person_id AND sca.course_cd = spaaa.course_cd

View Text - HTML Formatted

SELECT SCA.ROWID
, SCA.PERSON_ID
, P.PERSON_NUMBER
, P.FULL_NAME
, SCA.COURSE_CD
, SCA.VERSION_NUMBER
, P.API_PERSON_ID
, PV.TITLE COURSE_TITLE
, SCA.COURSE_CD || ' '|| SCA.VERSION_NUMBER COURSE_CD_VERSION
, SPAAA.AWARD_CD
, SPAAA.DESCRIPTION
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNT_PS_ATT_SV SCA
, IGS_PE_PERSON_V P
, IGS_PS_VER_ALL PV
, IGS_EN_SPA_AWD_AIM_V SPAAA
WHERE SCA.PERSON_ID = P.PERSON_ID
AND SCA.COURSE_CD = PV.COURSE_CD
AND SCA.VERSION_NUMBER = PV.VERSION_NUMBER
AND SCA.PERSON_ID = SPAAA.PERSON_ID
AND SCA.COURSE_CD = SPAAA.COURSE_CD