APPS.ETRM_SEARCH dependencies on FND_COLUMNS

Line 165: v_column_name fnd_columns.column_name%type;

161: vl_col_count va_col_count;
162:
163:
164: v_table_name fnd_tables.table_name%type;
165: v_column_name fnd_columns.column_name%type;
166: v_description fnd_tables.description%type;
167:
168: v_display_count number(3) := 150;
169: v_return_value number(8);

Line 179: from fnd_columns c1

175: begin
176: v_stmt :=
177: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
178: select application_id, table_id, ''COL''
179: from fnd_columns c1
180: where catsearch(c1.description, :search, null) > 0';
181:
182: execute immediate v_stmt using c_search;
183: