**SELECT DISTINCT * FROM (SELECT DISTINCT Company_Id, Cus_Seq, Company_Name, Url_name, Prog_Code, Program_Id, Decode(standard_id, 'SAEJ2975', 'Friction_Materials',Program_Directory) Program_Directory, CASE WHEN standard_id IN ('173GMPCM', '173GMPDF', '173GMPMF', '173GMPPC', '173GMPPF', '229GMPCM', '229GMPDF', '229GMPMF', '229GMPPF', '306GMPCM', '306GMPDF', '306GMPMF', '306GMPPF', 'GMP') THEN 'GMP' ELSE standard_id END AS Standard_Id, CASE WHEN standard_id IN ('173GMPCM', '173GMPDF', '173GMPMF', '173GMPPC', '173GMPPF', '229GMPCM', '229GMPDF', '229GMPMF', '229GMPPF', '306GMPCM', '306GMPDF', '306GMPMF', '306GMPPF', 'GMP') THEN 'Dietary Supplements Good Manufacturing Practices' ELSE standard_desc END AS Standard_Desc, '' Performance_Standard_Search FROM OLS_Company WHERE 1=1 AND Listings.TRANSLATE_STR_UPDATED(UPPER(Company_Name)) LIKE '%'||Listings.TRANSLATE_STR_UPDATED(UPPER('HUATAI'))||'%' ) ORDER BY REPLACE (REPLACE(REPLACE(UPPER(Company_Name),'"',''),'�','A'),'�','O'), Standard_Id, Company_Id**
No Matching Manufacturers Found