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_GEOGRAPHIES

Line 3845: jtf_tty_geographies g --postal_code level

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
3848: and terr.owner_resource_id < 0
3849: and terr.parent_geo_terr_id < 0 -- default terr

Line 3871: jtf_tty_geographies g,

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
3874: and terr.terr_group_id = grpv.terr_group_id
3875: and terr.owner_resource_id < 0

Line 3872: jtf_tty_geographies g1

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
3874: and terr.terr_group_id = grpv.terr_group_id
3875: and terr.owner_resource_id < 0
3876: and terr.parent_geo_terr_id < 0 -- default terr

Line 3920: jtf_tty_geographies g,

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
3923: and terr.owner_resource_id >= 0
3924: and terr.parent_geo_terr_id >= 0 -- not default terr