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_APPROVAL_GROUP_MEMBERS

Object Details

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

This table stores the denormalized approver group member details. It resolves the nested group members.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
APPROVAL_GROUP_ID	NUMBER		Yes	Approver group identifier
PARAMETER_NAME	VARCHAR2	(20)		Type of the approver group component
PARAMETER	VARCHAR2	(320)	Yes	Name of the approver in workflow directory services for static group member, Approver group identifier for nested approver group
QUERY_STRING	VARCHAR2	(4000)		Sql statement to fetch the approver group member
ORDER_NUMBER	NUMBER		Yes	Order number of component for the approver group
SECURITY_GROUP_ID	NUMBER	(15)		Not used
ORIG_SYSTEM	VARCHAR2	(48)		Orig system of the approver in workflow directory services
ORIG_SYSTEM_ID	NUMBER	(15)		Orig system id of the approver in workflow directory services

Query Text

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


SELECT APPROVAL_GROUP_ID
,      PARAMETER_NAME
,      PARAMETER
,      QUERY_STRING
,      ORDER_NUMBER
,      SECURITY_GROUP_ID
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
FROM HR.AME_APPROVAL_GROUP_MEMBERS;

Dependencies

[top of page]

HR.AME_APPROVAL_GROUP_MEMBERS does not reference any database object

HR.AME_APPROVAL_GROUP_MEMBERS is referenced by following:

APPS: AME_APPROVAL_GROUP_MEMBERS