APPS.INV_MISSING_QTY_ACTIONS_ENGINE dependencies on MTL_AVAILABLE_INVENTORY_TEMP

Line 264: FROM mtl_available_inventory_temp

260: */
261: CURSOR c_sai_info IS
262: SELECT NVL(SUM(transaction_qty), 0) transaction_qty ,
263: NVL(SUM(secondary_transaction_qty), 0) secondary_transaction_qty
264: FROM mtl_available_inventory_temp
265: WHERE transaction_qty <> 0 ;
266:
267:
268: l_sai_info c_sai_info%ROWTYPE ;

Line 299: /* Start fix for Bug#9758641. Also consider records from mtl_available_inventory_temp.

295: WHEN OTHERS THEN
296: RAISE fnd_api.g_exc_unexpected_error;
297: END;
298:
299: /* Start fix for Bug#9758641. Also consider records from mtl_available_inventory_temp.
300: This is required since user can use select available inventory form to create new allocation
301: and update original allocation. Standard TMO form for sales order pick does not allow user
302: to enter brand new line on allocation block but user can use SAI form to do it. Hence the
303: need

Line 315: print_debug(' Sum of primary_qty from mtl_available_inventory_temp : ' || l_sai_info.transaction_qty ,l_api_name,g_info);

311: CLOSE c_sai_info ;
312:
313: print_debug('Parameter p_secondary_quantity = '|| p_secondary_quantity ,l_api_name,g_info);
314:
315: print_debug(' Sum of primary_qty from mtl_available_inventory_temp : ' || l_sai_info.transaction_qty ,l_api_name,g_info);
316: print_debug(' Sum of secondary_qty from mtl_available_inventory_temp : ' || l_sai_info.secondary_transaction_qty ,l_api_name,g_info);
317:
318: print_debug('sum of all allocations : '||l_mmtt_primary_qty_sum,l_api_name,g_info);
319: print_debug('sum of all secondary allocations : '||l_mmtt_secondary_qty_sum,l_api_name,g_info);

Line 316: print_debug(' Sum of secondary_qty from mtl_available_inventory_temp : ' || l_sai_info.secondary_transaction_qty ,l_api_name,g_info);

312:
313: print_debug('Parameter p_secondary_quantity = '|| p_secondary_quantity ,l_api_name,g_info);
314:
315: print_debug(' Sum of primary_qty from mtl_available_inventory_temp : ' || l_sai_info.transaction_qty ,l_api_name,g_info);
316: print_debug(' Sum of secondary_qty from mtl_available_inventory_temp : ' || l_sai_info.secondary_transaction_qty ,l_api_name,g_info);
317:
318: print_debug('sum of all allocations : '||l_mmtt_primary_qty_sum,l_api_name,g_info);
319: print_debug('sum of all secondary allocations : '||l_mmtt_secondary_qty_sum,l_api_name,g_info);
320: