DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WF_ITEMS_V

Object Details
Object Name: WF_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.WF_ITEMS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Base view of workflow items


[View Source]

Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE VARCHAR2 (8) Yes Item type
ITEM_KEY VARCHAR2 (240) Yes Key of item activity
USER_KEY VARCHAR2 (240)
User friendly/visible key
ROOT_ACTIVITY VARCHAR2 (30) Yes Top level process it is running
ROOT_ACTIVITY_VERSION NUMBER
Yes Version of the top level process
OWNER_ROLE VARCHAR2 (320)
Not currently used
PARENT_ITEM_TYPE VARCHAR2 (8)
Identifies components of the parent process
PARENT_ITEM_KEY VARCHAR2 (240)
Identifies components of the parent process
PARENT_CONTEXT VARCHAR2 (2000)
Identifies components of the parent process
BEGIN_DATE DATE
Yes Start date
END_DATE DATE

End date
Query Text

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


SELECT ITEM_TYPE
,      ITEM_KEY
,      USER_KEY
,      ROOT_ACTIVITY
,      ROOT_ACTIVITY_VERSION
,      OWNER_ROLE
,      PARENT_ITEM_TYPE
,      PARENT_ITEM_KEY
,      PARENT_CONTEXT
,      BEGIN_DATE
,      END_DATE
FROM APPS.WF_ITEMS_V;

Dependencies

[top of page]

APPS.WF_ITEMS_V references the following:

SchemaAPPS
SynonymWF_ITEMS
APPS.WF_ITEMS_V is referenced by following:

SchemaAPPS
Package BodyAMS_APPROVAL_PVT - show dependent code
Package BodyMSD_WF - show dependent code
Package BodyOE_VALIDATE_HEADER - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOKC_ARTWF_PVT - show dependent code
Package BodyPA_AUTOALLOC_UTLS - show dependent code
Package BodyPO_APPROVAL_REMINDER_SV - show dependent code
Package BodyPO_PDOI_PRICE_TOLERANCE_PVT - show dependent code
Package BodyPSP_ROLLBACK_EFF_REPORTS - show dependent code
Package BodyXDP_INTERFACES - show dependent code
Package BodyXDP_UTILITIES - show dependent code