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

Line 452: FROM JTF_TTY_TERR_GROUPS A

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

Line 905: from jtf_tty_terr_groups g

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

Line 918: from jtf_tty_terr_groups tgrp

914:
915: /* does Territory Group have at least 1 Geo Territory ? */
916: SELECT COUNT(*)
917: INTO l_na_count
918: from jtf_tty_terr_groups tgrp
919: , jtf_tty_geo_grp_values gterr
920: where tgrp.terr_group_id = gterr.terr_group_id
921: AND ROWNUM < 2;
922:

Line 3843: jtf_tty_terr_groups tg,

3839: select g.postal_code postal_code,
3840: g.geo_id geo_id
3841: , terr.geo_territory_id
3842: from jtf_tty_geo_grp_values grpv,
3843: jtf_tty_terr_groups tg,
3844: jtf_tty_geo_terr terr,
3845: jtf_tty_geographies g --postal_code level
3846: where terr.terr_group_id = tg.terr_group_id
3847: and terr.terr_group_id = grpv.terr_group_id

Line 3869: jtf_tty_terr_groups tg,

3865: select g.postal_code postal_code,
3866: g.geo_id geo_id
3867: , terr.geo_territory_id
3868: from jtf_tty_geo_grp_values grpv,
3869: jtf_tty_terr_groups tg,
3870: jtf_tty_geo_terr terr,
3871: jtf_tty_geographies g,
3872: jtf_tty_geographies g1
3873: where terr.terr_group_id = tg.terr_group_id

Line 3918: from jtf_tty_terr_groups tg,

3914: union
3915: select g.postal_code postal_code,
3916: g.geo_id geo_id
3917: , terr.geo_territory_id
3918: from jtf_tty_terr_groups tg,
3919: jtf_tty_geo_terr terr,
3920: jtf_tty_geographies g,
3921: jtf_tty_geo_terr_values tv
3922: where terr.terr_group_id = tg.terr_group_id