[Home] [Help] [Dependency Information]
Object Name: | FND_OAM_CONTEXT_FILES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_OAM_CONTEXT_FILES |
Subobject Name: | |
Status: | VALID |
FND_OAM_CONTEXT_FILES stores all context files and metadata file belongs to the application instance. Each Row contains context name, actual context file, and version of file. There will be one metadata file for the entire Applications instance.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000240879C00005$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
FND_OAM_CONTEXT_FILES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
NODE_NAME
PATH STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (512) | Yes | Context Name parsed from context file |
VERSION | VARCHAR2 | (30) | Yes | File version parsed from file |
PATH | VARCHAR2 | (1024) | Yes | Full file path |
LAST_SYNCHRONIZED | DATE | Yes | Last upload or download time | |
TEXT | CLOB | (4000) | Yes | File contents |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
NODE_NAME | VARCHAR2 | (30) | Yes | Node name where context file is located |
STATUS | VARCHAR2 | (1) | status of writing back file to file system | |
SERIAL_NUMBER | NUMBER | serial number used for comparing file system contents with db contents | ||
EDIT_COMMENTS | VARCHAR2 | (2000) | user specified comments | |
CTX_TYPE | VARCHAR2 | (1) | Yes | used to specify context file for Database/Apps |
Cut, paste (and edit) the following text to query this object:
SELECT NAME
, VERSION
, PATH
, LAST_SYNCHRONIZED
, TEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NODE_NAME
, STATUS
, SERIAL_NUMBER
, EDIT_COMMENTS
, CTX_TYPE
FROM APPLSYS.FND_OAM_CONTEXT_FILES;
APPLSYS.FND_OAM_CONTEXT_FILES does not reference any database object
APPLSYS.FND_OAM_CONTEXT_FILES is referenced by following:
|
|
|