DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS

Line 648: UPDATE wms_dispatched_tasks

644:
645: -- bulk update WDT with original subinventory and locator
646: -- Bug 4884372: moved WDT update to before the COMMIT
647: forall i IN 1..l_temp_id_table.COUNT
648: UPDATE wms_dispatched_tasks
649: SET suggested_dest_subinventory = l_pick_rel_sub_table(i),
650: suggested_dest_locator_id = l_pick_rel_loc_id_table(i)
651: WHERE transaction_temp_id = l_temp_id_table(i)
652: AND task_type IN (g_wms_task_type_pick, g_wms_task_type_stg_move);