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: PA.PA_WF_NTF_PERFORMERS

Object Details

Object Name:	PA_WF_NTF_PERFORMERS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_WF_NTF_PERFORMERS
Subobject Name:
Status:	VALID

This table stores information about the approvers or notification recipients for a specific workflow process . A workflow process is uniquely identified by the item type and item key. Data in this table is only used to identify the people to whom the approval or any other notification should be sent to. Once a workflow process completes, this data is not used anywhere else. This table can be periodically purged by the system administrator.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_WF_NTF_PERFORMERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ITEM_KEY
PA_WF_NTF_PERFORMERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WF_TYPE_CODE OBJECT_ID1
PA_WF_NTF_PERFORMERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GROUP_ID
PA_WF_NTF_PERFORMERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
WF_TYPE_CODE	VARCHAR2	(30)	Yes	The type of the workflow .
ITEM_TYPE	VARCHAR2	(30)	Yes	The item type of the workflow process.
ITEM_KEY	VARCHAR2	(30)	Yes	The system generated item key of the workflow process.
OBJECT_ID1	NUMBER			The unqiue identifier of the source entity for which the workflow is launched, for example, Assignment ID.
OBJECT_ID2	NUMBER			Optional second identifier of the entity or object for which the workflow is launched , for example Project ID.
USER_NAME	VARCHAR2	(100)	Yes	The user name of the workflow notification performer.
USER_TYPE	VARCHAR2	(30)	Yes	The user type of the workflow notification performer.
ROUTING_ORDER	NUMBER			The order in which this performer will receive the notifications.
CURRENT_APPROVER_FLAG	VARCHAR2	(1)		Indicates whether the performer is the current approver.Enables the application to track where the notification currently resides .
APPROVER_COMMENTS	VARCHAR2	(2000)		The comments which the performer of a notification enters when approving or rejecting the approval request.
GROUP_ID	NUMBER	(15)		The group_id is used to represent the mass transaction. It is used in grouping of approvers and is same for a mass approval transaction
APPROVER_GROUP_ID	NUMBER	(15)		The approver group id is used to group approvers and send notifications.
APPROVAL_STATUS	VARCHAR2	(30)		Stores the previous approval status of the assignment before the assignment
SEQUENCE_NUMBER	NUMBER			Action Sequence Number
ACTION_CODE	VARCHAR2	(30)		Action Code
ACTION_DATE	DATE			Action Date
DISPLAY_FLAG	VARCHAR2	(1)		display flag

Query Text

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


SELECT WF_TYPE_CODE
,      ITEM_TYPE
,      ITEM_KEY
,      OBJECT_ID1
,      OBJECT_ID2
,      USER_NAME
,      USER_TYPE
,      ROUTING_ORDER
,      CURRENT_APPROVER_FLAG
,      APPROVER_COMMENTS
,      GROUP_ID
,      APPROVER_GROUP_ID
,      APPROVAL_STATUS
,      SEQUENCE_NUMBER
,      ACTION_CODE
,      ACTION_DATE
,      DISPLAY_FLAG
FROM PA.PA_WF_NTF_PERFORMERS;

Dependencies

[top of page]

PA.PA_WF_NTF_PERFORMERS does not reference any database object

PA.PA_WF_NTF_PERFORMERS is referenced by following:

APPS: PA_WF_NTF_PERFORMERS