".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
".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