APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_OP_OPERATION_INSTANCES

Line 208: wms_op_operation_instances wooi,

204:
205: CURSOR upd_op_seq IS
206: SELECT wooi.operation_sequence,wwtt.transaction_temp_id
207: FROM
208: wms_op_operation_instances wooi,
209: (SELECT transaction_temp_id
210: FROM wms_waveplan_tasks_temp
211: WHERE status_id = 6
212: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt

Line 899: FROM wms_op_operation_instances wooi

895: l_planned_task := wms_plan_tasks_pvt.g_plan_task_types(2);
896: DELETE FROM wms_waveplan_tasks_temp wwtt
897: WHERE EXISTS (
898: SELECT 1
899: FROM wms_op_operation_instances wooi
900: WHERE wwtt.transaction_temp_id = wooi.source_task_id
901: AND wwtt.operation_sequence = wooi.operation_sequence
902: AND wooi.operation_status IN (1,2) -- added for bug 5172443 to delete drop-active record
903: AND wooi.complete_time IS NULL)