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
No comments:
Post a Comment