VIEW: APPS.IGS_UC_IVSTARK_2003

Source

View Text - Preformatted

SELECT appno ,sysdate timestamp ,applicationdate ,sentdate ,runsent ,codedchangedate ,school ,rescat ,feelevel ,feepayer ,feetext ,apr ,lea ,countrybirth ,nationality ,dualnationality ,withdrawn ,withdrawndate ,routeb ,examchangedate ,alevels ,aslevels ,highers ,csys ,gce ,vce ,sqa ,winter ,previousa ,previousas ,keyskills ,vocational ,gnvq ,btec ,ilc ,aice ,ib ,manual ,regno ,scn ,oeq ,prevoeq ,eas ,roa ,specialneeds ,criminalconv ,ukentrydate ,status ,firmnow ,firmreply ,insurancereply ,confhistfirmreply ,confhistinsurancereply ,choicesalltransparent ,extrastatus ,extrapassportno FROM IGS_UC_ISTARK_INTS WHERE 1 = 2

View Text - HTML Formatted

SELECT APPNO
, SYSDATE TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, SCHOOL
, RESCAT
, FEELEVEL
, FEEPAYER
, FEETEXT
, APR
, LEA
, COUNTRYBIRTH
, NATIONALITY
, DUALNATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, ROUTEB
, EXAMCHANGEDATE
, ALEVELS
, ASLEVELS
, HIGHERS
, CSYS
, GCE
, VCE
, SQA
, WINTER
, PREVIOUSA
, PREVIOUSAS
, KEYSKILLS
, VOCATIONAL
, GNVQ
, BTEC
, ILC
, AICE
, IB
, MANUAL
, REGNO
, SCN
, OEQ
, PREVOEQ
, EAS
, ROA
, SPECIALNEEDS
, CRIMINALCONV
, UKENTRYDATE
, STATUS
, FIRMNOW
, FIRMREPLY
, INSURANCEREPLY
, CONFHISTFIRMREPLY
, CONFHISTINSURANCEREPLY
, CHOICESALLTRANSPARENT
, EXTRASTATUS
, EXTRAPASSPORTNO
FROM IGS_UC_ISTARK_INTS
WHERE 1 = 2