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: TablePER.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: TablespaceAPPS_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:

SchemaAPPS
SynonymAME_APPROVAL_GROUP_MEMBERS