DBA Data[Home] [Help]

APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_RESERVATIONS

Line 3194: UPDATE mtl_reservations

3190: BEGIN
3191: FOR l_index IN 1..g_output_process_tbl_size LOOP
3192: l_reservation_id := g_output_process_tbl(l_index).reservation_id ;
3193: IF l_reservation_id IS NOT NULL THEN
3194: UPDATE mtl_reservations
3195: SET detailed_quantity = detailed_quantity + g_output_process_tbl(l_index).primary_quantity
3196: , secondary_detailed_quantity = secondary_detailed_quantity + g_output_process_tbl(l_index).secondary_quantity
3197: WHERE reservation_id = l_reservation_id;
3198: END IF;

Line 3443: FROM mtl_reservations

3439: IF (g_output_process_tbl(l_index-1).reservation_id IS NOT NULL AND l_allocate_lot_flag <> 'Y') THEN
3440: BEGIN
3441: SELECT lot_number
3442: INTO l_reserved_lot
3443: FROM mtl_reservations
3444: WHERE reservation_id = g_output_process_tbl(l_index-1).reservation_id;
3445: EXCEPTION
3446: WHEN No_Data_Found THEN
3447: l_reserved_lot := NULL;