[Home] [Help]
View: IGS_UC_IVGSTARA_2007
| Product: | IGS - Student System |
| Description: | Dummy View for IVGSTARA for the UCAS 2007 Cycle |
| Implementation/DBA Data: |
APPS.IGS_UC_IVGSTARA_2007
|
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 |