eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.FND_AUDIT_REP_DTL

Object Details

Object Name:	FND_AUDIT_REP_DTL
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_AUDIT_REP_DTL
Subobject Name:
Status:	VALID

Data in this table is temporary and is used for Audit Trail Reporting

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
REP_ID	NUMBER		Report ID
TABLE_NAME	VARCHAR2	(30)	Table Name
AUDIT_KEY	VARCHAR2	(240)	Audit Key
ROW_DISP_COL	VARCHAR2	(240)	Identifier value for display
AUDIT_TIMESTAMP	DATE		Audit Timestamp
AUDIT_TRANSACTION_TYPE	VARCHAR2	(20)	Audit Transaction Type
AUDIT_USER_NAME	VARCHAR2	(80)	Audit username
COLUMN1_VALUE	VARCHAR2	(240)	Column1 display value
COLUMN2_VALUE	VARCHAR2	(240)	Column2 display value
COLUMN3_VALUE	VARCHAR2	(240)	Column3 display value
COLUMN4_VALUE	VARCHAR2	(240)	Column4 display value
COLUMN5_VALUE	VARCHAR2	(240)	Column5 display value

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REP_ID
,      TABLE_NAME
,      AUDIT_KEY
,      ROW_DISP_COL
,      AUDIT_TIMESTAMP
,      AUDIT_TRANSACTION_TYPE
,      AUDIT_USER_NAME
,      COLUMN1_VALUE
,      COLUMN2_VALUE
,      COLUMN3_VALUE
,      COLUMN4_VALUE
,      COLUMN5_VALUE
FROM APPLSYS.FND_AUDIT_REP_DTL;

Dependencies

[top of page]

APPLSYS.FND_AUDIT_REP_DTL does not reference any database object

APPLSYS.FND_AUDIT_REP_DTL is referenced by following:

APPLSYS: FND_AUDIT_REP_DTL#