APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_QUAL_ALL

Line 777: jtf_terr_qual_all jtqa,

773: jtdr.end_date,
774: count(*) over(partition by jtqa.qual_usg_id)
775: FROM jtf_terr_all jta,
776: jtf_terr_denorm_rules_all jtdr,
777: jtf_terr_qual_all jtqa,
778: jtf_terr_values_all jtva,
779: jtf_qual_usgs_all jqua,
780: jtf_qual_type_usgs_all jqtu,
781: jtf_qual_type_denorm_v inlv

Line 834: jtf_terr_qual_all jtqa,

830: jtdr.end_date,
831: count(*) over(partition by jtqa.qual_usg_id)
832: FROM jtf_terr_all jta,
833: jtf_terr_denorm_rules_all jtdr,
834: jtf_terr_qual_all jtqa,
835: jtf_terr_values_all jtva,
836: jtf_qual_usgs_all jqua,
837: jtf_qual_type_usgs_all jqtu,
838: jtf_qual_type_denorm_v inlv,

Line 897: jtf_terr_qual_all jtqa,

893: jtdr.end_date,
894: count(*) over(partition by jtqa.qual_usg_id)
895: FROM jtf_terr_all jta,
896: jty_denorm_dea_rules_all jtdr,
897: jtf_terr_qual_all jtqa,
898: jtf_terr_values_all jtva,
899: jtf_qual_usgs_all jqua,
900: jtf_qual_type_usgs_all jqtu,
901: jtf_qual_type_denorm_v inlv

Line 951: jtf_terr_qual_all jtqa,

947: jtdr.end_date,
948: count(*) over(partition by jtqa.qual_usg_id)
949: FROM jtf_terr_all jta,
950: jty_denorm_dea_rules_all jtdr,
951: jtf_terr_qual_all jtqa,
952: jtf_terr_values_all jtva,
953: jtf_qual_usgs_all jqua,
954: jtf_qual_type_usgs_all jqtu,
955: jtf_qual_type_denorm_v inlv,

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

2122: SET o.first_char = SUBSTR(o.low_value_char, 1, 1)
2123: WHERE o.terr_qual_id IN (
2124: SELECT /*+ INDEX (i2 jtf_qual_usgs_n3) */
2125: i1.terr_qual_id
2126: FROM jtf_terr_qual_all i1, jtf_qual_usgs_all i2, jtf_qual_type_usgs_all i3
2127: WHERE i1.qual_usg_id = i2.qual_usg_id
2128: AND i2.display_type = 'CHAR'
2129: AND i2.lov_sql IS NULL
2130: AND i2.org_id = -3113