[Home] [Help] [Dependency Information]
Object Name: | AD_FILES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
AD_FILES is the "files repository". It contains information about the various files that have been patched in the Oracle Applications installation.
.
Some entries are "pseudo-files" and not real files, (eg. directories) in which case some of the columns are not applicable and would then hold the value "DUMMY".
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AD_FILES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FILE_ID |
AD_FILES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
FILENAME
SUBDIR APP_SHORT_NAME |
AD_FILES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | IS_FLAGGED_FILE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FILE_ID | NUMBER | Yes | PK | |
APP_SHORT_NAME | VARCHAR2 | (50) | Yes | Oracle Applications product that owns the file |
SUBDIR | VARCHAR2 | (256) | Yes | Subdirectory where the file resides |
FILENAME | VARCHAR2 | (250) | Yes | File name (without path) |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
IS_FLAGGED_FILE | VARCHAR2 | (1) | Boolean stating if this file is customized or not. | |
FLAGGED_FILE_COMMENTS | VARCHAR2 | (4000) | Comments added for a particular customized file. |
Cut, paste (and edit) the following text to query this object:
SELECT FILE_ID
, APP_SHORT_NAME
, SUBDIR
, FILENAME
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, IS_FLAGGED_FILE
, FLAGGED_FILE_COMMENTS
FROM APPLSYS.AD_FILES;
APPLSYS.AD_FILES does not reference any database object
APPLSYS.AD_FILES is referenced by following:
|
|
|