[Home] [Help] [Dependency Information]
Object Name: | IEO_SVR_SERVERS |
---|---|
Object Type: | TABLE |
Owner: | IEO |
FND Design Data: | IEO.IEO_SVR_SERVERS |
Subobject Name: | |
Status: | VALID |
Servers identify an instance of a particular type of server, and can be associated with a server groups.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEO_SVR_SERVERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SERVER_ID |
IEO_SVR_SERVERS_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SERVER_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVER_ID | NUMBER | (15) | Yes | Unique ID for a server. |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
CREATION_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column. | |
TYPE_ID | NUMBER | (15) | Yes | FK to server type. |
SERVER_NAME | VARCHAR2 | (1996) | Yes | Server instance name. |
MEMBER_SVR_GROUP_ID | NUMBER | (15) | Server group that this server is a member of. | |
USING_SVR_GROUP_ID | NUMBER | (15) | Server group that this server is using. | |
DNS_NAME | VARCHAR2 | (256) | Host name that identifies the server. | |
IP_ADDRESS | VARCHAR2 | (64) | IP address that identifies the server. | |
USER_ADDRESS | VARCHAR2 | (256) | User specified address (IP or DNS). | |
LOCATION | VARCHAR2 | (500) | User specified location description. | |
DESCRIPTION | VARCHAR2 | (1996) | User specified description of group. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard column used by HTML utilities. |
Cut, paste (and edit) the following text to query this object:
SELECT SERVER_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TYPE_ID
, SERVER_NAME
, MEMBER_SVR_GROUP_ID
, USING_SVR_GROUP_ID
, DNS_NAME
, IP_ADDRESS
, USER_ADDRESS
, LOCATION
, DESCRIPTION
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM IEO.IEO_SVR_SERVERS;
IEO.IEO_SVR_SERVERS does not reference any database object
IEO.IEO_SVR_SERVERS is referenced by following:
|
|
|