/** Rank Calculator 3 186 Threats Global Impact not Correct 
******/

SELECT 
    sn.scientific_name 
  , eg.element_global_id   
  , eg.elcode_bcd   
  , dtic.threat_impact_calc_cd overall_impact_calc_cd 
  , dtia.threat_impact_assigned_cd overall_impact_assigned_cd 
  , egr.g_impact_adjustment_reasons  
  , dtc.iucn_threat_category_cd 
  , dtc.iucn_threat_category_desc    
  , dtic2. threat_impact_calc_cd 
  , dtic2. threat_impact_calc_desc 
  , dtsc.display_value scope_cd 
  , dtse.display_value severity_cd 
  , dtt.display_value  timing_cd 
  , ta.g_iucn_threat_comments 
, d_maintained_by_status.maintained_by_status_cd
FROM 
    EL_GLOBAL_THREATS_ASSESS ta
  , element_global eg 
 
 
  , scientific_name sn 
  , element_global_rank egr
  , d_iucn_threat_category dtc 
  , d_threat_impact_assigned dtia
  , d_threat_impact_calc dtic
  , d_threat_impact_calc dtic2
  , d_iucn_threat_scope dtsc 
  , d_iucn_threat_severity dtse 
  , d_iucn_threat_timing dtt 
 , d_maintained_by_status
WHERE
  
   ta.element_global_id = eg.element_global_id 
  and eg.gname_id = sn.scientific_name_id 
  and ta.element_global_id = egr.element_global_id (+) 
  and ta.d_iucn_threat_category_id = dtc.d_iucn_threat_category_id 
  and egr.d_threat_impact_assigned_id = dtia.d_threat_impact_assigned_id (+)
  and egr.d_threat_impact_calc_id = dtic.d_threat_impact_calc_id (+)
  and ta.d_threat_impact_calc_id = dtic2.d_threat_impact_calc_id (+)
  and ta.d_iucn_threat_scope_id = dtsc.d_iucn_threat_scope_id (+)
  and ta.d_iucn_threat_severity_id = dtse.d_iucn_threat_severity_id (+)
  and ta.d_iucn_threat_timing_id = dtt.d_iucn_threat_timing_id (+)
 /*** and dtc.IUCN_THREAT = 'Y'   /* Limit to IUCN threats */ 
 and eg.inactive_ind = 'N' /* EXCLUDE INACTIVES */
and eg.d_maintained_by_status_id = d_maintained_by_status.d_maintained_by_status_id
  
  and (
  
  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 1)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 5)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 8)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 5)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 5)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 8)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 8)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 8)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 2)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 3)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 5)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 8)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 2)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 5)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 8)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 2)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 3)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 3)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 3)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 6)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 7)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 9)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 10)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 1 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 2 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 3 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 4 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 5 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 6 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 7 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 8 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 9 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id in( 1,2,3,4,5,6,7,8,9 ) and dtse.d_iucn_threat_severity_id in ( 1,2,3,4,5,6,7,8,9) and dtt.d_iucn_threat_timing_id in( 3,4,9) and ta.d_threat_impact_calc_id != 12)
or  (dtsc.d_iucn_threat_scope_id in( 1,2,3,4,5,6,7,8,9 ) and dtse.d_iucn_threat_severity_id in ( 1,2,3,4,5,6,7,8,9) and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 14)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id is null and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id is not null)
or  (dtsc.d_iucn_threat_scope_id in (1,2,3,4,5,6,7,8,9) and dtse.d_iucn_threat_severity_id is null and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id is not null)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id in ( 1,2,3,4,5,6,7,8,9) and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id is not null)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 1 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 2 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 3 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 4 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 5 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 6 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 7 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 8 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 9 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 1 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 2 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 3 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 4 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 5 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 6 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 7 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 8 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 9 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 1 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 2 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 3 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 4 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 5 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 6 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 7 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 8 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 9 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 1 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 2 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 3 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 4 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 5 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 6 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 7 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 8 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 9 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 1 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 2 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 3 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 4 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 5 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 6 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 7 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 8 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 9 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id is null and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 12)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id is null and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 14)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id is null and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id is null and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id is null and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id is null and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id = 11 and dtse.d_iucn_threat_severity_id is null and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id = 10 and dtse.d_iucn_threat_severity_id is null and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 11 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 10 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 12 and (dtt.d_iucn_threat_timing_id not in (3, 4, 9, 10) or dtt.d_iucn_threat_timing_id is null) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id in (3,4,9) and ta.d_threat_impact_calc_id != 13)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 11 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 11)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 10 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 15)
or  (dtsc.d_iucn_threat_scope_id is null and dtse.d_iucn_threat_severity_id = 12 and dtt.d_iucn_threat_timing_id = 10 and ta.d_threat_impact_calc_id != 13)
    

)

  
  ORDER BY
  sn.scientific_name, dtc.display_order