APPS.JTF_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_TYPE_USGS_ALL

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