2862: UPDATE cst_misc_reconciliation cmr
2863: SET cmr.vendor_id = (
2864: SELECT mip.vendor_id
2865: FROM mtl_material_transactions mmt,
2866: mtl_intercompany_parameters mip,
2867: hr_organization_information hoi1,
2868: hr_organization_information hoi2
2869: WHERE mmt.transaction_id = cmr.inventory_transaction_id
2870: AND hoi1.org_information_context = 'Accounting Information'