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


VIEW: APPS.WF_LOOKUPS

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

View Type

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


WF_LOOKUPS is a view of Workflow QuickCodes. Each row includes
the QuickCode lookup type, the QuickCode itself, its meaning, and
additional description.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique row identifier
LOOKUP_TYPE VARCHAR2 (30) Yes QuickCode lookup type
LOOKUP_CODE VARCHAR2 (30) Yes QuickCode code
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
MEANING VARCHAR2 (80) Yes QuickCode meaning
DESCRIPTION VARCHAR2 (240)
Description
Query Text

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


SELECT ROW_ID
,      LOOKUP_TYPE
,      LOOKUP_CODE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      MEANING
,      DESCRIPTION
FROM APPS.WF_LOOKUPS;

Dependencies

[top of page]

APPS.WF_LOOKUPS references the following:

SchemaAPPS
SynonymWF_LOOKUPS_TL
APPS.WF_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyAMV_WFAPPROVAL_PVT - show dependent code
Package BodyCAC_VIEW_WF_PVT - show dependent code
Package BodyCCT_ROUTINGWORKFLOW_UTL - show dependent code
Package BodyEDR_PSIG_PAGE_FLOW - show dependent code
Package BodyEDR_UTILITIES - show dependent code
Package BodyENG_WORKFLOW_API_PKG - show dependent code
Package BodyENG_WORKFLOW_UTIL - show dependent code
ViewFND_SVC_COMPONENTS_V
Package BodyIBC_CITEM_WORKFLOW_PVT - show dependent code
Package BodyIBE_OM_INTEGRATION_GRP - show dependent code
Package BodyJTF_BRM_UTILITY_PVT - show dependent code
Package BodyJTF_CAL_WF_PVT - show dependent code
Package BodyOE_ORDER_WF_UTIL - show dependent code
Package BodyOE_UPGRADE_WF - show dependent code
Package BodyOE_UPGRADE_WF2 - show dependent code
Package BodyOTA_ADD_TRAINING_SS - show dependent code
Package BodyPA_PROGRESS_REPORT_WORKFLOW - show dependent code
Package BodyPSP_WF_ADJ_PKG - show dependent code
Package BodyWFA_HTML_UTIL - show dependent code
Package BodyWF_CORE - show dependent code
Package BodyWF_EVENT_HTML - show dependent code
Package BodyWF_INITIATE - show dependent code
ViewWF_ITEM_ACTIVITY_STATUSES_V
Package BodyWF_LOAD - show dependent code
Package BodyWF_LOOKUP_TYPES_PUB - show dependent code
Package BodyWF_MAIL - show dependent code
Package BodyWF_MONITOR - show dependent code
Package BodyWF_NOTIFICATION - show dependent code
ViewWF_NOTIFICATIONS_VIEW
Package BodyWF_PLUG - show dependent code
Package BodyWF_ROUTE - show dependent code
Package BodyWF_STANDARD - show dependent code
Package BodyWF_TASKFLOW - show dependent code
ViewXDP_FMC_V
Package BodyXNP_CVU_PKG - show dependent code