[Home] [Help]
489: n.due_date not_due_date,
490: n.begin_date not_begin_date,
491: n.end_date not_end_date
492: from wf_activities pd,
493: wf_process_activities p,
494: wf_activities a,
495: wf_activities_tl a1,
496: wf_item_types_vl ait,
497: wf_item_activity_statuses s,
756: not_begin_date,
757: to_char(n.end_date) || ' '|| to_char(n.end_date, 'HH24:MI:SS')
758: not_end_date
759: from wf_activities pd,
760: wf_process_activities p,
761: wf_activities a,
762: wf_activities_tl a1,
763: wf_item_types_vl ait,
764: wf_item_activity_statuses s,
1013: l.lookup_code,
1014: p2.icon_geometry to_icon_geometry, /* to activity */
1015: p2.instance_id to_instance_id
1016: from wf_activities pd,
1017: wf_process_activities p1,
1018: wf_activities a,
1019: wf_activity_transitions t,
1020: wf_item_activity_statuses s,
1021: wf_lookups l,
1018: wf_activities a,
1019: wf_activity_transitions t,
1020: wf_item_activity_statuses s,
1021: wf_lookups l,
1022: wf_process_activities p2
1023: where pd.item_type = x_proc_type
1024: and pd.name = x_proc_name
1025: and pd.begin_date <= to_date(x_begin_date, 'DD/MM/YYYY HH24:MI:SS')
1026: and (pd.end_date is null or
4037: ias.error_name,
4038: ias.error_message,
4039: ias.error_stack
4040: from wf_item_activity_statuses ias,
4041: wf_process_activities pa,
4042: wf_activities_vl ac,
4043: wf_activities_vl ap,
4044: wf_items i
4045: where ias.item_type = c_item_type