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 255: jtf_tty_geographies g,

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

Line 415: jtf_tty_geographies g

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
418: and terr.owner_resource_id <0
419: and terr.parent_geo_terr_id<0

Line 433: jtf_tty_geographies g, --postal_code level

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

Line 434: jtf_tty_geographies g1,

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
437: rsc.resource_id = rsc_id -- user works in this geo terr
438: and rsc.geo_territory_id = terr.geo_territory_id

Line 435: jtf_tty_geographies g2

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
437: rsc.resource_id = rsc_id -- user works in this geo terr
438: and rsc.geo_territory_id = terr.geo_territory_id
439: and terr.terr_group_id = tg.terr_group_id

Line 456: jtf_tty_geographies g,

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
459: and rsc.geo_territory_id = terr.geo_territory_id
460: and terr.owner_resource_id <0

Line 457: jtf_tty_geographies g1

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
459: and rsc.geo_territory_id = terr.geo_territory_id
460: and terr.owner_resource_id <0
461: and terr.parent_geo_terr_id<0

Line 573: jtf_tty_geographies geog

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 */
577: and rsc.geo_territory_id = terr.geo_territory_id /* the terr she works in */

Line 649: jtf_tty_geographies geog

645:
646: select count(geog.postal_code) into found --geog.postal_code, terr.geo_terr_name
647: from jtf_tty_geo_terr terr,
648: jtf_tty_geo_terr_values terrv,
649: jtf_tty_geographies geog
650: where terr.owner_resource_id = rsc_id
651: and terr.geo_territory_id = terrv.geo_territory_id
652: and terrv.geo_id = geog.geo_id
653: and geog.postal_code = p_postal_code

Line 704: from jtf_tty_geographies

700: end if;
701:
702: -- m: geo_id
703: select geo_id into m -- geo_id
704: from jtf_tty_geographies
705: where postal_code=p_postal_code;
706:
707: begin
708: -- terr_id