APPS.JTF_TERR_JSP_LOV_RECS_PUB dependencies on JTF_SEEDED_QUAL_USGS_V

Line 350: from jtf_seeded_qual_usgs_v

346:
347: -- Get the total count for display
348: SELECT count(*)
349: INTO l_total_count
350: from jtf_seeded_qual_usgs_v
351: where UPPER(seeded_qual_name) like NVL(l_column1, '%') || '%'
352: -- and source_id = l_column2
353: and enabled_flag = 'Y';
354:

Line 361: from jtf_seeded_qual_usgs_v jsquv

357: jsquv.source_id, jsquv.qual_col1_alias,
358: null, null, null, null, null,
359: null, null, null, null, null,
360: null, null, null, null, null
361: from jtf_seeded_qual_usgs_v jsquv
362: where UPPER(seeded_qual_name) like NVL(l_column1, '%') || '%'
363: and source_id = NVL(l_column2, source_id)
364: and enabled_flag = 'Y'
365: order by jsquv.source_id, sqname;

Line 420: from jtf_seeded_qual_usgs_v

416: qual_col1_alias, display_type,
417: seeded_qual_id, null, null, null, null,
418: null, null, null, null, null,
419: null, null, null, null, null
420: from jtf_seeded_qual_usgs_v
421: where use_in_lookup_flag = 'Y'
422: and enabled_flag = 'Y'
423: and source_id = -1001
424: ARPATEL BUG#3736597 fix