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_TRANSACTIONS

Object Details

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

This table stores the transaction details that has been processed in AME. This table also has the information whether transaction is deviated or not.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AME_TEMP_TRANSACTIONS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	APPLICATION_ID TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER		Yes	AME internal application identifier which identifies a transaction type
TRANSACTION_ID	VARCHAR2	(50)	Yes	Transaction identifier
ROW_TIMESTAMP	DATE		Yes	Time stamp when the transaction is logged
SECURITY_GROUP_ID	NUMBER	(15)		Not used
TEMP_TRANSACTIONS_ID	NUMBER		Yes	Identifier for the temporary transactions
TRANSACTION_REQUESTOR	VARCHAR2	(100)		Requestor of the transaction
TRANSACTION_DESCRIPTION	VARCHAR2	(100)		Description of transaction
TRANS_DEVIATION_FLAG	VARCHAR2	(2)		Indicates whether the transaction is deviated or not
END_DATE	DATE			AME transaction completion date
TXN_ATTRIBUTE_1	VARCHAR2	(30)		Not used
TXN_ATTRIBUTE_2	VARCHAR2	(30)		Not used
TXN_ATTRIBUTE_3	VARCHAR2	(30)		Not used
TXN_ATTRIBUTE_4	VARCHAR2	(30)		Not used
TXN_ATTRIBUTE_5	VARCHAR2	(30)		Not used
TXN_ATTRIBUTE_6	VARCHAR2	(1000)		Not used
TXN_ATTRIBUTE_7	VARCHAR2	(1000)		Not used
TXN_ATTRIBUTE_8	VARCHAR2	(1000)		Not used
TXN_ATTRIBUITE_9	VARCHAR2	(1000)		Not used
TX_ATTRIBUTE_10	VARCHAR2	(1000)		Not used

Query Text

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


SELECT APPLICATION_ID
,      TRANSACTION_ID
,      ROW_TIMESTAMP
,      SECURITY_GROUP_ID
,      TEMP_TRANSACTIONS_ID
,      TRANSACTION_REQUESTOR
,      TRANSACTION_DESCRIPTION
,      TRANS_DEVIATION_FLAG
,      END_DATE
,      TXN_ATTRIBUTE_1
,      TXN_ATTRIBUTE_2
,      TXN_ATTRIBUTE_3
,      TXN_ATTRIBUTE_4
,      TXN_ATTRIBUTE_5
,      TXN_ATTRIBUTE_6
,      TXN_ATTRIBUTE_7
,      TXN_ATTRIBUTE_8
,      TXN_ATTRIBUITE_9
,      TX_ATTRIBUTE_10
FROM HR.AME_TEMP_TRANSACTIONS;

Dependencies

[top of page]

HR.AME_TEMP_TRANSACTIONS does not reference any database object

HR.AME_TEMP_TRANSACTIONS is referenced by following:

APPS: AME_TEMP_TRANSACTIONS