eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_ALL

Line 419: , jtf_terr_all jt

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
423: AND NVL(jt.start_date_active, lp_sysdate - 1) < lp_sysdate

Line 445: , jtf_terr_all jt

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
449: AND NVL(jt.start_date_active, lp_sysdate - 1) < lp_sysdate

Line 1050: Add_To_PackageTable (' '' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) '' || ' );

1046: --
1047: --
1048:
1049: Add_To_PackageTable (' '' ) o '' || ' );
1050: Add_To_PackageTable (' '' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) '' || ' );
1051: Add_To_PackageTable (' '' ) WT '' || ' );
1052: Add_To_PackageTable (' '' , jtf_terr_rsc_all jtra '' || ' );
1053: Add_To_PackageTable (' '' , jtf_terr_rsc_access_all jtraa '' || ' );
1054: Add_To_PackageTable (' '' WHERE '' || ' );

Line 1272: Add_To_PackageTable (' '' (ROWNUM <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = ilv1.top_level_terr_id) ) '' || ' );

1268: Add_To_PackageTable (' '' ) ilv1 '' || ' );
1269: Add_To_PackageTable (' '' WHERE ilv1.top_level_terr_id = jtr.top_level_terr_id '' || ' );
1270: Add_To_PackageTable (' '' AND ilv1.trans_id = jtr.trans_id '' || ' );
1271: Add_To_PackageTable (' '' AND ( '' || ' );
1272: Add_To_PackageTable (' '' (ROWNUM <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = ilv1.top_level_terr_id) ) '' || ' );
1273: Add_To_PackageTable (' '' ) '' || ' );
1274: Add_To_PackageTable (' '' ) AS JTF_TERR_NUMBER_LIST ) ) '' || ' );
1275: Add_To_PackageTable (' '' WHERE 1 = 1 '' || ' );
1276: Add_To_PackageTable (' '' AND jtr.terr_id = COLUMN_VALUE '' || ' );

Line 1437: , jtf_terr_all jt1

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
1440: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1441: AND jqtu.qual_type_id = p_qualifier_type_id

Line 1454: FROM jtf_terr_all jt

1450: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
1451: AND jtrs.terr_id = jt1.terr_id )
1452: AND NOT EXISTS (
1453: SELECT jt.terr_id
1454: FROM jtf_terr_all jt
1455: WHERE NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate
1456: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1457: START WITH jt.terr_id = jt1.terr_id)
1458: AND jqtu.qual_type_id <> -1001

Line 1476: , jtf_terr_all jt1

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
1479: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
1480: AND jqtu.qual_type_id = p_qualifier_type_id

Line 1493: FROM jtf_terr_all jt

1489: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
1490: AND jtrs.terr_id = jt1.terr_id )
1491: AND NOT EXISTS (
1492: SELECT jt.terr_id
1493: FROM jtf_terr_all jt
1494: WHERE NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate
1495: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
1496: START WITH jt.terr_id = jt1.terr_id)
1497: AND jqtu.qual_type_id <> -1001;