DBA Data[Home] [Help]

APPS.WMS_PLAN_TASKS_PVT dependencies on WMS_OP_OPERATION_INSTANCES

Line 184: wms_op_operation_instances wooi,

180:
181: CURSOR upd_op_seq IS
182: SELECT wooi.operation_sequence,wwtt.transaction_temp_id
183: FROM
184: wms_op_operation_instances wooi,
185: (SELECT transaction_temp_id
186: FROM wms_waveplan_tasks_temp
187: WHERE status_id = 6
188: AND plans_tasks = wms_plan_tasks_pvt.g_plan_task_types(2)) wwtt

Line 875: FROM wms_op_operation_instances wooi

871: l_planned_task := wms_plan_tasks_pvt.g_plan_task_types(2);
872: DELETE FROM wms_waveplan_tasks_temp wwtt
873: WHERE EXISTS (
874: SELECT 1
875: FROM wms_op_operation_instances wooi
876: WHERE wwtt.transaction_temp_id = wooi.source_task_id
877: AND wwtt.operation_sequence = wooi.operation_sequence
878: AND wooi.operation_status IN (1,2) -- added for bug 5172443 to delete drop-active record
879: AND wooi.complete_time IS NULL)