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 317: delete from fnd_lobs l

313:
314: ------------------------------
315: -- delete any orphaned rows --
316: ------------------------------
317: delete from fnd_lobs l
318: where program_name = 'FND_HELP'
319: and not exists (select 'x' from fnd_help_documents d
320: where l.file_id = d.file_id);
321:

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

319: and not exists (select 'x' from fnd_help_documents d
320: where l.file_id = d.file_id);
321:
322: delete from fnd_help_documents d
323: where not exists (select 'x' from fnd_lobs l
324: where l.file_id = d.file_id);
325:
326: delete from fnd_help_targets t
327: where not exists (select 'x' from fnd_help_documents d

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

602: end loop;
603:
604: if (contain_op is not null ) then
605: andc := 'AND contains('|| icol ||',''' || contain_op ||''',1)>0';
606: selc := 'select /*+index(lob FND_LOBS_CTX) USE_NL(lob hd)*/ score(1) pct,';
607: else
608: andc := 'AND 1=2';
609: selc := 'select 100 pct,'; -- should never get here --
610: end if;