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

VIEW: APPS.IGS_UC_IVSTARA_2003

Object Details
Object Name: IGS_UC_IVSTARA_2003
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_UC_IVSTARA_2003
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory 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
FAX VARCHAR2 (1)
** NO LONGER USED (2002) **
EMAIL VARCHAR2 (60)
EAS Email address
HOMEADDRESS1 VARCHAR2 (50)
EAS Address line 1
HOMEADDRESS2 VARCHAR2 (50)
EAS Address line 2
HOMEADDRESS3 VARCHAR2 (50)
EAS Address line 3
HOMEADDRESS4 VARCHAR2 (50)
EAS Address line 4
HOMEPOSTCODE VARCHAR2 (8)
Home Postcode
HOMEPHONE VARCHAR2 (24)
Home Phone number
HOMEFAX VARCHAR2 (1)
** NO LONGER USED (2002) **
HOMEEMAIL VARCHAR2 (1)
** NO LONGER USED (2002) **
Query Text

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


SELECT APPNO
,      TIMESTAMP
,      ADDRESSAREA
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      POSTCODE
,      MAILSORT
,      TELEPHONE
,      FAX
,      EMAIL
,      HOMEADDRESS1
,      HOMEADDRESS2
,      HOMEADDRESS3
,      HOMEADDRESS4
,      HOMEPOSTCODE
,      HOMEPHONE
,      HOMEFAX
,      HOMEEMAIL
FROM APPS.IGS_UC_IVSTARA_2003;

Dependencies

[top of page]

APPS.IGS_UC_IVSTARA_2003 references the following:

SchemaAPPS
SynonymIGS_UC_ISTARA_INTS
APPS.IGS_UC_IVSTARA_2003 is referenced by following:

SchemaAPPS
SynonymIGS_UC_U_IVSTARA_2003