eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_UC_IVGSTARA_2006

Object Details

Object Name:	IGS_UC_IVGSTARA_2006
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_UC_IVGSTARA_2006
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Dummy View for IVGSTARA for the UCAS 2006 Cycle

[View Source]

Columns

Name	Datatype	Length	Comments
APPNO	NUMBER	(22)	Application Number
TIMESTAMP	DATE		Time stamp - date and time of last change
ADDRESSAREA	VARCHAR2	(1)	H = England or Wales or N.Ireland, O = Overseas, S = Scotland
ADDRESS1	VARCHAR2	(50)	Address line 1
ADDRESS2	VARCHAR2	(50)	Address line 2
ADDRESS3	VARCHAR2	(50)	Address line 3
ADDRESS4	VARCHAR2	(50)	Address line 4
POSTCODE	VARCHAR2	(8)	Post Code for UK addresses only
MAILSORT	VARCHAR2	(5)	Mail sort for UK addresses only
TELEPHONE	VARCHAR2	(35)	Telephone number
EMAIL	VARCHAR2	(60)	EAS Email address
HOMEPOSTCODE	VARCHAR2	(8)	Home Postcode

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPNO
,      TIMESTAMP
,      ADDRESSAREA
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      POSTCODE
,      MAILSORT
,      TELEPHONE
,      EMAIL
,      HOMEPOSTCODE
FROM APPS.IGS_UC_IVGSTARA_2006;

Dependencies

[top of page]

APPS.IGS_UC_IVGSTARA_2006 references the following:

APPS: IGS_UC_ISTARA_INTS

APPS.IGS_UC_IVGSTARA_2006 is referenced by following:

APPS: IGS_UC_G_IVGSTARA_2006