VIEW: APPS.IGS_UC_IVSTARC_V

Source

View Text - Preformatted

SELECT ucas.APPNO, ucas.CHOICENO, ucas.TIMESTAMP, ucas.LASTCHANGE, ucas.INST, ucas.COURSE, ucas.CAMPUS, ucas.FACULTY, ucas.HOME, ucas.DECISION, ucas.DECISIONDATE, ucas.DECISIONNUMBER, ucas.REPLY, ucas.SUMMARYCONDITIONS, ucas.ENTRYMONTH, ucas.ENTRYYEAR, ucas.ENTRYPOINT, ucas.CHOICECANCELLED, ucas.ACTION, ucas.SUBSTITUTION, ucas.DATESUBSTITUTED, ucas.PREVIOUSINST, ucas.PREVIOUSCOURSE, ucas.PREVIOUSCAMPUS, ucas.UCASAMENDMENT, ucas.ROUTEBPREF, ucas.ROUTEBROUND, ucas.EXTRAROUND, ssys.RESIDENTIAL FROM IGS_UC_MV_IVSTARC ucas, IGS_UC_SS_IVSTARC ssys WHERE ucas.APPNO = ssys.APPNO AND ucas.CHOICENO = ssys.CHOICENO UNION ALL SELECT ucas.APPNO, ucas.CHOICENO, ucas.TIMESTAMP, ucas.LASTCHANGE, ucas.INST, ucas.COURSE, ucas.CAMPUS, ucas.FACULTY, ucas.HOME, ucas.DECISION, ucas.DECISIONDATE, ucas.DECISIONNUMBER, ucas.REPLY, ucas.SUMMARYCONDITIONS, ucas.ENTRYMONTH, ucas.ENTRYYEAR, ucas.ENTRYPOINT, ucas.CHOICECANCELLED, ucas.ACTION, ucas.SUBSTITUTION, ucas.DATESUBSTITUTED, ucas.PREVIOUSINST, ucas.PREVIOUSCOURSE, ucas.PREVIOUSCAMPUS, ucas.UCASAMENDMENT, ucas.ROUTEBPREF, ucas.ROUTEBROUND, ucas.EXTRAROUND, NULL FROM IGS_UC_MV_IVSTARC ucas WHERE NOT EXISTS (SELECT 1 FROM IGS_UC_SS_IVSTARC ssys WHERE ucas.APPNO = ssys.APPNO AND ucas.CHOICENO = ssys.CHOICENO )

View Text - HTML Formatted

SELECT UCAS.APPNO
, UCAS.CHOICENO
, UCAS.TIMESTAMP
, UCAS.LASTCHANGE
, UCAS.INST
, UCAS.COURSE
, UCAS.CAMPUS
, UCAS.FACULTY
, UCAS.HOME
, UCAS.DECISION
, UCAS.DECISIONDATE
, UCAS.DECISIONNUMBER
, UCAS.REPLY
, UCAS.SUMMARYCONDITIONS
, UCAS.ENTRYMONTH
, UCAS.ENTRYYEAR
, UCAS.ENTRYPOINT
, UCAS.CHOICECANCELLED
, UCAS.ACTION
, UCAS.SUBSTITUTION
, UCAS.DATESUBSTITUTED
, UCAS.PREVIOUSINST
, UCAS.PREVIOUSCOURSE
, UCAS.PREVIOUSCAMPUS
, UCAS.UCASAMENDMENT
, UCAS.ROUTEBPREF
, UCAS.ROUTEBROUND
, UCAS.EXTRAROUND
, SSYS.RESIDENTIAL
FROM IGS_UC_MV_IVSTARC UCAS
, IGS_UC_SS_IVSTARC SSYS
WHERE UCAS.APPNO = SSYS.APPNO
AND UCAS.CHOICENO = SSYS.CHOICENO UNION ALL SELECT UCAS.APPNO
, UCAS.CHOICENO
, UCAS.TIMESTAMP
, UCAS.LASTCHANGE
, UCAS.INST
, UCAS.COURSE
, UCAS.CAMPUS
, UCAS.FACULTY
, UCAS.HOME
, UCAS.DECISION
, UCAS.DECISIONDATE
, UCAS.DECISIONNUMBER
, UCAS.REPLY
, UCAS.SUMMARYCONDITIONS
, UCAS.ENTRYMONTH
, UCAS.ENTRYYEAR
, UCAS.ENTRYPOINT
, UCAS.CHOICECANCELLED
, UCAS.ACTION
, UCAS.SUBSTITUTION
, UCAS.DATESUBSTITUTED
, UCAS.PREVIOUSINST
, UCAS.PREVIOUSCOURSE
, UCAS.PREVIOUSCAMPUS
, UCAS.UCASAMENDMENT
, UCAS.ROUTEBPREF
, UCAS.ROUTEBROUND
, UCAS.EXTRAROUND
, NULL
FROM IGS_UC_MV_IVSTARC UCAS
WHERE NOT EXISTS (SELECT 1
FROM IGS_UC_SS_IVSTARC SSYS
WHERE UCAS.APPNO = SSYS.APPNO
AND UCAS.CHOICENO = SSYS.CHOICENO )