**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 decode(instr(Prog_Code, 'ORGU'), 0, Prog_Code, upper(program_directory)) = 'LABACC' ) ORDER BY REPLACE (REPLACE(REPLACE(UPPER(Company_Name),'"',''),'�','A'),'�','O'), Standard_Id, Company_Id**
Ampro Laboratories
Laboratory Accreditation Program

Clayton County Water Authority
Laboratory Accreditation Program

Environmental Labs & Services, Inc.
Laboratory Accreditation Program

U.S. NavSta, Rota, Spain
Laboratory Accreditation Program

Number of matching Laboratories is 4
Processing time was 0 seconds