APPS.JTF_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_QTYPE_USGS_ALL

Line 418: FROM jtf_terr_qtype_usgs_all jtqu

414: AND jqtu.qual_type_id = v.related_id
415: AND jqu.rule1 IS NOT NULL
416: AND v.qual_type_id = lp_qual_type_id
417: AND EXISTS ( SELECT jtq.terr_id
418: FROM jtf_terr_qtype_usgs_all jtqu
419: , jtf_terr_all jt
420: , jtf_terr_qual_all jtq
421: , jtf_qual_type_usgs jqtu
422: WHERE NVL(jt.end_date_active, lp_sysdate + 1) > lp_sysdate

Line 444: , jtf_terr_qtype_usgs_all jtqu

440: AND jqu.rule2 IS NOT NULL
441: AND v.qual_type_id = lp_qual_type_id
442: AND EXISTS ( SELECT jtq.terr_id
443: FROM jtf_terr_values_all jtv
444: , jtf_terr_qtype_usgs_all jtqu
445: , jtf_terr_all jt
446: , jtf_terr_qual_all jtq
447: , jtf_qual_type_usgs jqtu
448: WHERE NVL(jt.end_date_active, lp_sysdate + 1) > lp_sysdate

Line 939: /* ARPATEL: 12/03/2003 for Oracle Sales we now use num_qual in jtf_terr_qtype_usgs_all */

935: --
936: Add_To_PackageTable (' GROUP BY ILV.terr_id, ilv.absolute_rank, ilv.top_level_terr_id ');
937: --
938:
939: /* ARPATEL: 12/03/2003 for Oracle Sales we now use num_qual in jtf_terr_qtype_usgs_all */
940: IF p_source_id = -1001
941: THEN
942: Add_To_PackageTable (' HAVING (ILV.terr_id, COUNT(*)) IN ( ');
943: Add_To_PackageTable (' SELECT ');

Line 947: Add_To_PackageTable (' ,jtf_terr_qtype_usgs_all jua ');

943: Add_To_PackageTable (' SELECT ');
944: Add_To_PackageTable (' jtw.terr_id ');
945: Add_To_PackageTable (' , jua.num_qual ' );
946: Add_To_PackageTable (' FROM jtf_terr_denorm_rules_all jtw ');
947: Add_To_PackageTable (' ,jtf_terr_qtype_usgs_all jua ');
948: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqa ');
949: Add_To_PackageTable (' WHERE jtw.source_id = lp_source_id');
950: Add_To_PackageTable (' AND jqa.source_id = jtw.source_id ');
951: Add_To_PackageTable (' AND jqa.qual_type_id = lp_qual_type_id ');

Line 1435: FROM jtf_terr_qtype_usgs_all jtqu

1431: BEGIN
1432:
1433: SELECT COUNT(*)
1434: INTO num_of_terr
1435: FROM jtf_terr_qtype_usgs_all jtqu
1436: , jtf_terr_usgs_all jtu
1437: , jtf_terr_all jt1
1438: , jtf_qual_type_usgs jqtu
1439: WHERE jtqu.terr_id = jt1.terr_id

Line 1474: FROM jtf_terr_qtype_usgs_all jtqu

1470: BEGIN
1471:
1472: SELECT COUNT(*)
1473: INTO num_of_terr
1474: FROM jtf_terr_qtype_usgs_all jtqu
1475: , jtf_terr_usgs_all jtu
1476: , jtf_terr_all jt1
1477: , jtf_qual_type_usgs jqtu
1478: WHERE jtqu.terr_id = jt1.terr_id