[Home] [Help]
4367: END IF;
4368:
4369: SELECT inventory_item_id
4370: INTO l_inventory_item_id
4371: FROM mtl_reservations
4372: WHERE reservation_id = p_reservation_id;
4373:
4374: IF (l_debug = 1) THEN
4375: DEBUG('l_inventory_item_id: ' || l_inventory_item_id, 'EXPLODE_DELIVERY_DETAILS');
8138: END IF;
8139:
8140: --Calculate the reserved qty for the line set which curr line belongs to.
8141: SELECT nvl(SUM(nvl(primary_reservation_quantity,0)),0) INTO l_total_resvd_qty
8142: FROM mtl_reservations
8143: WHERE organization_id= p_org_id
8144: AND nvl(staged_flag,'N') = 'Y'
8145: AND demand_source_line_id in ( SELECT source_line_id
8146: FROM wsh_delivery_details wdd
9873: SELECT primary_reservation_quantity
9874: , reservation_id
9875: INTO l_chk_resv_qty
9876: , l_resv_id
9877: FROM mtl_reservations
9878: WHERE demand_source_line_id = p_order_line_id
9879: AND lpn_id = l_lpn_cont_rec.lpn_id
9880: AND NVL(revision, '@@@') = NVL(l_lpn_cont_rec.revision, '@@@')
9881: AND NVL(lot_number, '@@@') = NVL(l_lpn_cont_rec.lot_number, '@@@')
10947: -- get total reserved quantity for this line
10948: BEGIN
10949: SELECT SUM(primary_reservation_quantity)
10950: INTO l_total_resvd_qty
10951: FROM mtl_reservations
10952: WHERE demand_source_header_id = l_mtl_reservation_tab(l_index_r).demand_source_header_id
10953: AND demand_source_line_id = l_order_line_id
10954: AND demand_source_line_detail IS NULL
10955: AND nvl(staged_flag,'N') = 'Y'; --Bug#5262108
11198: -- get total reserved quantity for line
11199: BEGIN
11200: SELECT SUM(primary_reservation_quantity)
11201: INTO l_total_resvd_qty
11202: FROM mtl_reservations
11203: WHERE demand_source_header_id = l_demand_source_header_id
11204: AND demand_source_line_id = l_order_line_id
11205: AND demand_source_line_detail IS NULL
11206: AND NVL(staged_flag,'N') = 'Y' ;