VIEW: APPS.IGS_SC_COURSE_DTLS_SV

Source

View Text - Preformatted

SELECT APP.PERSON_ID, PS.RESPONSIBLE_ORG_UNIT_CD, PS.COURSE_TYPE, PS.COURSE_CD, PS.VERSION_NUMBER FROM IGS_PS_VER_ALL PS, IGS_AD_PS_APPL_INST_ALL APP WHERE PS.COURSE_CD = APP.COURSE_CD AND PS.VERSION_NUMBER = APP.CRV_VERSION_NUMBER UNION ALL SELECT SUA.PERSON_ID, PS.RESPONSIBLE_ORG_UNIT_CD, PS.COURSE_TYPE, PS.COURSE_CD, PS.VERSION_NUMBER FROM IGS_PS_VER_ALL PS, IGS_EN_STDNT_PS_ATT_ALL SUA WHERE PS.COURSE_CD = SUA.COURSE_CD AND PS.VERSION_NUMBER = SUA.VERSION_NUMBER

View Text - HTML Formatted

SELECT APP.PERSON_ID
, PS.RESPONSIBLE_ORG_UNIT_CD
, PS.COURSE_TYPE
, PS.COURSE_CD
, PS.VERSION_NUMBER
FROM IGS_PS_VER_ALL PS
, IGS_AD_PS_APPL_INST_ALL APP
WHERE PS.COURSE_CD = APP.COURSE_CD
AND PS.VERSION_NUMBER = APP.CRV_VERSION_NUMBER UNION ALL SELECT SUA.PERSON_ID
, PS.RESPONSIBLE_ORG_UNIT_CD
, PS.COURSE_TYPE
, PS.COURSE_CD
, PS.VERSION_NUMBER
FROM IGS_PS_VER_ALL PS
, IGS_EN_STDNT_PS_ATT_ALL SUA
WHERE PS.COURSE_CD = SUA.COURSE_CD
AND PS.VERSION_NUMBER = SUA.VERSION_NUMBER