DBA Data[Home] [Help]

VIEW: APPS.IGS_UC_CVNAME_2003

Source

View Text - Preformatted

SELECT appno ,sysdate timestamp ,checkdigit ,namechangedate ,title ,forenames ,surname ,indexsurn ,cancelled ,withdrawn ,status ,birthdate ,sex ,choicesalltransparent ,extrastatus FROM IGS_UC_CVNAME_INTS WHERE 1 = 2
View Text - HTML Formatted

SELECT APPNO
, SYSDATE TIMESTAMP
, CHECKDIGIT
, NAMECHANGEDATE
, TITLE
, FORENAMES
, SURNAME
, INDEXSURN
, CANCELLED
, WITHDRAWN
, STATUS
, BIRTHDATE
, SEX
, CHOICESALLTRANSPARENT
, EXTRASTATUS
FROM IGS_UC_CVNAME_INTS
WHERE 1 = 2