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_GEN_PVT dependencies on JTF_TTY_TERR_GROUPS

Line 454: FROM JTF_TTY_TERR_GROUPS A

450: , A.catch_all_resource_type
451: , A.generate_catchall_flag
452: , A.NUM_WINNERS /* JDOCHERT: 07/29/03: BUG#3072230 */
453: , B.ORG_ID
454: FROM JTF_TTY_TERR_GROUPS A
455: , JTF_TERR_ALL B
456: WHERE A.parent_terr_id = b.terr_id
457: AND ( a.active_to_date >= SYSDATE OR a.active_to_date IS NULL )
458: AND a.active_from_date <= SYSDATE;

Line 904: from jtf_tty_terr_groups g

900:
901: /* does Territory Group have at least 1 Named Account? */
902: SELECT COUNT(*)
903: INTO l_na_count
904: from jtf_tty_terr_groups g
905: , jtf_tty_terr_grp_accts ga
906: , jtf_tty_named_accts a
907: where g.terr_group_id = ga.terr_group_id
908: AND ga.named_account_id = a.named_account_id