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_TRANS_APPROVAL_HISTORY

Object Details

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

This table stores the details of approver response of a transaction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TRANS_HISTORY_ID	NUMBER		Yes	Row identifier
TRANSACTION_ID	VARCHAR2	(50)	Yes	Transaction identifier
APPLICATION_ID	NUMBER			AME internal application identifier which identifies a transaction type
ROW_TIMESTAMP	DATE		Yes	Not used
ORDER_NUMBER	NUMBER		Yes	Order number
NAME	VARCHAR2	(320)		Name of the approver in workflow directory services
APPROVER_CATEGORY	VARCHAR2	(1)		Approver category
ITEM_CLASS	VARCHAR2	(100)	Yes	Approver item class
ITEM_ID	VARCHAR2	(100)	Yes	Approver item identifier
ACTION_TYPE_ID	NUMBER		Yes	Action type identifier
AUTHORITY	VARCHAR2	(1)	Yes	Whether an approver is pre/chain of authority/post approver
STATUS	VARCHAR2	(50)		Approver response
GROUP_OR_CHAIN_ID	NUMBER		Yes	Group or chain identifier
OCCURRENCE	NUMBER		Yes	Occurence of an approver in current action type
NOTIFICATION_ID	NUMBER			Not used
USER_COMMENTS	VARCHAR2	(4000)		Not used
DATE_CLEARED	DATE			Date cleared
API_INSERTION	VARCHAR2	(1)		Indicates whether an approver is rule generated or not
MEMBER_ORDER_NUMBER	NUMBER			Approver parallelization detail

Query Text

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


SELECT TRANS_HISTORY_ID
,      TRANSACTION_ID
,      APPLICATION_ID
,      ROW_TIMESTAMP
,      ORDER_NUMBER
,      NAME
,      APPROVER_CATEGORY
,      ITEM_CLASS
,      ITEM_ID
,      ACTION_TYPE_ID
,      AUTHORITY
,      STATUS
,      GROUP_OR_CHAIN_ID
,      OCCURRENCE
,      NOTIFICATION_ID
,      USER_COMMENTS
,      DATE_CLEARED
,      API_INSERTION
,      MEMBER_ORDER_NUMBER
FROM HR.AME_TRANS_APPROVAL_HISTORY;

Dependencies

[top of page]

HR.AME_TRANS_APPROVAL_HISTORY does not reference any database object

HR.AME_TRANS_APPROVAL_HISTORY is referenced by following:

APPS: AME_TRANS_APPROVAL_HISTORY