Especially for those who loves Designer, or who are forced to work with it.. :-( ,  2 scripts to search in de source-code of Designer (version 10.1.2.4):

Script 1 can be used for searching text-strings in the source of pl/sql in Designer.
Script 2 can be used to search for the use of column-names in modules.

Run this as the owner of the repository.

With thanks to Timo Schijf,  developer.

Script1 : Searching in  pl-sql code

set feedback off
set pages 50000
set lines 300
set trimspool on
set verify off

break on modulename skip 1

select name “Workareas:”
from sdd_workareas
;

prompt
prompt
accept workarea_name default ‘GLOBAL SHARED WORKAREA’ char prompt ‘Name of Workarea [Default: GLOBAL SHARED WORKAREA] : ‘

prompt
prompt
accept searchstring char prompt ‘Text-string : ‘

begin
jr_context.set_workarea (’&&workarea_name’);
end;
/

select distinct name “Applications in this workarea:”
from ci_application_systems
;

zv7qrnb