DBA Data[Home] [Help]

VIEW: APPS.IGS_UC_IVNSTARA_2007

Source

View Text - Preformatted

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
View Text - HTML Formatted

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