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

Line 90: jtf_tty_terr_groups tg

86: from jtf_tty_geographies g,
87: jtf_tty_geo_terr terr,
88: jtf_tty_geo_terr pterr,
89: jtf_tty_geo_terr_values terrv,
90: jtf_tty_terr_groups tg
91: where terrv.geo_territory_id = terr_id
92: and terrv.geo_territory_id = terr.geo_territory_id
93: and terr.parent_geo_terr_id = pterr.geo_territory_id(+)
94: and terrv.geo_id = g.geo_id

Line 106: jtf_tty_terr_groups tg,

102: tg.terr_group_name territory_group,
103: pterr.geo_terr_name manager_terr_name,
104: terr.geo_terr_name geo_terr_name
105: from jtf_tty_geo_grp_values grpv,
106: jtf_tty_terr_groups tg,
107: jtf_tty_geo_terr terr,
108: jtf_tty_geo_terr pterr
109: where terr.geo_territory_id =terr_id
110: and terr.terr_group_id = tg.terr_group_id

Line 128: jtf_tty_terr_groups tg,

124: g.postal_code postal_code,
125: null terr_name,
126: g.geo_id geo_id
127: from jtf_tty_geo_grp_values grpv,
128: jtf_tty_terr_groups tg,
129: jtf_tty_geo_terr terr,
130: jtf_tty_geo_terr_rsc rsc,
131: jtf_tty_geographies g --postal_code level
132: where

Line 155: jtf_tty_terr_groups tg,

151: g.postal_code postal_code,
152: null terr_name,
153: g.geo_id geo_id
154: from jtf_tty_geo_grp_values grpv,
155: jtf_tty_terr_groups tg,
156: jtf_tty_geo_terr terr,
157: jtf_tty_geo_terr_rsc rsc,
158: jtf_tty_geographies g, --postal_code level
159: jtf_tty_geographies g1,

Line 185: jtf_tty_terr_groups tg,

181: g.postal_code postal_code,
182: null terr_name,
183: g.geo_id geo_id
184: from jtf_tty_geo_grp_values grpv,
185: jtf_tty_terr_groups tg,
186: jtf_tty_geo_terr terr,
187: jtf_tty_geo_terr_rsc rsc,
188: jtf_tty_geographies g,
189: jtf_tty_geographies g1

Line 244: from jtf_tty_terr_groups tg,

240: g.City_code city,
241: g.postal_code postal_code,
242: null terr_name,
243: g.geo_id geo_id
244: from jtf_tty_terr_groups tg,
245: jtf_tty_geo_terr terr,
246: jtf_tty_geo_terr_rsc rsc,
247: jtf_tty_geographies g,
248: jtf_tty_geo_terr_values tv

Line 422: jtf_tty_terr_groups tg,

418:
419: union
420: select count(g.postal_code) exist /* postal code range*/
421: from jtf_tty_geo_grp_values grpv,
422: jtf_tty_terr_groups tg,
423: jtf_tty_geo_terr terr,
424: jtf_tty_geo_terr_rsc rsc,
425: jtf_tty_geographies g, --postal_code level
426: jtf_tty_geographies g1,