APPS.WF_MONITOR dependencies on WF_ACTIVITIES

Line 492: from wf_activities pd,

488: n.status not_status,
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,

Line 494: wf_activities a,

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,
498: wf_lookups l1,

Line 495: wf_activities_tl a1,

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,
498: wf_lookups l1,
499: wf_lookups l2,

Line 759: from wf_activities pd,

755: to_char(n.begin_date) || ' '|| to_char(n.begin_date, 'HH24:MI:SS')
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,

Line 761: wf_activities a,

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,
765: wf_notifications n,

Line 762: wf_activities_tl a1,

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,
765: wf_notifications n,
766: wf_lookups l1,

Line 1016: from wf_activities pd,

1012: s.activity_result_code,
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,

Line 1018: wf_activities a,

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,
1022: wf_process_activities p2

Line 2299: wf_activities_vl wa

2295: wi.end_date,
2296: wa.display_name process_name
2297: from wf_items wi,
2298: wf_item_types_vl wit,
2299: wf_activities_vl wa
2300: where wi.item_type = wit.name
2301: and wa.item_type = wi.item_type
2302: and wa.name = wi.root_activity
2303: and wa.version = wi.root_activity_version

Line 3097: from wf_items i, wf_activities_vl a, wf_item_types_vl it

3093: -- do the fetch here.
3094: -- This is to avoid sending spaces throught web server
3095: select i.begin_date, i.end_date, a.display_name, it.display_name, i.root_activity
3096: into x_begin_date, x_end_date, proc_dispname, item_type_dispname, x_root_activity
3097: from wf_items i, wf_activities_vl a, wf_item_types_vl it
3098: where i.item_type = x_item_type
3099: and i.item_key = x_item_key
3100: and i.item_type = it.name
3101: and i.root_activity = a.name

Line 3721: 'wf_activities_vl_pub.fetch_draw_activity_details?p_item_type='||

3717:
3718: htp.tableData(
3719: cvalue=>' 3770: owa_util.get_owa_service_path||
3771: 'wf_activities_vl_pub.fetch_draw_activity_details?p_item_type='||
3772: wfa_html.conv_special_url_chars(x_activity_record.activity_item_type)||
3773: '&p_activity_type='||
3774: x_activity_record.activity_type||
3775: '&p_effective_date='||