select t.workspace, t.application_id, t.application_name, t.page_id, t.page_name, 'region button' type,  t.BUTTON_NAME, t.redirect_url, t2.TEMPLATE_NAME, t2.TEMPLATE, t.image_name
from apex_application_page_buttons t
   , apex_application_temp_button t2
where regexp_instr( t.redirect_url, '[^][a-zA-Z0-9!@#$?!#$%^*(),&.:;<>~`''{}/\+=-_ 	'||chr(13)||chr(10)||']' ) > 0
  and t.workspace != 'INTERNAL'
  and instr(lower(t.redirect_url),'javascript')>0
  and t.button_template_id = t2.button_template_id
  and ( dbms_lob.instr(t2.TEMPLATE,'onclick')=0 )
union all
select t.workspace, t.application_id, t.application_name, t.page_id, t.page_name, 'item button' type,  t.BUTTON_NAME, t2.source, t3.TEMPLATE_NAME, t3.TEMPLATE, t.image_name
from apex_application_page_buttons t
   , apex_040100.wwv_flow_step_items t2
   , apex_application_temp_button t3
where regexp_instr( t2.source, '[^][a-zA-Z0-9!@#$?!#$%^*(),&.:;<>~`''{}/\+=-_ 	'||chr(13)||chr(10)||']' ) > 0
  and t.workspace != 'INTERNAL'
  and t.button_action_code = 'SUBMIT'
  and t.button_id = t2.id
  
  and t.button_template_id = t3.button_template_id(+)
  and ( dbms_lob.instr(t3.TEMPLATE,'onclick')=0 
     or t3.TEMPLATE is null and t.image_name is not null )