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_INSERTIONS

Object Details

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

This table stores the inserted approver details for a transaction.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AME_TEMP_INSERTIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	APPLICATION_ID TRANSACTION_ID
AME_TEMP_INSERTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PERSON_ID
ANE_TEMP_INSERTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	VARCHAR2	(50)	Yes	Transaction identifier
APPLICATION_ID	NUMBER		Yes	AME internal application identifier which identifies a transaction type
INSERTION_ORDER	NUMBER		Yes	Order in which insertion performed for a transaction
ORDER_TYPE	VARCHAR2	(50)	Yes	Type of AME insertion
PARAMETER	VARCHAR2	(650)	Yes	AME insertion parameter
DESCRIPTION	VARCHAR2	(500)		Description
USER_ID	NUMBER			Not used
PERSON_ID	NUMBER			Not used
API_INSERTION	VARCHAR2	(1)	Yes	Indicates whether the approver is rule generated or not
AUTHORITY	VARCHAR2	(1)	Yes	Whether an approver is pre/chain of authority/post approver
APPROVAL_STATUS	VARCHAR2	(50)		Approver response
SECURITY_GROUP_ID	NUMBER	(15)		Not used
NAME	VARCHAR2	(320)		Name of the approver in workflow directory services
APPROVER_CATEGORY	VARCHAR2	(1)		Approver category
ITEM_CLASS	VARCHAR2	(100)		Approver item class
ITEM_ID	VARCHAR2	(100)		Approver item identifier
SPECIAL_FORWARDEE	VARCHAR2	(1)		Flag to indicate the special type of insertion
EFFECTIVE_DATE	DATE			Insertion date
REASON	VARCHAR2	(50)		Insertion reason
JUSTIFICATION	VARCHAR2	(1000)		Not used

Query Text

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


SELECT TRANSACTION_ID
,      APPLICATION_ID
,      INSERTION_ORDER
,      ORDER_TYPE
,      PARAMETER
,      DESCRIPTION
,      USER_ID
,      PERSON_ID
,      API_INSERTION
,      AUTHORITY
,      APPROVAL_STATUS
,      SECURITY_GROUP_ID
,      NAME
,      APPROVER_CATEGORY
,      ITEM_CLASS
,      ITEM_ID
,      SPECIAL_FORWARDEE
,      EFFECTIVE_DATE
,      REASON
,      JUSTIFICATION
FROM HR.AME_TEMP_INSERTIONS;

Dependencies

[top of page]

HR.AME_TEMP_INSERTIONS does not reference any database object

HR.AME_TEMP_INSERTIONS is referenced by following:

APPS: AME_TEMP_INSERTIONS