1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Workflow Tables and queries

Discussion in 'Oracle Apps Technical' started by malli_18arjun, Jan 5, 2010.

  1. malli_18arjun

    malli_18arjun Active Member

    Messages:
    36
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Hyderabad
    Code (SQL):
    SELECT * FROM wf_user_role_assignments
    SELECT * FROM wf_user_roles
    SELECT * FROM wf_roles
    SELECT * FROM wf_items
    SELECT * FROM wf_item_attributes
    SELECT * FROM wf_item_attribute_values
    SELECT * FROM wf_item_attributes_tl
    SELECT * FROM wf_activities
    SELECT * FROM wf_activities_tl
    SELECT * FROM wf_activity_attributes
    SELECT * FROM wf_activity_attributes_tl
    SELECT * FROM wf_activity_transitions
    SELECT * FROM wf_deferred--wf_control

    SELECT * FROM WF_ACTIVITY_ATTR_VALUES
    WHERE NAME LIKE '%MAST%'
    AND PROCESS_ACTIVITY_ID
    IN(
    SELECT *-- PROCESS_ACTIVITY
    FROM WF_ITEM_ACTIVITY_STATUSES
    WHERE ITEM_TYPE = 'OEOH'
    AND ITEM_KEY ='62348'
    )

     
    SELECT * FROM WF_ITEM_TYPES
    SELECT * FROM WF_LOOKUPS_TL
    SELECT * FROM WF_NOTIFICATIONS
    WHERE MESSAGE_TYPE ='TEST'
    ORDER BY BEGIN_DATE DESC

    SELECT * FROM WF_NOTIFICATION_ATTRIBUTES
    SELECT * FROM WF_MESSAGES
    SELECT * FROM WF_MESSAGES_TL
    SELECT * FROM WF_MESSAGE_ATTRIBUTES
    SELECT * FROM WF_MESSAGE_ATTRIBUTES_TL
    SELECT * FROM WF_ETS
    SELECT * FROM WF_PROCESS_ACTIVITIES
     
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hey thanks Arjun,

    It would have been better though, if you included a little description.
     
  3. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    I found it useful today, thanks Arjun.