APPS.JTF_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_USGS_ALL

Line 320: , jtf_qual_usgs_all jqu

316: else
317: SELECT count(*)
318: INTO l_num_qual_tbl(i)
319: FROM jtf_terr_qual_all jtq
320: , jtf_qual_usgs_all jqu
321: , jtf_qual_type_usgs jqtu
322: , jtf_qual_type_denorm_v v
323: WHERE jtq.qual_usg_id = jqu.qual_usg_id
324: AND ( (jtq.org_id = jqu.org_id) OR

Line 653: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3

649: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
650: WHERE o.terr_qual_id IN (
651: SELECT /*+ INDEX (i2 jtf_qual_usgs_n1) */
652: i1.terr_qual_id
653: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
654: WHERE i1.qual_usg_id = i2.qual_usg_id
655: AND i2.display_type = 'CHAR'
656: AND i2.lov_sql IS NULL
657: AND i2.org_id = -3113