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_OLD_APPROVER_LISTS

Object Details

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

This table stores the recently built approver list of a transaction.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AME_TEMP_OLD_AP_LISTS_FK1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	APPLICATION_ID TRANSACTION_ID
AME_TEMP_OLD_AP_LISTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PERSON_ID
AME_TEMP_OLD_AP_LISTS_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
APPROVAL_TYPE_ID	NUMBER			Not used
GROUP_OR_CHAIN_ID	NUMBER		Yes	Group or chain identifier
OCCURRENCE	NUMBER		Yes	Occurence of an approver in current action type
ORDER_NUMBER	NUMBER		Yes	Order number
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
ACTION_TYPE_ID	NUMBER			Approver action type identifier

Query Text

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


SELECT TRANSACTION_ID
,      APPLICATION_ID
,      APPROVAL_TYPE_ID
,      GROUP_OR_CHAIN_ID
,      OCCURRENCE
,      ORDER_NUMBER
,      USER_ID
,      PERSON_ID
,      API_INSERTION
,      AUTHORITY
,      APPROVAL_STATUS
,      SECURITY_GROUP_ID
,      NAME
,      APPROVER_CATEGORY
,      ITEM_CLASS
,      ITEM_ID
,      ACTION_TYPE_ID
FROM HR.AME_TEMP_OLD_APPROVER_LISTS;

Dependencies

[top of page]

HR.AME_TEMP_OLD_APPROVER_LISTS does not reference any database object

HR.AME_TEMP_OLD_APPROVER_LISTS is referenced by following:

APPS: AME_TEMP_OLD_APPROVER_LISTS