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'
