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_TEMP_TRANS_LOCKS

Object Details

Object Name:	AME_TEMP_TRANS_LOCKS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.AME_TEMP_TRANS_LOCKS
Subobject Name:
Status:	VALID

This table is temporary table for internal operation.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AME_TEMP_TRANS_LOCKS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FND_APPLICATION_ID TRANSACTION_TYPE_ID TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FND_APPLICATION_ID	NUMBER		Yes	FND application identifier for which transaction type belongs
TRANSACTION_TYPE_ID	VARCHAR2	(50)		Transaction type key
TRANSACTION_ID	VARCHAR2	(50)	Yes	Transaction identifier
ROW_TIMESTAMP	DATE		Yes	Time stamp when transaction has been locked

Query Text

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


SELECT FND_APPLICATION_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_ID
,      ROW_TIMESTAMP
FROM HR.AME_TEMP_TRANS_LOCKS;

Dependencies

[top of page]

HR.AME_TEMP_TRANS_LOCKS does not reference any database object

HR.AME_TEMP_TRANS_LOCKS is referenced by following:

APPS: AME_TEMP_TRANS_LOCKS