126: FOR UPDATE NOWAIT;
127:
128: CURSOR c_dispatched_task IS
129: SELECT status
130: FROM wms_dispatched_tasks
131: WHERE (l_parent_line_id IS NULL AND transaction_temp_id = l_transaction_temp_id)
132: OR (l_parent_line_id IS NOT NULL AND transaction_temp_id = l_parent_line_id);
133:
134: -- INVCONV - Added Qty2
1287: , mmtt.reservation_id
1288: FROM mtl_material_transactions_temp mmtt
1289: WHERE mmtt.move_order_line_id = p_line_id
1290: AND NOT EXISTS( SELECT 'Y'
1291: FROM wms_dispatched_tasks wdt
1292: WHERE wdt.transaction_temp_id
1293: = nvl( mmtt.parent_line_id
1294: , mmtt.transaction_temp_id
1295: )