select distinct ac.name,ac.line
  from all_source ac
 where ac.OWNER ='DBOWNERNAME' and
       lower(ac.TEXT) like '%TABLE_NAME%';