DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_AUDIT_TABLES

Object Details
Object Name: FND_AUDIT_TABLES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_AUDIT_TABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnAUDIT_GROUP_ID
ColumnAUDIT_GROUP_APP_ID
ColumnTABLE_APP_ID
ColumnTABLE_ID
Columns
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
Query Text

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
FROM APPLSYS.FND_AUDIT_TABLES;

Dependencies

[top of page]

APPLSYS.FND_AUDIT_TABLES does not reference any database object

APPLSYS.FND_AUDIT_TABLES is referenced by following:

SchemaAPPS
SynonymFND_AUDIT_TABLES