APPS.FND_IMUTL dependencies on FND_LOBS

Line 167: selc := 'select /*+index(lob FND_LOBS_CTX) USE_NL(lob hd)*/ round( (0 '||selc||')/'||sccnt||', 0 ) pct,';

163: -------------------------------------------
164: -- Finish the dynamic score and or clauses --
165: -------------------------------------------
166: if (sccnt > 0) then
167: selc := 'select /*+index(lob FND_LOBS_CTX) USE_NL(lob hd)*/ round( (0 '||selc||')/'||sccnt||', 0 ) pct,';
168: else
169: selc := 'select 100 pct,'; -- should never get here --
170: end if;
171:

Line 311: delete from fnd_lobs l

307:
308: ------------------------------
309: -- delete any orphaned rows --
310: ------------------------------
311: delete from fnd_lobs l
312: where program_name = 'FND_HELP'
313: and not exists (select 'x' from fnd_help_documents d
314: where l.file_id = d.file_id);
315:

Line 317: where not exists (select 'x' from fnd_lobs l

313: and not exists (select 'x' from fnd_help_documents d
314: where l.file_id = d.file_id);
315:
316: delete from fnd_help_documents d
317: where not exists (select 'x' from fnd_lobs l
318: where l.file_id = d.file_id);
319:
320: delete from fnd_help_targets t
321: where not exists (select 'x' from fnd_help_documents d

Line 600: selc := 'select /*+index(lob FND_LOBS_CTX) USE_NL(lob hd)*/ score(1) pct,';

596: end loop;
597:
598: if (contain_op is not null ) then
599: andc := 'AND contains('|| icol ||',''' || contain_op ||''',1)>0';
600: selc := 'select /*+index(lob FND_LOBS_CTX) USE_NL(lob hd)*/ score(1) pct,';
601: else
602: andc := 'AND 1=2';
603: selc := 'select 100 pct,'; -- should never get here --
604: end if;