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: ONT.OE_AUDIT_ATTR_HISTORY

Object Details

Object Name:	OE_AUDIT_ATTR_HISTORY
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_AUDIT_ATTR_HISTORY
Subobject Name:
Status:	VALID

Audit Trail History Table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_AUDIT_ATTR_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HIST_CREATION_DATE ENTITY_ID ENTITY_NUMBER ATTRIBUTE_ID

Columns

Name	Datatype	Length	Comments
ENTITY_ID	NUMBER		Transaction entity
ATTRIBUTE_ID	NUMBER		Attribute ID for entity
OLD_ATTRIBUTE_VALUE	VARCHAR2	(2000)	Value of the attribute before change
NEW_ATTRIBUTE_VALUE	VARCHAR2	(2000)	Value of the attribute after change
REASON	VARCHAR2	(80)
HIST_CREATION_DATE	DATE		Date on which audit history is created.
ORDER_NUMBER	NUMBER		Order number for which history is captured
ENTITY_NUMBER	NUMBER		Unique identifier specific toentity
ORG_ID	NUMBER		Organization ID
REASON_CODE	VARCHAR2	(80)	Reason code for change
RESPONSIBILITY_ID	NUMBER		Standard who column
USER_ID	NUMBER		Standard who column
ORDER_TYPE_ID	NUMBER		Order Type ID
SOLD_TO_ORG_ID	NUMBER		Customer
CHANGE_COMMENTS	VARCHAR2	(2000)	Comments for the change
ENTITY_NUMBER2	NUMBER		Second ID specific to entity
OLD_CONTEXT_VALUE	VARCHAR2	(30)	DFF Old context value
NEW_CONTEXT_VALUE	VARCHAR2	(30)	DFF New context value

Query Text

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


SELECT ENTITY_ID
,      ATTRIBUTE_ID
,      OLD_ATTRIBUTE_VALUE
,      NEW_ATTRIBUTE_VALUE
,      REASON
,      HIST_CREATION_DATE
,      ORDER_NUMBER
,      ENTITY_NUMBER
,      ORG_ID
,      REASON_CODE
,      RESPONSIBILITY_ID
,      USER_ID
,      ORDER_TYPE_ID
,      SOLD_TO_ORG_ID
,      CHANGE_COMMENTS
,      ENTITY_NUMBER2
,      OLD_CONTEXT_VALUE
,      NEW_CONTEXT_VALUE
FROM ONT.OE_AUDIT_ATTR_HISTORY;

Dependencies

[top of page]

ONT.OE_AUDIT_ATTR_HISTORY does not reference any database object

ONT.OE_AUDIT_ATTR_HISTORY is referenced by following:

APPS: OE_AUDIT_ATTR_HISTORY