APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_TYPE_DENORM_V

Line 865: jtf_qual_type_denorm_v inlv

861: jtf_terr_qual_all jtqa,
862: jtf_terr_values_all jtva,
863: jtf_qual_usgs_all jqua,
864: jtf_qual_type_usgs_all jqtu,
865: jtf_qual_type_denorm_v inlv
866: WHERE jta.terr_id = cl_terr_id
867: AND jtdr.terr_id = jta.terr_id
868: AND jtdr.related_terr_id = jtqa.terr_id
869: AND jtdr.source_id = cl_source_id

Line 922: jtf_qual_type_denorm_v inlv,

918: jtf_terr_qual_all jtqa,
919: jtf_terr_values_all jtva,
920: jtf_qual_usgs_all jqua,
921: jtf_qual_type_usgs_all jqtu,
922: jtf_qual_type_denorm_v inlv,
923: jtf_terr_cnr_groups cnrg,
924: jtf_terr_cnr_group_values cnrgv
925: WHERE jta.terr_id = cl_terr_id
926: AND jtdr.terr_id = jta.terr_id

Line 985: jtf_qual_type_denorm_v inlv

981: jtf_terr_qual_all jtqa,
982: jtf_terr_values_all jtva,
983: jtf_qual_usgs_all jqua,
984: jtf_qual_type_usgs_all jqtu,
985: jtf_qual_type_denorm_v inlv
986: WHERE jta.terr_id = cl_terr_id
987: AND jtdr.terr_id = jta.terr_id
988: AND jtdr.related_terr_id = jtqa.terr_id
989: AND jtqa.terr_qual_id = jtva.terr_qual_id

Line 1039: jtf_qual_type_denorm_v inlv,

1035: jtf_terr_qual_all jtqa,
1036: jtf_terr_values_all jtva,
1037: jtf_qual_usgs_all jqua,
1038: jtf_qual_type_usgs_all jqtu,
1039: jtf_qual_type_denorm_v inlv,
1040: jtf_terr_cnr_groups cnrg,
1041: jtf_terr_cnr_group_values cnrgv
1042: WHERE jta.terr_id = cl_terr_id
1043: AND jtdr.terr_id = jta.terr_id

Line 2259: FROM jtf_qual_type_denorm_v

2255: AND i2.org_id = -3113
2256: AND i2.qual_type_usg_id = i3.qual_type_usg_id
2257: AND i3.source_id = p_source_id
2258: AND i3.qual_type_id in (SELECT related_id
2259: FROM jtf_qual_type_denorm_v
2260: WHERE qual_type_id = l_qual_type_id_tbl(i)));
2261:
2262: l_qual_type_id_tbl.TRIM(l_no_of_records);
2263: