APPS.INV_INVENTORY_ADJUSTMENT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 488: UPDATE mtl_material_transactions

484: if (g_debug = 1) then
485: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to P', 'INV_INVENTORY_ADJUSTMENT', 9);
486: end if;
487:
488: UPDATE mtl_material_transactions
489: SET transaction_extracted = 'P'
490: WHERE organization_id = p_org_id
491: AND NVL(transaction_extracted, 'N') NOT IN ( 'Y', 'P')
492: AND xml_document_id IS NULL

Line 528: UPDATE mtl_material_transactions

524: inv_trx_util_pub.TRACE('send_document failed', 'INV_INVENTORY_ADJUSTMENT', 9);
525: inv_trx_util_pub.TRACE('Updating mmt.transaction_extracted flag to null', 'INV_INVENTORY_ADJUSTMENT', 9);
526: end if;
527:
528: UPDATE mtl_material_transactions
529: SET transaction_extracted = null,
530: xml_document_id = null
531: WHERE organization_id = p_org_id
532: AND NVL(transaction_extracted, 'N') = 'P'