[Home] [Help] [Dependency Information]
Object Name: | FND_AUDIT_TABLES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_AUDIT_TABLES |
Subobject Name: | |
Status: | VALID |
FND_AUDIT_TABLES stores information about audit tables. Each row
includes the audit group identifier, table identifier, and identifiers
of the applications the audit group and the table belong to. Each
row also includes a flag that indicates what state the audit table is
in. You need one row for each audit table. Oracle Application
Object Library uses this information to implement AuditTrail
beginning from release 10.4 of Oracle Applications.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_AUDIT_TABLES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
AUDIT_GROUP_ID
AUDIT_GROUP_APP_ID TABLE_APP_ID TABLE_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_GROUP_ID | NUMBER | Yes | Audit group identifier | |
AUDIT_GROUP_APP_ID | NUMBER | Yes | Audit group application identifier | |
TABLE_APP_ID | NUMBER | Yes | Table application identifier | |
TABLE_ID | NUMBER | Yes | Table identifier | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
STATE | VARCHAR2 | (1) | Yes | Flag to indicate the state of database trigger or the states of requests |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_GROUP_ID
, AUDIT_GROUP_APP_ID
, TABLE_APP_ID
, TABLE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, STATE
, ZD_EDITION_NAME
FROM APPLSYS.FND_AUDIT_TABLES;
APPLSYS.FND_AUDIT_TABLES does not reference any database object
APPLSYS.FND_AUDIT_TABLES is referenced by following:
|
|
|