delete from tbl_TPM_Claims where ownerType = 'MFR' and ownerId = 2252 delete from tbl_TPM_Requests where ownerType = 'MFR' and ownerId = 2252 delete from tbl_TPM_RequestProducts where ownerType = 'MFR' and ownerId = 2252 delete from tbl_TPM_Contracts where ownerType = 'MFR' and ownerId = 2252 delete from tbl_MFR_TPF_Detail_MFR2252 where mfr_id = 2252 and forecast_status = 'C'