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_HDR

Object Details

Object Name:	FND_AUDIT_REP_HDR
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_AUDIT_REP_HDR
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
USER_TABLE_NAME	VARCHAR2	(80)	User Table Name
COLUMN1_NAME	VARCHAR2	(80)	Column1 display value
COLUMN2_NAME	VARCHAR2	(80)	Column2 display value
COLUMN3_NAME	VARCHAR2	(80)	Column3 display value
COLUMN4_NAME	VARCHAR2	(80)	Column4 display value
COLUMN5_NAME	VARCHAR2	(80)	Column5 display value
SELECT_CLAUSE	VARCHAR2	(2000)	Select Clause
APPLICATION_ID	NUMBER		Application ID
TABLE_ID	NUMBER		Table ID
WHERE_CLAUSE	VARCHAR2	(2000)	Where clause

Query Text

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


SELECT REP_ID
,      TABLE_NAME
,      USER_TABLE_NAME
,      COLUMN1_NAME
,      COLUMN2_NAME
,      COLUMN3_NAME
,      COLUMN4_NAME
,      COLUMN5_NAME
,      SELECT_CLAUSE
,      APPLICATION_ID
,      TABLE_ID
,      WHERE_CLAUSE
FROM APPLSYS.FND_AUDIT_REP_HDR;

Dependencies

[top of page]

APPLSYS.FND_AUDIT_REP_HDR does not reference any database object

APPLSYS.FND_AUDIT_REP_HDR is referenced by following:

APPLSYS: FND_AUDIT_REP_HDR#