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_GEOGRAPHIES

Line 86: from jtf_tty_geographies g,

82: g.City_code city,
83: g.postal_code postal_code,
84: terr.geo_terr_name geo_terr_name,
85: terrv.geo_terr_value_id tv_id
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

Line 131: jtf_tty_geographies g --postal_code level

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
135: and terr.terr_group_id = tg.terr_group_id

Line 158: jtf_tty_geographies g, --postal_code level

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

Line 159: jtf_tty_geographies g1,

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

Line 160: jtf_tty_geographies g2

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
162: rsc.resource_id = l_rsc_id -- user works in this geo terr
163: and rsc.geo_territory_id = terr.geo_territory_id
164: and terr.terr_group_id = tg.terr_group_id

Line 188: jtf_tty_geographies g,

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
192: and rsc.geo_territory_id = terr.geo_territory_id

Line 189: jtf_tty_geographies g1

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
192: and rsc.geo_territory_id = terr.geo_territory_id
193: and terr.terr_group_id = tg.terr_group_id

Line 247: jtf_tty_geographies g,

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
249: where
250: rsc.resource_id = l_rsc_id
251: and rsc.geo_territory_id = terr.geo_territory_id

Line 407: jtf_tty_geographies g

403: --grpv.comparison_operator, grpv.geo_type, grpv.geo_id_from, geo_id_to, terr.geo_territory_id terr_id
404: from jtf_tty_geo_terr terr,
405: jtf_tty_geo_terr_rsc rsc,
406: jtf_tty_geo_grp_values grpv,
407: jtf_tty_geographies g
408: where rsc_id = rsc.resource_id
409: and rsc.geo_territory_id = terr.geo_territory_id
410: and terr.owner_resource_id <0
411: and terr.parent_geo_terr_id<0

Line 425: jtf_tty_geographies g, --postal_code level

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,
427: jtf_tty_geographies g2
428: where
429: rsc.resource_id = rsc_id -- user works in this geo terr

Line 426: jtf_tty_geographies g1,

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,
427: jtf_tty_geographies g2
428: where
429: rsc.resource_id = rsc_id -- user works in this geo terr
430: and rsc.geo_territory_id = terr.geo_territory_id

Line 427: jtf_tty_geographies g2

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,
427: jtf_tty_geographies g2
428: where
429: rsc.resource_id = rsc_id -- user works in this geo terr
430: and rsc.geo_territory_id = terr.geo_territory_id
431: and terr.terr_group_id = tg.terr_group_id

Line 448: jtf_tty_geographies g,

444: select count(g.postal_code) exist
445: from jtf_tty_geo_terr terr,
446: jtf_tty_geo_terr_rsc rsc,
447: jtf_tty_geo_grp_values grpv,
448: jtf_tty_geographies g,
449: jtf_tty_geographies g1
450: where rsc_id = rsc.resource_id
451: and rsc.geo_territory_id = terr.geo_territory_id
452: and terr.owner_resource_id <0

Line 449: jtf_tty_geographies g1

445: from jtf_tty_geo_terr terr,
446: jtf_tty_geo_terr_rsc rsc,
447: jtf_tty_geo_grp_values grpv,
448: jtf_tty_geographies g,
449: jtf_tty_geographies g1
450: where rsc_id = rsc.resource_id
451: and rsc.geo_territory_id = terr.geo_territory_id
452: and terr.owner_resource_id <0
453: and terr.parent_geo_terr_id<0

Line 553: jtf_tty_geographies geog

549: select terr.geo_territory_id into terr_id
550: from jtf_tty_geo_terr terr,
551: jtf_tty_geo_terr_values terrv,
552: jtf_tty_geo_terr_rsc rsc,
553: jtf_tty_geographies geog
554: where terr.geo_territory_id = terrv.geo_territory_id
555: and terrv.geo_id = geog.geo_id
556: and geog.postal_code = p_postal_code /* the PC is in the terr she works in */
557: and rsc.geo_territory_id = terr.geo_territory_id /* the terr she works in */

Line 629: jtf_tty_geographies geog

625:
626: select count(geog.postal_code) into found --geog.postal_code, terr.geo_terr_name
627: from jtf_tty_geo_terr terr,
628: jtf_tty_geo_terr_values terrv,
629: jtf_tty_geographies geog
630: where terr.owner_resource_id = rsc_id
631: and terr.geo_territory_id = terrv.geo_territory_id
632: and terrv.geo_id = geog.geo_id
633: and geog.postal_code = p_postal_code

Line 684: from jtf_tty_geographies

680: end if;
681:
682: -- m: geo_id
683: select geo_id into m -- geo_id
684: from jtf_tty_geographies
685: where postal_code=p_postal_code;
686:
687: begin
688: -- terr_id