117: , ABS(mmtt.primary_quantity)
118: , ABS(mmtt.secondary_transaction_quantity) --INVCONV
119: , mmtt.reservation_id
120: , mmtt.parent_line_id
121: FROM mtl_material_transactions_temp mmtt
122: WHERE mmtt.move_order_line_id = p_line_id
123: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp t
124: WHERE t.parent_line_id = mmtt.transaction_temp_id)
125: ORDER BY mmtt.transaction_quantity ASC
119: , mmtt.reservation_id
120: , mmtt.parent_line_id
121: FROM mtl_material_transactions_temp mmtt
122: WHERE mmtt.move_order_line_id = p_line_id
123: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp t
124: WHERE t.parent_line_id = mmtt.transaction_temp_id)
125: ORDER BY mmtt.transaction_quantity ASC
126: FOR UPDATE NOWAIT;
127:
136: SELECT sum(primary_reservation_quantity),
137: sum(secondary_reservation_quantity)
138: FROM mtl_reservations
139: WHERE reservation_id IN (SELECT DISTINCT reservation_id
140: FROM mtl_material_transactions_temp
141: WHERE move_order_line_id = p_line_id);
142:
143: CURSOR c_wdd_requested_qty is
144: SELECT sum(requested_quantity), sum(requested_quantity2)--INVCONV
152: -- currently not being transacted.
153: --
154: CURSOR c_mmtt IS
155: SELECT mmtt.transaction_temp_id
156: FROM mtl_material_transactions_temp mmtt
157: WHERE mmtt.move_order_line_id = p_line_id
158: AND nvl(mmtt.transaction_status,1) = 2
159: FOR UPDATE NOWAIT;
160:
814: CLOSE c_mmtt_info;
815:
816: -- NULL out the Reservation ID in MMTT.
817: -- This delinks the Reservations from Allocations.
818: UPDATE mtl_material_transactions_temp
819: SET reservation_id = NULL
820: WHERE move_order_line_id = p_line_id;
821:
822: -- If all of the quantity for the move order line was deleted,
882: -- for this move_order_line_id
883: --
884: select count(*)
885: into l_count_alloc
886: from mtl_material_transactions_temp
887: where move_order_line_id = p_line_id;
888:
889: --
890: -- ER3969328: CI project.Only if this flag is set to 'Y'
1282: , ABS(mmtt.transaction_quantity)
1283: , ABS(mmtt.secondary_transaction_quantity)
1284: , ABS(mmtt.primary_quantity)
1285: , mmtt.reservation_id
1286: FROM mtl_material_transactions_temp mmtt
1287: WHERE mmtt.move_order_line_id = p_line_id
1288: AND NOT EXISTS( SELECT 'Y'
1289: FROM wms_dispatched_tasks wdt
1290: WHERE wdt.transaction_temp_id
2318: , l_reservation_id
2319: , l_organization_id
2320: , l_inventory_item_id
2321: , l_mo_uom_code
2322: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
2323: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
2324: AND mmtt.move_order_line_id = mtrl.line_id;
2325:
2326: -- find quantity to delete in primary UOM