APPS.CTO_AUTO_PROCURE_PK dependencies on WF_PROCESS_ACTIVITIES

Line 636: wf_process_activities wpa

632: to_char(was.begin_date,'DD-MON-RR HH24:MI:SS') begin_date,
633: to_char(was.end_date,'DD-MON-RR HH24:MI:SS') end_date,
634: was.execution_time
635: FROM wf_item_activity_statuses was,
636: wf_process_activities wpa
637: WHERE was.item_type = 'OEOL'
638: AND was.item_type = wpa.activity_item_type
639: AND was.process_activity = wpa.instance_id
640: AND was.item_key = To_Char(p_cursor_line_id)

Line 5205: ' wf_process_activities WPA ';

5201: 'select oel.line_id, oel.org_id, 1, 0 '||
5202: 'from oe_order_lines_all oel,'||
5203: ' mtl_system_items msi,'||
5204: ' wf_item_activity_statuses was,'||
5205: ' wf_process_activities WPA ';
5206:
5207: sql_stmt := sql_stmt || ' where oel.inventory_item_id = msi.inventory_item_id ' ||
5208: 'and oel.ship_from_org_id = msi.organization_id ' ||
5209: 'and oel.source_type_code = ''INTERNAL'' '||