APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_RESERVATIONS

Line 473: from mtl_reservations mr

469: AND wdd.released_status in ('R', 'B') and wdd.replenishment_status = 'R'
470: -- there might not be reservation
471: AND NOT EXISTS
472: (select 1
473: from mtl_reservations mr
474: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
475: and MR.DEMAND_SOURCE_HEADER_ID =
476: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
477: and MR.demand_source_type_id =

Line 960: from mtl_reservations mr

956: ------------------------
957:
958: -- Get Q1
959: SELECT nvl(sum(mr.reservation_QUANTITY),0) INTO l_rsvd_demand_qty
960: from mtl_reservations mr
961: ,WMS_REPL_DEMAND_GTMP WRDG
962: WHERE mr.organization_id = wrdg.organization_id
963: and mr.inventory_item_id = wrdg.inventory_item_id
964: and MR.DEMAND_SOURCE_LINE_ID = wrdg.DEMAND_line_ID

Line 2120: from mtl_reservations mr

2116: and nvl(wdd.replenishment_status, 'C') = 'C'
2117: -- there might not be reservation
2118: AND not exists
2119: (select 1
2120: from mtl_reservations mr
2121: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
2122: and MR.DEMAND_SOURCE_HEADER_ID =
2123: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
2124: AND MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed -- Exclude detailed RSV

Line 5106: -- Check if rsv exists for the current demand line from table mtl_reservations

5102: IF (l_debug = 1) THEN
5103: PRINT_DEBUG('Enough Qty - Consuming this demand :' ||L_demand_line_detail_id);
5104: END IF;
5105:
5106: -- Check if rsv exists for the current demand line from table mtl_reservations
5107: -- Use Query_reservation() API
5108: -- Make sure that if rsv exists all qty must be either high level rsv or must be all completely detailed.
5109: -- Lets say that we get l_existing_rsv_qty from MR table for current demand which
5110: -- should be less than or equal to l_demand_qty

Line 5234: UPDATE mtl_reservations

5230: print_debug('Detail High Level Rsv to Detailed CURRENT sub :'
5231: || x_consol_item_repl_tbl(i).repl_to_subinventory_code);
5232: END IF;
5233: FORALL k in 1 .. l_rsv_rec.COUNT()
5234: UPDATE mtl_reservations
5235: SET subinventory_code = x_consol_item_repl_tbl(i).repl_to_subinventory_code
5236: WHERE reservation_id = l_rsv_id_tb(k);
5237:
5238:

Line 6452: from mtl_reservations mr

6448: AND wdd.released_status in ('R', 'B') and wdd.replenishment_status = 'R'
6449: -- there might not be reservation
6450: AND NOT EXISTS
6451: (select 1
6452: from mtl_reservations mr
6453: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
6454: and MR.DEMAND_SOURCE_HEADER_ID =
6455: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
6456: and MR.demand_source_type_id =