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_QUAL_TYPE_USGS

Line 408: , jtf_qual_type_usgs jqtu

404: , lp_sysdate DATE ) IS
405:
406: SELECT jqu.qual_usg_id, jqu.rule1
407: FROM jtf_qual_usgs_all jqu
408: , jtf_qual_type_usgs jqtu
409: , jtf_qual_type_denorm_v v
410: WHERE --jqu.enabled_flag = 'Y'
411: jqu.org_id = -3113
412: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id

Line 421: , jtf_qual_type_usgs jqtu

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
424: AND jtqu.terr_id = jt.terr_id
425: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id

Line 433: , jtf_qual_type_usgs_all jqtu

429: UNION
430:
431: SELECT jqu.qual_usg_id, jqu.rule2
432: FROM jtf_qual_usgs_all jqu
433: , jtf_qual_type_usgs_all jqtu
434: , jtf_qual_type_denorm_v v
435: WHERE --jqu.enabled_flag = 'Y'
436: jqu.org_id = -3113
437: AND jqu.qual_type_usg_id = jqtu.qual_type_usg_id

Line 447: , jtf_qual_type_usgs jqtu

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
450: AND jtqu.terr_id = jt.terr_id
451: AND jtv.terr_qual_id = jtq.terr_qual_id

Line 948: Add_To_PackageTable (' ,jtf_qual_type_usgs_all jqa ');

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 ');
952: Add_To_PackageTable (' AND jtw.resource_exists_flag = ''Y'' ');

Line 1438: , jtf_qual_type_usgs jqtu

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
1442: AND jtu.source_id = p_source_id

Line 1477: , jtf_qual_type_usgs jqtu

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
1481: AND jtu.source_id = p_source_id