Jump to main content or area navigation.

Contact Us

TRI Explorer

Facility Profile Report Click for help on this criterion

Data Source: 2018 Updated Dataset (released October 2019) See Note     Instructions for printing wide reports

Exception -942 ORA-20000: select CASE WHEN SUM(TERRI.UNINJ_I) IS NULL and SUM(RCRA_C) IS NULL AND SUM(OTH_LANDF) IS NULL AND SUM(AIR_FUG) IS NULL AND SUM(AIR_STACK) IS NULL AND SUM(WATER) IS NULL AND SUM(UNINJ_IIV) IS NULL AND SUM(LAND_TREA) IS NULL AND SUM(SI_5_5_3A) IS NULL AND SUM(SI_5_5_3B) IS NULL AND SUM(OTH_DISP) IS NULL THEN NULL ELSE ROUND(SUM(NVL(TERRI.UNINJ_I,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(RCRA_C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(OTH_LANDF,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(AIR_FUG,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(AIR_STACK,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(WATER,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(UNINJ_IIV,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(LAND_TREA,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(SI_5_5_3A,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(SI_5_5_3B,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(OTH_DISP,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)),0) END AS TOTAL_ONSITE, CASE WHEN SUM(TERRI.OM81) IS NULL and SUM(TERRI.OM65) IS NULL AND SUM(TERRI.OM64) IS NULL AND SUM(TERRI.OM10) IS NULL AND SUM(TERRI.OM40M) IS NULL AND SUM(TERRI.OM41) IS NULL AND SUM(TERRI.OM61M) IS NULL AND SUM(TERRI.OM62) IS NULL and SUM(TERRI.P81D) IS NULL AND SUM(TERRI.OM82) IS NULL and SUM(TERRI.P81C) IS NULL AND SUM(TERRI.OM66) IS NULL and SUM(TERRI.OM67) IS NULL AND SUM(TERRI.OM73) IS NULL AND SUM(TERRI.OM79) IS NULL and SUM(TERRI.OM90) IS NULL AND SUM(TERRI.OM91) IS NULL AND SUM(TERRI.OM94) IS NULL and SUM(TERRI.OM99) IS NULL THEN NULL ELSE ROUND(SUM(NVL(TERRI.OM81,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM65,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM64,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM10,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM40M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM41,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM61M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM62,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81D,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM82,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM66,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM67,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM73,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM79,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM90,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM91,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM94,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM99,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)),0) END AS TOTAL_OFFSITE, CASE WHEN SUM(TERRI.UNINJ_I) IS NULL and SUM(TERRI.RCRA_C) IS NULL AND SUM(TERRI.OTH_LANDF) IS NULL AND SUM(TERRI.AIR_FUG) IS NULL AND SUM(TERRI.AIR_STACK) IS NULL AND SUM(TERRI.WATER) IS NULL AND SUM(TERRI.UNINJ_IIV) IS NULL AND SUM(TERRI.LAND_TREA) IS NULL AND SUM(TERRI.SI_5_5_3A) IS NULL AND SUM(TERRI.SI_5_5_3B) IS NULL AND SUM(TERRI.OTH_DISP) IS NULL AND SUM(TERRI.OM81) IS NULL and SUM(TERRI.OM65) IS NULL AND SUM(TERRI.OM64) IS NULL AND SUM(TERRI.OM10) IS NULL AND SUM(TERRI.OM40M) IS NULL AND SUM(TERRI.OM41) IS NULL AND SUM(TERRI.OM61M) IS NULL AND SUM(TERRI.OM62) IS NULL and SUM(TERRI.P81D) IS NULL AND SUM(TERRI.OM82) IS NULL AND SUM(TERRI.OM66) IS NULL and SUM(TERRI.OM67) IS NULL AND SUM(TERRI.OM73) IS NULL AND SUM(TERRI.OM79) IS NULL and SUM(TERRI.OM90) IS NULL AND SUM(TERRI.OM91) IS NULL AND SUM(TERRI.OM94) IS NULL and SUM(TERRI.OM99) IS NULL THEN NULL ELSE ROUND(SUM(NVL(TERRI.UNINJ_I,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(RCRA_C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(OTH_LANDF,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.AIR_FUG,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.AIR_STACK,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.WATER,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.UNINJ_IIV,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.LAND_TREA,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.SI_5_5_3A,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.SI_5_5_3B,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OTH_DISP,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM81,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM65,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM64,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM10,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM40M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM41,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM61M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM62,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.P81D,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM82,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM66,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM67,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM73,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM79,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM90,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM91,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM94,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(TERRI.OM99,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)),0) END AS TOTAL_ONOFFSITE, CASE WHEN SUM(M20) IS NULL AND SUM(M24) IS NULL AND SUM(M26) IS NULL AND SUM(M28) IS NULL AND SUM(M93) IS NULL AND SUM(M56) IS NULL AND SUM(M92) IS NULL AND SUM(M40NOM) IS NULL AND SUM(M50) IS NULL AND SUM(M54) IS NULL AND SUM(M61NOM) IS NULL AND SUM(M69) IS NULL AND SUM(M95) IS NULL AND SUM(PTRT) IS NULL AND SUM(P81D) IS NULL AND SUM(INV) IS NULL AND SUM(M81) IS NULL AND SUM(M82) IS NULL AND SUM(M71) IS NULL AND SUM(M65) IS NULL AND SUM(M64) IS NULL AND SUM(M10) IS NULL AND SUM(M41M) IS NULL AND SUM(M40M) IS NULL AND SUM(M62M) IS NULL AND SUM(M61M) IS NULL AND SUM(M66) IS NULL AND SUM(M67) IS NULL AND SUM(M63) IS NULL AND SUM(M73) IS NULL AND SUM(M79) IS NULL AND SUM(M90) IS NULL AND SUM(M94) IS NULL AND SUM(M91) IS NULL AND SUM(M99) IS NULL THEN NULL ELSE SUM(NVL(M20,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M24,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M26,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M28,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M93,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M56,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M92,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M40NOM,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M50,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M54,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M61NOM,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M69,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M95,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(P81D,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(INV,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M81,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M82,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M71,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M65,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M64,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M10,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M41,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M40M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M62,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M61M,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M66,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M67,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M63,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M73,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M79,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M90,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M94,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M91,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(M99,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(P81C,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) + SUM(NVL(PTRT,0) * decode(TERRI.TRI_CHEM_ID,'N150',0.002205,1)) end tot_tran_offsite from TRI_EX_RELEASE_REPORT_INFO TERRI where TERRI.TRI_FACILITY_ID = '68901FBRGLROUTE' and TERRI.REPORTING_YEAR = '1993' and TERRI.TRI_CHEM_ID <> 'N150'