[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVSTARA_2003_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVSTARA_2003_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, applications information will be held in different Hercules views for different systems. This View selects the Application information belonging to all the systems.
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) ** | |
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) ** |
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_V;
|
|
|