[Home] [Help] [Dependency Information]
Object Name: | FND_SYSTEM_SERVER_MAP |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_SYSTEM_SERVER_MAP |
Subobject Name: | |
Status: | VALID |
This table is included only for reference at this point. It is not needed since only one system is currently modeled in the Apps DB.However, if two or more systems are modeled, then this table will be needed to identify which systems use which servers. Internal servers may not be shared between two system, however, external servers may be shared.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_SYSTEM_SERVER_MAP_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
SYSTEM_GUID
SERVER_GUID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_GUID | RAW | (16) | Yes | Points to the Apps system that uses the server |
SERVER_GUID | RAW | (16) | Yes | Points to the server used by the system |
CREATION_DATE | DATE | Yes | Standard who column for Apps | |
CREATED_BY | NUMBER | Yes | Standard who column for Apps | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column for Apps | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column for Apps | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT SYSTEM_GUID
, SERVER_GUID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM APPLSYS.FND_SYSTEM_SERVER_MAP;
APPLSYS.FND_SYSTEM_SERVER_MAP does not reference any database object
APPLSYS.FND_SYSTEM_SERVER_MAP is referenced by following:
|
|
|