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
;

prompt
prompt
accept app_name char prompt ‘Application : ‘

spool script1.log

set serveroutput on size 100000

col modulename for a20
col type for a16
col plsqlblock for a200

select plm.short_name modulename
, plm.plsql_module_type type
, nvl(txt.txt_text, ‘An empty PL/SQL block’) plsqlblock
from ci_plsql_modules plm
, sdd_folder_members mem
, sdd_folders fld
, rm_text_lines txt
where mem.member_object=plm.irid
and mem.folder_reference=fld.irid
and mem.ownership_flag = ‘Y’
and fld.name = upper ( ‘&&app_name’)
and txt.txt_type(+) = ‘CDIPLS’
and txt.pac_ref(+) = plm.irid
and txt.txt_text like ‘%&&searchstring%’
order by 2,1
/

spool off

set feedback on
clear breaks

undefine app_name
undefine workarea_name

Script 2:  Searching for use of column-names in Forms- and Report Modules.

set feedback off

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

break on applicatie on modulename on shortname skip 1

prompt
prompt Searching for use of column-names in Forms- and Report Modules

prompt
prompt
accept tablename char prompt ‘Table_name : ‘

prompt
prompt
accept columname char prompt ‘Column_name : ‘

spool script2.log

set serveroutput on size 100000

col application for a20
col modulename for a50
col shortname for a12
col modulecomponent for a20

select fld.name application
,gm.name modulename
,gm.short_name shortname
,u.name modulecomponent
from ci_table_definitions t
,ci_columns col
,ci_data_bound_items dbi
,ci_module_detail_table_usages dtu
,ci_module_units u
,ci_general_modules gm
,sdd_folder_members mem
,sdd_folders fld
where col.table_reference = t.id
and dbi.column_reference = col.id
and dtu.id = dbi.detail_table_usage_reference
and u.id = dtu.module_unit_reference
and u.general_module_reference = gm.irid
and mem.member_object = gm.irid
and mem.folder_reference = fld.irid
and mem.ownership_flag = ‘Y’
and t.name = upper (’&&tablename’)
and col.name = upper (’&&columnname’)
order by 1,2,3
/

spool off

set feedback on
clear breaks

undefine tablename
undefine columnname