Useful WF Query for Oracle E-Business Suite

Here is a WF query for EBS. If you want to see all process and activities on DB instead of status monitor for a completed workflow, it can be useful for you. Just give ITEM_KEY and  ITEM_TYPE parameter and wait for the response. It can takes 3-5 minutes if you are not purging old workflows.

SELECT sta.item_type item_type,

         sta.activity_result_code result,

         pra.process_name || ' : ' || pra.instance_label process_activity_label,

         sta.process_activity instance_id,

         sta.item_key item_key, sta.begin_date

    FROM wf_item_activity_statuses sta, wf_process_activities pra

   WHERE     sta.item_key = p_item_key

         AND sta.item_type = p_item_type

         AND sta.activity_status = 'COMPLETE'

         AND sta.process_activity = pra.instance_id

ORDER BY sta.begin_date ASC;