300: DELETE FROM opi_dbi_inv_value_log
301: WHERE organization_id IN
302: (SELECT mmt.organization_id
303: FROM
304: mtl_material_transactions mmt,
305: opi_dbi_inv_value_log log2
306: WHERE log2.uncosted_trx_id = -99 -- Indicates that the organization needs lump-sum adjustment processing
307: AND log2.type = 'PCS'
308: AND log2.source = g_opi_cpcs_source