APPS.INV_MO_BACKORDER_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 169: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt

165:
166: CURSOR c_allow_backordering IS
167: SELECT 'N' FROM DUAL
168: WHERE EXISTS( SELECT 1
169: FROM wms_dispatched_tasks wdt, mtl_material_transactions_temp mmtt
170: WHERE mmtt.move_order_line_id = l_mo_line_rec.line_id
171: AND wdt.transaction_temp_id = nvl(mmtt.parent_line_id, mmtt.transaction_temp_id)
172: AND wdt.status IN (4,9));
173:

Line 187: FROM mtl_material_transactions_temp mmtt

183: , ABS(mmtt.primary_quantity) primary_quantity
184: , ABS(mmtt.transaction_quantity) transaction_quantity
185: , ABS(mmtt.secondary_transaction_quantity) secondary_transaction_quantity
186: , mmtt.reservation_id
187: FROM mtl_material_transactions_temp mmtt
188: WHERE mmtt.move_order_line_id = p_line_id
189: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp t
190: WHERE t.parent_line_id = mmtt.transaction_temp_id)
191: FOR UPDATE NOWAIT;

Line 189: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp t

185: , ABS(mmtt.secondary_transaction_quantity) secondary_transaction_quantity
186: , mmtt.reservation_id
187: FROM mtl_material_transactions_temp mmtt
188: WHERE mmtt.move_order_line_id = p_line_id
189: AND NOT EXISTS (SELECT 1 FROM mtl_material_transactions_temp t
190: WHERE t.parent_line_id = mmtt.transaction_temp_id)
191: FOR UPDATE NOWAIT;
192:
193: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);