[Home] [Help] [Dependency Information]
Object Name: | FND_AUDIT_GROUPS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_AUDIT_GROUPS |
Subobject Name: | |
Status: | VALID |
FND_AUDIT_GROUPS stores information about audit groups. Each row
includes the audit group identifier, the name of the audit group,
and the dates when the audit group becomes active and expires.
Each row also include a flag that indicates what state the audit
group is in. You need one row for each audit group. Oracle
Application Object Library uses this information to implement
the new AuditTrail mechanism for Oracle Applications beginning
from release 10.4.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_AUDIT_GROUPS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
AUDIT_GROUP_ID
APPLICATION_ID ZD_EDITION_NAME |
FND_AUDIT_GROUPS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
GROUP_NAME
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | Yes | Application identifier | |
AUDIT_GROUP_ID | NUMBER | Yes | Audit group 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 |
GROUP_NAME | VARCHAR2 | (240) | Yes | Audit group name |
STATE | VARCHAR2 | (1) | Yes | Flag to indicate if the Audit Group is enabled or in one of the disabled states |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, AUDIT_GROUP_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, GROUP_NAME
, STATE
, DESCRIPTION
, ZD_EDITION_NAME
FROM APPLSYS.FND_AUDIT_GROUPS;
APPLSYS.FND_AUDIT_GROUPS does not reference any database object
APPLSYS.FND_AUDIT_GROUPS is referenced by following:
|
|
|