Wednesday, November 19, 2008

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

No comments:

Post a Comment