[Home] [Help] [Dependency Information]
Object Name: | FND_APPL_TOPS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_APPL_TOPS |
Subobject Name: | |
Status: | VALID |
This table tracks the mount points for the APPL_TOPs in an Applications system. Each mount point has a distinct host and path. A single, physical APPL_TOP (identified by the File_System_GUID) may have multiple mount points, and thus multiple rows in this table.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_APPL_TOPS_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED | APPL_TOP_GUID |
FND_APPL_TOPS_U2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
NODE_ID
PATH |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPL_TOP_GUID | RAW | (16) | Yes | Unique ID for APPL_TOP mount point. |
NAME | VARCHAR2 | (30) | Yes | Internal name of the APPL_TOP |
NODE_ID | NUMBER | Yes | Node of this mount point. Key into fnd_nodes. | |
PATH | VARCHAR2 | (512) | Yes | Full path to APPL_TOP mount point |
CREATED_BY | NUMBER | Yes | Standard who column. | |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard who column. | |
FILE_SYSTEM_GUID | RAW | (16) | This is a stamp that is written into a central directory in the APPL_TOP. This allows us to identify that two APPL_TOPs found on two different nodes are the same shared file system. | |
SHARED | VARCHAR2 | (1) | Yes | Is this APPL_TOP shared with other Apps systems? |
Cut, paste (and edit) the following text to query this object:
SELECT APPL_TOP_GUID
, NAME
, NODE_ID
, PATH
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FILE_SYSTEM_GUID
, SHARED
FROM APPLSYS.FND_APPL_TOPS;
APPLSYS.FND_APPL_TOPS does not reference any database object
APPLSYS.FND_APPL_TOPS is referenced by following:
|
|
|