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


VIEW: APPS.WF_ACTIVITY_ATTRIBUTES_VL

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

View Type

MultiLingual view (a language resolved view of the data.)


WF_ACTIVITIES_ATTRIBUTES_VL is a view that joins the translated,
language specific
values from WF_ACTIVITIES_ATTRIBUTES_TL with the non-displayed
data from WF_ACTIVITIES_ATTRIBUTES
to form complete zoom entities. Oracle Aplication Object Library
uses this view to display translated information in languages
installed at your site.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique row identifier
ACTIVITY_ITEM_TYPE VARCHAR2 (8) Yes Item type of the activity
ACTIVITY_NAME VARCHAR2 (30) Yes Internal name of the activity
ACTIVITY_VERSION NUMBER
Yes Version of the activity
NAME VARCHAR2 (30) Yes Internal name
SEQUENCE NUMBER
Yes Order of the attribute within the message
TYPE VARCHAR2 (8) Yes Type of activity
VALUE_TYPE VARCHAR2 (8) Yes Defines if the default is a constant or a reference to a item attribute
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
SUBTYPE VARCHAR2 (8)
Determines if attribute is send or respond
FORMAT VARCHAR2 (240)
Format mask or Lookup type
TEXT_DEFAULT VARCHAR2 (4000)
Default format if type is text
NUMBER_DEFAULT NUMBER

Default format if type is number
DATE_DEFAULT DATE

Default format if type is date
DISPLAY_NAME VARCHAR2 (80) Yes Name displayed to the user
DESCRIPTION VARCHAR2 (240)
Description
Query Text

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


SELECT ROW_ID
,      ACTIVITY_ITEM_TYPE
,      ACTIVITY_NAME
,      ACTIVITY_VERSION
,      NAME
,      SEQUENCE
,      TYPE
,      VALUE_TYPE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      SUBTYPE
,      FORMAT
,      TEXT_DEFAULT
,      NUMBER_DEFAULT
,      DATE_DEFAULT
,      DISPLAY_NAME
,      DESCRIPTION
FROM APPS.WF_ACTIVITY_ATTRIBUTES_VL;

Dependencies

[top of page]

APPS.WF_ACTIVITY_ATTRIBUTES_VL references the following:

SchemaAPPS
SynonymWF_ACTIVITY_ATTRIBUTES
SynonymWF_ACTIVITY_ATTRIBUTES_TL
APPS.WF_ACTIVITY_ATTRIBUTES_VL is referenced by following:

SchemaAPPS
Package BodyAZW_FLOW - show dependent code
Package BodyAZW_PROC - show dependent code
Package BodyAZW_UTIL - show dependent code
Package BodyJTF_BRM_UTILITY_PVT - show dependent code
ViewJTF_BRM_WF_ATTR_V
ViewJTF_BRM_WF_ATTR_VALUES_V
Package BodyWF_ACTIVITIES_VL_PUB - show dependent code
Package BodyWF_LOAD - show dependent code
Package BodyWF_MONITOR - show dependent code