[Home] [Help] [Dependency Information]
Object Name: | IGS_UC_IVREFERENCE_2004_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_UC_IVREFERENCE_2004_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
From 2004, application references information will be held in different Hercules views for different systems. This View selects the application references 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 | ||
REFEREENAME | VARCHAR2 | (50) | Referee name | |
REFEREEPOST | VARCHAR2 | (35) | Referee post | |
ESTABNAME | VARCHAR2 | (60) | Establishment name | |
ADDRESS1 | VARCHAR2 | (50) | Address line 1 | |
ADDRESS2 | VARCHAR2 | (50) | Address line 2 | |
ADDRESS3 | VARCHAR2 | (50) | Address line 3 | |
ADDRESS4 | VARCHAR2 | (50) | Address line 4 | |
TELEPHONE | VARCHAR2 | (35) | Telephone | |
FAX | VARCHAR2 | (35) | Fax number | |
VARCHAR2 | (60) | Email address | ||
STATEMENT | LONG | (0) | Electronic application Statement |
Cut, paste (and edit) the following text to query this object:
SELECT APPNO
, TIMESTAMP
, REFEREENAME
, REFEREEPOST
, ESTABNAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, TELEPHONE
, FAX
, EMAIL
, STATEMENT
FROM APPS.IGS_UC_IVREFERENCE_2004_V;
|
|
|