Search from 700 + Posts

Dec 24, 2010

Query to Print Workflow Infomation for Sales Order line.

select p.process_name, p.activity_name, p.activity_item_type, s.activity_result_code,

s.activity_status,s.process_activity,p.instance_label, s.item_key
from wf_process_activities p,
wf_item_activity_statuses s
where p.instance_id = s.process_activity
and s.item_type = 'OEOL'
and s.item_key = '&enter_line_id'
order by s.begin_date,s.end_date, s.execution_time

1 comment:

  1. I would like to appreciate you the way you have shared the post with us. It is really hard to find the quality post, but you have done this job nicely man.Appointment Cards

    ReplyDelete