delete from bprl_fifotransaction where m_costing_id in (select m_costing_id from m_costing where m_product_id='1d36c1b51c31030905eff3cc50b40eae');
delete from m_costing where m_product_id='1d36c1b51c31030905eff3cc50b40eae';
update m_transaction
set transactioncost=null, iscostcalculated='N', c_currency_id=null, costing_status='NC', isprocessed='N', m_costing_algorithm_id=null
where m_product_id='1d36c1b51c31030905eff3cc50b40eae';
delete from bprl_fifotransaction where m_costing_id in (select m_costing_id from m_costing where m_product_id='65CAB3EADE974FD284F9491DB16BA176');
delete from m_costing where m_product_id='65CAB3EADE974FD284F9491DB16BA176';
update m_transaction
set transactioncost=null, iscostcalculated='N', c_currency_id=null, costing_status='NC', isprocessed='N', m_costing_algorithm_id=null
where m_product_id='65CAB3EADE974FD284F9491DB16BA176';