APPS.WMS_RULE_PVT dependencies on MTL_RESERVATIONS

Line 1035: FROM mtl_reservations mr

1031: END IF;
1032:
1033: SELECT COUNT(*)
1034: INTO l_lpn_used
1035: FROM mtl_reservations mr
1036: WHERE mr.organization_id = p_organization_id
1037: AND mr.demand_source_type_id = 9 -- Cycle Count Reservation
1038: AND mr.lpn_id = p_lpn_id;
1039:

Line 4711: FROM mtl_reservations

4707: , detailed_quantity
4708: , reservation_uom_code
4709: , secondary_reservation_quantity
4710: , secondary_detailed_quantity
4711: FROM mtl_reservations
4712: WHERE reservation_id = p_reservation_id;
4713: -- and lot_number = g_locs(p_record_id).lot_number; -- Bug 7587155 - the reservation could be
4714: -- high level rather than detail.
4715:

Line 4891: FROM mtl_reservations

4887: IF (p_reservation_id IS NOT NULL) THEN -- Added for 14699845 (Flexible lot allocation)
4888: BEGIN
4889: SELECT lot_number
4890: INTO l_reserved_lot
4891: FROM mtl_reservations
4892: WHERE reservation_id = p_reservation_id;
4893: EXCEPTION
4894: WHEN NO_DATA_FOUND THEN
4895: l_reserved_lot := NULL;