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: HR.AME_REC_ACCESS_TRANS

Object Details

Object Name:	AME_REC_ACCESS_TRANS
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

This table stores the time log when a transaction type is accessed recently using AME application.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Comments
APPLICATION_ID	NUMBER	AME internal application identifier which identifies a transaction type
USER_ID	NUMBER	User who recently accessed the transaction type
LAST_ACCESSED_DATE	DATE	Date the transaction type is accessed last time

Query Text

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


SELECT APPLICATION_ID
,      USER_ID
,      LAST_ACCESSED_DATE
FROM HR.AME_REC_ACCESS_TRANS;

Dependencies

[top of page]

HR.AME_REC_ACCESS_TRANS does not reference any database object

HR.AME_REC_ACCESS_TRANS is referenced by following:

APPS: AME_REC_ACCESS_TRANS