".TB_PREF."wo_requirements.stock_id = ".TB_PREF."stock_master.stock_id
WHERE workorder_id=$woid
AND ".TB_PREF."locations.loc_code = ".TB_PREF."wo_requirements.loc_code
- AND ".TB_PREF."workcentres.id=CAST(workcentre AS UNSIGNED)";
+ AND ".TB_PREF."workcentres.id=workcentre";
return db_query($sql, "The work order requirements could not be retrieved");
}