finding the webadi integrators having upload type as PROCEDURE

select substr(intg.INTEGRATOR_CODE,1,length(intg.INTEGRATOR_CODE)-5) integrator, attribute1, attribute2
  from bne_interfaces_vl intf
     , bne_integrators_vl intg
     , bne_attributes att
 where intf.integrator_code = intg.integrator_code
   and intf.upload_type = 2
   and intg.enabled_flag = 'Y'
   and substr(intg.INTEGRATOR_CODE,1,length(intg.INTEGRATOR_CODE)-5)||'_P0_ATT' = att.ATTRIBUTE_CODE
   and upper(attribute1) = 'PROCEDURE'