- $sql = "SELECT ".TB_PREF."wo_requirements.*, ".TB_PREF."stock_master.description,
- ".TB_PREF."stock_master.mb_flag,
- ".TB_PREF."locations.location_name,
- ".TB_PREF."workcentres.name AS WorkCentreDescription FROM
- (".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres) INNER JOIN ".TB_PREF."stock_master ON
- ".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)";
+ $sql = "SELECT req.*, item.description, item.mb_flag, loc.location_name,
+ center.name AS WorkCentreDescription,
+ item.material_cost as ComponentCost,
+ item.inventory_account,
+ item.cogs_account
+ FROM (".TB_PREF."wo_requirements req,"
+ .TB_PREF."locations loc,"
+ .TB_PREF."workcentres center)
+ INNER JOIN ".TB_PREF."stock_master item ON req.stock_id=item.stock_id
+ WHERE workorder_id=".db_escape($woid)."
+ AND loc.loc_code = req.loc_code
+ AND center.id=workcentre";