DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on MTL_RESERVATIONS

Line 8155: UPDATE mtl_reservations

8151:
8152:
8153: --Need to sync the MR detailed_quantity with the sum(MMTT pri qty).
8154: --But it cannot exceed the primary_reservatin_quantity.
8155: UPDATE mtl_reservations
8156: SET detailed_quantity = LEAST(l_new_mmtt_qty, primary_reservation_quantity)
8157: WHERE reservation_id = l_reservation_id;
8158:
8159: EXCEPTION