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_GEO_TERR_RSC

Line 130: jtf_tty_geo_terr_rsc rsc,

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
133: rsc.resource_id = l_rsc_id -- user works in this geo terr
134: and rsc.geo_territory_id = terr.geo_territory_id

Line 157: jtf_tty_geo_terr_rsc rsc,

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,
160: jtf_tty_geographies g2
161: where

Line 187: jtf_tty_geo_terr_rsc rsc,

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
190: where
191: rsc.resource_id = l_rsc_id -- user works in this geo terr

Line 254: jtf_tty_geo_terr_rsc rsc,

250: null terr_name,
251: g.geo_id geo_id
252: from jtf_tty_terr_groups tg,
253: jtf_tty_geo_terr terr,
254: jtf_tty_geo_terr_rsc rsc,
255: jtf_tty_geographies g,
256: jtf_tty_geo_terr_values tv
257: where
258: rsc.resource_id = l_rsc_id

Line 413: jtf_tty_geo_terr_rsc rsc,

409: CURSOR CheckPCInDefTerr(rsc_id IN NUMBER, p_pc varchar2) IS
410: select count(g.postal_code) exist --, terr.geo_territory_id terr_id
411: --grpv.comparison_operator, grpv.geo_type, grpv.geo_id_from, geo_id_to, terr.geo_territory_id terr_id
412: from jtf_tty_geo_terr terr,
413: jtf_tty_geo_terr_rsc rsc,
414: jtf_tty_geo_grp_values grpv,
415: jtf_tty_geographies g
416: where rsc_id = rsc.resource_id
417: and rsc.geo_territory_id = terr.geo_territory_id

Line 432: jtf_tty_geo_terr_rsc rsc,

428: select count(g.postal_code) exist /* postal code range*/
429: from jtf_tty_geo_grp_values grpv,
430: jtf_tty_terr_groups tg,
431: jtf_tty_geo_terr terr,
432: jtf_tty_geo_terr_rsc rsc,
433: jtf_tty_geographies g, --postal_code level
434: jtf_tty_geographies g1,
435: jtf_tty_geographies g2
436: where

Line 454: jtf_tty_geo_terr_rsc rsc,

450: AND g.geo_name BETWEEN g1.geo_name and g2.geo_name
451: union
452: select count(g.postal_code) exist
453: from jtf_tty_geo_terr terr,
454: jtf_tty_geo_terr_rsc rsc,
455: jtf_tty_geo_grp_values grpv,
456: jtf_tty_geographies g,
457: jtf_tty_geographies g1
458: where rsc_id = rsc.resource_id

Line 572: jtf_tty_geo_terr_rsc rsc,

568: -- check if a regular terr the user working on has the postal code.
569: select terr.geo_territory_id into terr_id
570: from jtf_tty_geo_terr terr,
571: jtf_tty_geo_terr_values terrv,
572: jtf_tty_geo_terr_rsc rsc,
573: jtf_tty_geographies geog
574: where terr.geo_territory_id = terrv.geo_territory_id
575: and terrv.geo_id = geog.geo_id
576: and geog.postal_code = p_postal_code /* the PC is in the terr she works in */