Thursday, January 30, 2014

Workflow Tables


Defination:-
Oracle Workflow Builder is a graphical tool for creating, viewing, and modifying workflow process definitions


WF_ITEM_TYPES

        The WF_ITEM_TYPES table contains one record for each item_type created.
        The eight character name of the item_type represents the “Internal Name” of the item.
        It also functions as the primary key for this table.
   

WF_ITEM_TYPES_TL

        The WF_ITEM_TYPES_TL table contain Workflow item type display name.
   
   
WF_ITEMS

        The WF_ITEMS table contain workflow type and workflow key details.
   
   
WF_ITEM_ATTRIBUTES

        This table stores definitions of attributes associated with a process


WF_ITEM_ATTRIBUTES_TL

        This table stores details of attributes like(Display_name,Description).
       
       
WF_ACTIVITIES

        This table store all the activity information of a Workflow like(activity name,begin date, end date).
           

WF_ACTIVITIES_TL

        This table stores details of activity like(Display_name,Description).


WF_ACTIVITY_ATTRIBUTES

        This table store information of attribute for each activity.
       
       
WF_ACTIVITY_ATTRIBUTES_TL

        This table stores details of attribute for each activity like(Display_name,Description).
       

WF_ACTIVITY_ATTR_VALUES

        This table store value of each attribute of each activity.
       
       
WF_MESSAGES

        This Table store information of Message.


WF_MESSAGES_TL

        This Table store information of message like(name,display name,subject,description).
       
       
WF_MESSAGE_ATTRIBUTES

        This table store information of attribute for each message.
       

WF_MESSAGE_ATTRIBUTES_TL

        This table stores details of attribute for each messages like(Display_name,Description).
       
       
WF_PROCESS_ACTIVITIES

        This Table store details of Workflow Process.
       
       
WF_LOOKUP_TYPES_TL

        This Table store details of Each lookups.
       

WF_LOOKUPS_TL

        This table store lookup code details.

No comments:

Post a Comment