Work Flow Activity

This query can given you details of WF activity on an order

SELECT wpa.instance_label Label
     , wias.activity_result_code
     , wias.activity_status
     , wias.error_message
  FROM apps.wf_item_activity_statuses wias,
       apps.wf_process_activities wpa
 WHERE wias.item_type in ('OEOL','OEOH')
   AND wias.process_activity = wpa.instance_id
   AND wias.item_key = '35183311'
 ORDER BY wias.begin_date