APPS.WF_MONITOR dependencies on WF_ITEM_TYPES_VL

Line 294: from wf_item_types_vl

290:
291: begin
292: select display_name
293: into item_type_tl
294: from wf_item_types_vl
295: where name = x_item_type;
296:
297: exception
298: when OTHERS then

Line 496: wf_item_types_vl ait,

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,
500: wf_lookup_types art,

Line 763: wf_item_types_vl ait,

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,
767: wf_lookups l2,

Line 2298: wf_item_types_vl wit,

2294: wi.item_type,
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

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 4220: FROM wf_item_types_vl

4216: BEGIN
4217:
4218: SELECT display_name
4219: INTO l_item_type_disp_name
4220: FROM wf_item_types_vl
4221: WHERE name = p_parent_item_type;
4222:
4223: exception
4224: when no_data_found THEN