DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS

Line 656: UPDATE wms_dispatched_tasks

652:
653: -- bulk update WDT with original subinventory and locator
654: -- Bug 4884372: moved WDT update to before the COMMIT
655: forall i IN 1..l_temp_id_table.COUNT
656: UPDATE wms_dispatched_tasks
657: SET suggested_dest_subinventory = l_pick_rel_sub_table(i),
658: suggested_dest_locator_id = l_pick_rel_loc_id_table(i)
659: WHERE transaction_temp_id = l_temp_id_table(i)
660: AND task_type IN (g_wms_task_type_pick, g_wms_task_type_stg_move);