DBA Data[Home] [Help]

APPS.ETRM_SEARCH dependencies on FND_VIEWS

Line 138: from fnd_views

134: cursor cur_view(n_appid in fnd_tables.application_id%type
135: , n_tabid in fnd_tables.table_id%type) is
136: select view_name
137: , description
138: from fnd_views
139: where application_id = n_appid
140: and view_id = n_tabid;
141:
142:

Line 195: from fnd_views c1

191:
192: v_stmt :=
193: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
194: select application_id, view_id, ''VW''
195: from fnd_views c1
196: where catsearch(c1.description, :search, null) > 0';
197:
198: execute immediate v_stmt using c_search;
199: