[Home] [Help] [Dependency Information]
Object Name: | FND_APPS_SYSTEM |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_APPS_SYSTEM |
Subobject Name: | |
Status: | VALID |
This lists system level attributes. There will be only one row in this table. That row represents the local system. An exact copy of this table REM could be used in a central repository (e.g. PTS repository) to track multiple systems.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_APPS_SYSTEM_U1 | NORMAL | UNIQUE | APPS_TS_SEED | NAME |
FND_APPS_SYSTEM_U2 | NORMAL | UNIQUE | APPS_TS_SEED | SYSTEM_GUID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (30) | Yes | Unique name for the Applications system. |
VERSION | VARCHAR2 | (30) | Yes | Apps version of system. e.g. 11.5.0 |
OWNER | VARCHAR2 | (255) | Yes | Name of the Oracle customer that owns this system |
CSI_NUMBER | VARCHAR2 | (30) | Yes | CSI Number that covers this system for support. Non-numeric haracters allowed for future flexibility. |
SYSTEM_GUID | RAW | (16) | Yes | Global unique ID for this system.Will facilitate tracking multiple systems in a central repository, if ever needed. |
SOURCE_SYSTEM_GUID | RAW | (16) | Yes | GUID of system from which this one was cloned. Used for correlation when this information is rolled up into a central repository. |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, VERSION
, OWNER
, CSI_NUMBER
, SYSTEM_GUID
, SOURCE_SYSTEM_GUID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPLSYS.FND_APPS_SYSTEM;
APPLSYS.FND_APPS_SYSTEM does not reference any database object
APPLSYS.FND_APPS_SYSTEM is referenced by following:
|
|
|