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 633: FROM mtl_reservations

629: SELECT sum(primary_reservation_quantity)
630: , sum(secondary_reservation_quantity)
631: INTO g_item_non_inv_rsv(p_mo_line_rec.inventory_item_id)
632: , g_item_sec_non_inv_rsv(p_mo_line_rec.inventory_item_id)
633: FROM mtl_reservations
634: WHERE organization_id = p_mo_line_rec.organization_id
635: AND inventory_item_id = p_mo_line_rec.inventory_item_id
636: AND supply_source_type_id <> INV_Reservation_GLOBAL.g_source_type_inv
637: AND demand_source_line_detail IS NULL;

Line 646: FROM mtl_reservations

642: SELECT nvl(sum(primary_reservation_quantity),0)
643: , nvl(sum(secondary_reservation_quantity),0)
644: INTO l_non_inv_reservations_qty
645: , l_non_inv_sec_reservation_qty
646: FROM mtl_reservations
647: WHERE demand_source_line_id = p_demand_info.oe_line_id
648: AND organization_id = p_mo_line_rec.organization_id
649: AND inventory_item_id = p_mo_line_rec.inventory_item_id
650: AND demand_source_type_id = p_demand_source_type

Line 1292: UPDATE mtl_reservations

1288: print_debug('New rsv qty: ' || l_new_rsv_quantity, 'Inv_Pick_Release_PVT.Process_Reservations');
1289: print_debug('New sec rsv qty: ' || l_new_sec_rsv_quantity, 'Inv_Pick_Release_PVT.Process_Reservations');
1290: END IF;
1291:
1292: UPDATE mtl_reservations
1293: SET primary_reservation_quantity = l_new_prim_rsv_quantity
1294: ,reservation_quantity = l_new_rsv_quantity
1295: ,secondary_reservation_quantity = l_new_sec_rsv_quantity
1296: WHERE reservation_id = l_org_wide_res_id;

Line 3129: UPDATE mtl_reservations

3125: print_debug('1 New prim rsv qty: ' || l_new_prim_rsv_quantity,'Inv_Pick_Release_PVT.Process_Line');
3126: print_debug('New rsv qty: ' || l_new_rsv_quantity,'Inv_Pick_Release_PVT.Process_Line');
3127: print_debug('New sec rsv qty: ' || l_new_sec_rsv_quantity,'Inv_Pick_Release_PVT.Process_Line');
3128: END IF;
3129: UPDATE mtl_reservations
3130: SET primary_reservation_quantity = l_new_prim_rsv_quantity
3131: ,reservation_quantity = l_new_rsv_quantity
3132: ,secondary_reservation_quantity = l_new_sec_rsv_quantity -- Bug 6989438
3133: WHERE reservation_id = l_reservation_id;

Line 3271: UPDATE mtl_reservations

3267: /* bug 7253296 - error in quantity tree */
3268: /*l_demand_rsvs_ordered(l_res_ordered_index).primary_reservation_quantity := l_new_prim_rsv_quantity;
3269: l_demand_rsvs_ordered(l_res_ordered_index).reservation_quantity := l_new_rsv_quantity;
3270:
3271: UPDATE mtl_reservations
3272: SET primary_reservation_quantity = l_new_prim_rsv_quantity
3273: ,reservation_quantity = l_new_rsv_quantity
3274: WHERE reservation_id = l_demand_rsvs_ordered(l_res_ordered_index).reservation_id;*/
3275:

Line 3532: UPDATE mtl_reservations

3528: print_debug('l_rsv_detailed_qty_conv '|| l_rsv_detailed_qty_conv, 'Inv_Pick_Release_PVT.Process_Line');
3529: print_debug('l_rsv_detailed_qty2 '|| l_rsv_detailed_qty2, 'Inv_Pick_Release_PVT.Process_Line');
3530: END IF;
3531:
3532: UPDATE mtl_reservations
3533: SET reservation_quantity = greatest(reservation_quantity, l_rsv_detailed_qty_conv) -- Bug Fix 5624514
3534: , primary_reservation_quantity = greatest(primary_reservation_quantity, l_reservation_detailed_qty)
3535: , secondary_reservation_quantity = greatest(secondary_reservation_quantity, l_rsv_detailed_qty2)
3536: , detailed_quantity = l_reservation_detailed_qty