APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_TYPE_DENORM_V

Line 781: jtf_qual_type_denorm_v inlv

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
782: WHERE jta.terr_id = cl_terr_id
783: AND jtdr.terr_id = jta.terr_id
784: AND jtdr.related_terr_id = jtqa.terr_id
785: AND jtdr.source_id = cl_source_id

Line 838: jtf_qual_type_denorm_v inlv,

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,
839: jtf_terr_cnr_groups cnrg,
840: jtf_terr_cnr_group_values cnrgv
841: WHERE jta.terr_id = cl_terr_id
842: AND jtdr.terr_id = jta.terr_id

Line 901: jtf_qual_type_denorm_v inlv

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
902: WHERE jta.terr_id = cl_terr_id
903: AND jtdr.terr_id = jta.terr_id
904: AND jtdr.related_terr_id = jtqa.terr_id
905: AND jtqa.terr_qual_id = jtva.terr_qual_id

Line 955: jtf_qual_type_denorm_v inlv,

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,
956: jtf_terr_cnr_groups cnrg,
957: jtf_terr_cnr_group_values cnrgv
958: WHERE jta.terr_id = cl_terr_id
959: AND jtdr.terr_id = jta.terr_id

Line 2134: FROM jtf_qual_type_denorm_v

2130: AND i2.org_id = -3113
2131: AND i2.qual_type_usg_id = i3.qual_type_usg_id
2132: AND i3.source_id = p_source_id
2133: AND i3.qual_type_id in (SELECT related_id
2134: FROM jtf_qual_type_denorm_v
2135: WHERE qual_type_id = l_qual_type_id_tbl(i)));
2136:
2137: l_qual_type_id_tbl.TRIM(l_no_of_records);
2138: