APPS.WMS_REPLENISHMENT_PVT dependencies on MTL_RESERVATIONS

Line 474: from mtl_reservations mr

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

Line 975: FROM mtl_reservations mr ,

971: -- as Q2 and Q3 values are fetched in primary UOM
972:
973: SELECT NVL(SUM(mr.primary_reservation_quantity),0)
974: INTO l_rsvd_demand_qty
975: FROM mtl_reservations mr ,
976: (select distinct organization_id, inventory_item_id,
977: demand_line_id, demand_header_id
978: from WMS_REPL_DEMAND_GTMP
979: where inventory_item_id = l_item_id

Line 1133: FROM mtl_reservations mr

1129: EXIT WHEN c_item_demand_lines%notfound;
1130:
1131: SELECT NVL(SUM(mr.primary_reservation_quantity),0)
1132: INTO l_rsvd_demand_line_qty
1133: FROM mtl_reservations mr
1134: WHERE mr.organization_id =l_org_id
1135: AND mr.inventory_item_id =l_item_id
1136: AND MR.DEMAND_SOURCE_LINE_ID = l_demand_line_id
1137: AND MR.DEMAND_SOURCE_HEADER_ID = l_demand_header_id;

Line 2180: from mtl_reservations mr

2176: and nvl(wdd.replenishment_status, 'C') = 'C'
2177: -- there might not be reservation
2178: AND not exists
2179: (select 1
2180: from mtl_reservations mr
2181: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
2182: and MR.DEMAND_SOURCE_HEADER_ID =
2183: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
2184: AND MR.SUBINVENTORY_CODE IS NOT NULL) --locator is not needed -- Exclude detailed RSV

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

5269: IF (l_debug = 1) THEN
5270: PRINT_DEBUG('Enough Qty - Consuming this demand :' ||L_demand_line_detail_id);
5271: END IF;
5272:
5273: -- Check if rsv exists for the current demand line from table mtl_reservations
5274: -- Use Query_reservation() API
5275: -- Make sure that if rsv exists all qty must be either high level rsv or must be all completely detailed.
5276: -- Lets say that we get l_existing_rsv_qty from MR table for current demand which
5277: -- should be less than or equal to l_demand_qty

Line 5403: UPDATE mtl_reservations

5399: print_debug('Detail High Level Rsv to Detailed CURRENT sub :'
5400: || x_consol_item_repl_tbl(i).repl_to_subinventory_code);
5401: END IF;
5402: FORALL k in 1 .. l_rsv_rec.COUNT()
5403: UPDATE mtl_reservations
5404: SET subinventory_code = x_consol_item_repl_tbl(i).repl_to_subinventory_code
5405: WHERE reservation_id = l_rsv_id_tb(k);
5406:
5407:

Line 6623: from mtl_reservations mr

6619: AND wdd.released_status in ('R', 'B') and wdd.replenishment_status = 'R'
6620: -- there might not be reservation
6621: AND NOT EXISTS
6622: (select 1
6623: from mtl_reservations mr
6624: WHERE MR.DEMAND_SOURCE_LINE_ID = wdd.source_line_id
6625: and MR.DEMAND_SOURCE_HEADER_ID =
6626: inv_salesorder.get_salesorder_for_oeheader(wdd.source_header_id)
6627: and MR.demand_source_type_id =