VIEW: APPS.IGS_UC_IVSTARK_V

Source

View Text - Preformatted

SELECT ucas.APPNO, ucas.TIMESTAMP, ucas.APPLICATIONDATE, ucas.SENTDATE, ucas.RUNSENT, ucas.CODEDCHANGEDATE, ucas.SCHOOL, ucas.RESCAT, ucas.FEELEVEL, ucas.FEEPAYER, ucas.FEETEXT, ucas.APR, ucas.COUNTRYBIRTH, ucas.NATIONALITY, ucas.DUALNATIONALITY, ucas.WITHDRAWN, ucas.WITHDRAWNDATE, ucas.ROUTEB, ucas.EXAMCHANGEDATE, ucas.GCE, ucas.VCE, ucas.SQA, ucas.WINTER, ucas.PREVIOUSA, ucas.PREVIOUSAS, ucas.KEYSKILLS, ucas.VOCATIONAL, ucas.BTEC, ucas.ILC, ucas.AICE, ucas.IB, ucas.MANUAL, ucas.REGNO, ucas.SCN, ucas.OEQ, ucas.PREVOEQ, ucas.EAS, ucas.ROA, ucas.SPECIALNEEDS, ucas.CRIMINALCONV, ucas.UKENTRYDATE, ucas.STATUS, ucas.FIRMNOW, ucas.FIRMREPLY, ucas.INSURANCEREPLY, ucas.CONFHISTFIRMREPLY, ucas.CONFHISTINSURANCEREPLY, ucas.CHOICESALLTRANSPARENT, ucas.EXTRASTATUS, ucas.EXTRAPASSPORTNO, ssys.WELSHSPEAKER, ssys.NINUMBER, ssys.EARLIESTSTART, ssys.NEARINST, ssys.PREFREG, ssys.QUALENG, ssys.QUALMATH, ssys.QUALSCI, ssys.MAINQUAL, ssys.QUAL5 FROM IGS_UC_MV_IVSTARK ucas, IGS_UC_SS_IVSTARK ssys WHERE ucas.APPNO = ssys.APPNO UNION ALL SELECT ucas.APPNO, ucas.TIMESTAMP, ucas.APPLICATIONDATE, ucas.SENTDATE, ucas.RUNSENT, ucas.CODEDCHANGEDATE, ucas.SCHOOL, ucas.RESCAT, ucas.FEELEVEL, ucas.FEEPAYER, ucas.FEETEXT, ucas.APR, ucas.COUNTRYBIRTH, ucas.NATIONALITY, ucas.DUALNATIONALITY, ucas.WITHDRAWN, ucas.WITHDRAWNDATE, ucas.ROUTEB, ucas.EXAMCHANGEDATE, ucas.GCE, ucas.VCE, ucas.SQA, ucas.WINTER, ucas.PREVIOUSA, ucas.PREVIOUSAS, ucas.KEYSKILLS, ucas.VOCATIONAL, ucas.BTEC, ucas.ILC, ucas.AICE, ucas.IB, ucas.MANUAL, ucas.REGNO, ucas.SCN, ucas.OEQ, ucas.PREVOEQ, ucas.EAS, ucas.ROA, ucas.SPECIALNEEDS, ucas.CRIMINALCONV, ucas.UKENTRYDATE, ucas.STATUS, ucas.FIRMNOW, ucas.FIRMREPLY, ucas.INSURANCEREPLY, ucas.CONFHISTFIRMREPLY, ucas.CONFHISTINSURANCEREPLY, ucas.CHOICESALLTRANSPARENT, ucas.EXTRASTATUS, ucas.EXTRAPASSPORTNO, NULL, NULL, NULL, NULL, TO_NUMBER(NULL), NULL, NULL, NULL, NULL, NULL FROM IGS_UC_MV_IVSTARK ucas WHERE NOT EXISTS ( SELECT 1 FROM IGS_UC_SS_IVSTARK ssys WHERE ucas.APPNO = ssys.APPNO )

View Text - HTML Formatted

SELECT UCAS.APPNO
, UCAS.TIMESTAMP
, UCAS.APPLICATIONDATE
, UCAS.SENTDATE
, UCAS.RUNSENT
, UCAS.CODEDCHANGEDATE
, UCAS.SCHOOL
, UCAS.RESCAT
, UCAS.FEELEVEL
, UCAS.FEEPAYER
, UCAS.FEETEXT
, UCAS.APR
, UCAS.COUNTRYBIRTH
, UCAS.NATIONALITY
, UCAS.DUALNATIONALITY
, UCAS.WITHDRAWN
, UCAS.WITHDRAWNDATE
, UCAS.ROUTEB
, UCAS.EXAMCHANGEDATE
, UCAS.GCE
, UCAS.VCE
, UCAS.SQA
, UCAS.WINTER
, UCAS.PREVIOUSA
, UCAS.PREVIOUSAS
, UCAS.KEYSKILLS
, UCAS.VOCATIONAL
, UCAS.BTEC
, UCAS.ILC
, UCAS.AICE
, UCAS.IB
, UCAS.MANUAL
, UCAS.REGNO
, UCAS.SCN
, UCAS.OEQ
, UCAS.PREVOEQ
, UCAS.EAS
, UCAS.ROA
, UCAS.SPECIALNEEDS
, UCAS.CRIMINALCONV
, UCAS.UKENTRYDATE
, UCAS.STATUS
, UCAS.FIRMNOW
, UCAS.FIRMREPLY
, UCAS.INSURANCEREPLY
, UCAS.CONFHISTFIRMREPLY
, UCAS.CONFHISTINSURANCEREPLY
, UCAS.CHOICESALLTRANSPARENT
, UCAS.EXTRASTATUS
, UCAS.EXTRAPASSPORTNO
, SSYS.WELSHSPEAKER
, SSYS.NINUMBER
, SSYS.EARLIESTSTART
, SSYS.NEARINST
, SSYS.PREFREG
, SSYS.QUALENG
, SSYS.QUALMATH
, SSYS.QUALSCI
, SSYS.MAINQUAL
, SSYS.QUAL5
FROM IGS_UC_MV_IVSTARK UCAS
, IGS_UC_SS_IVSTARK SSYS
WHERE UCAS.APPNO = SSYS.APPNO UNION ALL SELECT UCAS.APPNO
, UCAS.TIMESTAMP
, UCAS.APPLICATIONDATE
, UCAS.SENTDATE
, UCAS.RUNSENT
, UCAS.CODEDCHANGEDATE
, UCAS.SCHOOL
, UCAS.RESCAT
, UCAS.FEELEVEL
, UCAS.FEEPAYER
, UCAS.FEETEXT
, UCAS.APR
, UCAS.COUNTRYBIRTH
, UCAS.NATIONALITY
, UCAS.DUALNATIONALITY
, UCAS.WITHDRAWN
, UCAS.WITHDRAWNDATE
, UCAS.ROUTEB
, UCAS.EXAMCHANGEDATE
, UCAS.GCE
, UCAS.VCE
, UCAS.SQA
, UCAS.WINTER
, UCAS.PREVIOUSA
, UCAS.PREVIOUSAS
, UCAS.KEYSKILLS
, UCAS.VOCATIONAL
, UCAS.BTEC
, UCAS.ILC
, UCAS.AICE
, UCAS.IB
, UCAS.MANUAL
, UCAS.REGNO
, UCAS.SCN
, UCAS.OEQ
, UCAS.PREVOEQ
, UCAS.EAS
, UCAS.ROA
, UCAS.SPECIALNEEDS
, UCAS.CRIMINALCONV
, UCAS.UKENTRYDATE
, UCAS.STATUS
, UCAS.FIRMNOW
, UCAS.FIRMREPLY
, UCAS.INSURANCEREPLY
, UCAS.CONFHISTFIRMREPLY
, UCAS.CONFHISTINSURANCEREPLY
, UCAS.CHOICESALLTRANSPARENT
, UCAS.EXTRASTATUS
, UCAS.EXTRAPASSPORTNO
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
FROM IGS_UC_MV_IVSTARK UCAS
WHERE NOT EXISTS ( SELECT 1
FROM IGS_UC_SS_IVSTARK SSYS
WHERE UCAS.APPNO = SSYS.APPNO )