FND Design Data [Home] [Help]

View: IGS_UC_IVGSTARA_2007

Product: IGS - Student System (Obsolete)
Description: Dummy View for IVGSTARA for the UCAS 2007 Cycle
Implementation/DBA Data: Not implemented in this database
View Text

SELECT APPNO
, SYSDATE TIMESTAMP
, ADDRESSAREA
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, POSTCODE
, MAILSORT
, TELEPHONE
, EMAIL
, HOMEADDRESS1
, HOMEADDRESS2
, HOMEADDRESS3
, HOMEADDRESS4
, HOMEPOSTCODE
, MOBILE
, COUNTRYCODE
, HOMECOUNTRYCODE
FROM IGS_UC_ISTARA_INTS
WHERE 1 = 2

Columns

Name
APPNO
TIMESTAMP
ADDRESSAREA
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
POSTCODE
MAILSORT
TELEPHONE
EMAIL
HOME_ADDRESS1
HOME_ADDRESS2
HOME_ADDRESS3
HOME_ADDRESS4
HOMEPOSTCODE
MOBILE
COUNTRYCODE
HOMECOUNTRYCODE