APPS.INV_TRANSACTIONS_HISTORY_PKG dependencies on MTL_ADJUSTMENT_SYNC_TEMP

Line 290: from mtl_adjustment_sync_temp

286:
287: if p_txns_history_rec.document_type ='ADJ' then --added for onhand
288: select count(*)
289: into l_dummy
290: from mtl_adjustment_sync_temp
291: where entity_id = p_txns_history_rec.entity_number;
292:
293: if (g_debug = 1) then
294: inv_trx_util_pub.TRACE('temp table count: '||l_dummy, 'INV_TRANSACTIONS_HISTORY_PKG', 9);

Line 303: from mtl_adjustment_sync_temp

299: xml_document_id = p_txns_history_rec.entity_number
300: WHERE NVL(transaction_extracted, 'N') = 'P'
301: AND xml_document_id is null
302: AND transaction_id IN (select transaction_number
303: from mtl_adjustment_sync_temp
304: where entity_id = p_txns_history_rec.entity_number);
305:
306: if (g_debug = 1) then
307: inv_trx_util_pub.TRACE('No of rows in MMT updated: '||SQL%ROWCOUNT, 'INV_TRANSACTIONS_HISTORY_PKG', 9);