DBA Data[Home] [Help]

VIEW: APPS.IGS_UC_IVNSTARK_2006

Source

View Text - Preformatted

SELECT appno ,sysdate timestamp ,applicationdate ,sentdate ,runsent ,codedchangedate ,rescat ,feelevel ,apr ,countrybirth ,nationality ,withdrawn ,withdrawndate ,qualeng qualenglish ,qualmath qualmaths ,qualsci qualscience ,qual5 qual5point ,mainqual qualmain ,ninumber nationalinsurance ,earlieststart startdate ,nearinst nearestinst ,prefreg prefregion ,specialneeds ,status ,firmnow ,ukentrydate ,eas FROM igs_uc_istark_ints WHERE 1 = 2
View Text - HTML Formatted

SELECT APPNO
, SYSDATE TIMESTAMP
, APPLICATIONDATE
, SENTDATE
, RUNSENT
, CODEDCHANGEDATE
, RESCAT
, FEELEVEL
, APR
, COUNTRYBIRTH
, NATIONALITY
, WITHDRAWN
, WITHDRAWNDATE
, QUALENG QUALENGLISH
, QUALMATH QUALMATHS
, QUALSCI QUALSCIENCE
, QUAL5 QUAL5POINT
, MAINQUAL QUALMAIN
, NINUMBER NATIONALINSURANCE
, EARLIESTSTART STARTDATE
, NEARINST NEARESTINST
, PREFREG PREFREGION
, SPECIALNEEDS
, STATUS
, FIRMNOW
, UKENTRYDATE
, EAS
FROM IGS_UC_ISTARK_INTS
WHERE 1 = 2