APPS.INV_PICK_RELEASE_PVT dependencies on MTL_RESERVATIONS

Line 79: FROM mtl_reservations

75: If NOT p_ignore_reservations THEN
76: -- Bug 4494038: exclude crossdock reservations
77: SELECT sum(reservation_quantity - detailed_quantity)
78: INTO l_quantity_reserved
79: FROM mtl_reservations
80: WHERE demand_source_line_id = p_demand_line_id
81: AND inventory_item_id = p_inventory_item_id
82: AND organization_id = p_org_id
83: AND nvl(staged_flag,'N') <> 'Y'

Line 588: FROM mtl_reservations

584: SELECT sum(primary_reservation_quantity)
585: , sum(secondary_reservation_quantity)
586: INTO g_item_non_inv_rsv(p_mo_line_rec.inventory_item_id)
587: , g_item_sec_non_inv_rsv(p_mo_line_rec.inventory_item_id)
588: FROM mtl_reservations
589: WHERE organization_id = p_mo_line_rec.organization_id
590: AND inventory_item_id = p_mo_line_rec.inventory_item_id
591: AND supply_source_type_id <> INV_Reservation_GLOBAL.g_source_type_inv
592: AND demand_source_line_detail IS NULL;

Line 601: FROM mtl_reservations

597: SELECT nvl(sum(primary_reservation_quantity),0)
598: , nvl(sum(secondary_reservation_quantity),0)
599: INTO l_non_inv_reservations_qty
600: , l_non_inv_sec_reservation_qty
601: FROM mtl_reservations
602: WHERE demand_source_line_id = p_demand_info.oe_line_id
603: AND organization_id = p_mo_line_rec.organization_id
604: AND inventory_item_id = p_mo_line_rec.inventory_item_id
605: AND demand_source_type_id = p_demand_source_type

Line 1148: UPDATE mtl_reservations

1144: print_debug('New sec rsv qty: ' || l_new_sec_rsv_quantity, 'Inv_Pick_Release_PVT.Process_Reservations');
1145: print_debug('New rsv qty: ' || l_new_rsv_quantity, 'Inv_Pick_Release_PVT.Process_Reservations');
1146: END IF;
1147:
1148: UPDATE mtl_reservations
1149: SET primary_reservation_quantity = l_new_prim_rsv_quantity
1150: ,reservation_quantity = l_new_rsv_quantity
1151: ,secondary_reservation_quantity = l_new_sec_rsv_quantity
1152: WHERE reservation_id = l_org_wide_res_id;

Line 2716: UPDATE mtl_reservations

2712: print_debug('New prim rsv qty: ' || l_new_prim_rsv_quantity,'Inv_Pick_Release_PVT.Process_Line');
2713: print_debug('New rsv qty: ' || l_new_rsv_quantity,'Inv_Pick_Release_PVT.Process_Line');
2714: END IF;
2715:
2716: UPDATE mtl_reservations
2717: SET primary_reservation_quantity = l_new_prim_rsv_quantity
2718: ,reservation_quantity = l_new_rsv_quantity
2719: WHERE reservation_id = l_reservation_id;
2720:

Line 2825: UPDATE mtl_reservations

2821: /* bug 7253296 - error in quantity tree */
2822: /*l_demand_rsvs_ordered(l_res_ordered_index).primary_reservation_quantity := l_new_prim_rsv_quantity;
2823: l_demand_rsvs_ordered(l_res_ordered_index).reservation_quantity := l_new_rsv_quantity;
2824:
2825: UPDATE mtl_reservations
2826: SET primary_reservation_quantity = l_new_prim_rsv_quantity
2827: ,reservation_quantity = l_new_rsv_quantity
2828: WHERE reservation_id = l_demand_rsvs_ordered(l_res_ordered_index).reservation_id;*/
2829:

Line 3050: UPDATE mtl_reservations

3046: END IF;
3047: -- Upper tolerance may lead to allocation above the reservation
3048: -- {{ Test Case # UTK-REALLOC-3.2.6:64 }}
3049: -- Description: If allocation is greater than reservation, increase the reserved quantity
3050: UPDATE mtl_reservations
3051: SET reservation_quantity = greatest(reservation_quantity, l_rsv_detailed_qty_conv) -- Bug Fix 5624514
3052: , secondary_reservation_quantity = greatest(secondary_reservation_quantity, l_rsv_detailed_qty2)
3053: , detailed_quantity = l_reservation_detailed_qty
3054: , secondary_detailed_quantity = l_rsv_detailed_qty2