APPS.JTF_TERR_JSP_LOV_RECS_PUB dependencies on JTF_SOURCES

Line 326: from jtf_sources

322:
323: -- Get the total count for display
324: SELECT count(*)
325: INTO l_total_count
326: from jtf_sources
327: where UPPER(meaning) like NVL(l_column1, '%');
328:
329: OPEN lov_output_cur FOR
330: Select WF_NOTIFICATION.SubstituteSpecialChars(meaning), source_id, null, null, null,

Line 334: from jtf_sources

330: Select WF_NOTIFICATION.SubstituteSpecialChars(meaning), source_id, null, null, null,
331: null, null, null, null, null,
332: null, null, null, null, null,
333: null, null, null, null, null
334: from jtf_sources
335: where UPPER(meaning) like NVL(l_column1, '%')
336: order by meaning;
337:
338: elsif p_record_group_name = 'ENABLED_QUALS' then

Line 435: jtf_qual_types_all jqt ,jtf_sources_all js

431: jsq.seeded_qual_id, null, null, null, null,
432: null, null, null, null, null,
433: null, null, null, null, null
434: FROM jtf_qual_usgs_all jqu, jtf_seeded_qual_all_b jsq,jtf_qual_type_usgs_all jqtu,
435: jtf_qual_types_all jqt ,jtf_sources_all js
436: WHERE jqu.use_in_lookup_flag = 'Y'
437: and jqu.enabled_flag = 'Y'
438: and jqtu.qual_type_id = jqt.qual_type_id
439: and jqtu.qual_type_usg_id = jqu.qual_type_usg_id