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_GEO_TERR

Line 3789: FROM jtf_tty_geo_terr gterr

3785:
3786: CURSOR geo_territories( l_terr_group_id number) IS
3787: SELECT gterr.geo_territory_id
3788: , gterr.geo_terr_name
3789: FROM jtf_tty_geo_terr gterr
3790: WHERE gterr.terr_group_id = l_terr_group_id;
3791:
3792: /** Transaction Types for a NON-OVERLAY territory are
3793: ** determined by all salesteam members on this geography territories

Line 3803: JTF_TTY_GEO_TERR_RSC grsc

3799: */
3800: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
3801: SELECT ra.access_type
3802: FROM
3803: JTF_TTY_GEO_TERR_RSC grsc
3804: , jtf_tty_terr_grp_roles tgr
3805: , jtf_tty_role_access ra
3806: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
3807: AND grsc.rsc_role_code = tgr.role_code

Line 3813: JTF_TTY_GEO_TERR_RSC grsc

3809: AND ra.access_type IN ('ACCOUNT')
3810: UNION
3811: SELECT ra.access_type
3812: FROM
3813: JTF_TTY_GEO_TERR_RSC grsc
3814: , jtf_tty_terr_grp_roles tgr
3815: , jtf_tty_role_access ra
3816: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id
3817: AND grsc.rsc_role_code = tgr.role_code

Line 3844: jtf_tty_geo_terr terr,

3840: g.geo_id geo_id
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

Line 3870: jtf_tty_geo_terr terr,

3866: g.geo_id geo_id
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

Line 3919: jtf_tty_geo_terr terr,

3915: select g.postal_code postal_code,
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

Line 3921: jtf_tty_geo_terr_values tv

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
3925: and tv.geo_territory_id = terr.geo_territory_id

Line 3931: from jtf_tty_geo_terr terr,

3927: ) main
3928: where main.geo_id not in -- the terr the user owners
3929: (
3930: select tv.geo_id geo_id
3931: from jtf_tty_geo_terr terr,
3932: jtf_tty_geo_terr_values tv
3933: where
3934: tv.geo_territory_id = terr.geo_territory_id
3935: and main.geo_territory_id = terr.parent_geo_terr_id

Line 3932: jtf_tty_geo_terr_values tv

3928: where main.geo_id not in -- the terr the user owners
3929: (
3930: select tv.geo_id geo_id
3931: from jtf_tty_geo_terr terr,
3932: jtf_tty_geo_terr_values tv
3933: where
3934: tv.geo_territory_id = terr.geo_territory_id
3935: and main.geo_territory_id = terr.parent_geo_terr_id
3936: )

Line 3971: from jtf_tty_geo_terr_rsc a

3967: CURSOR terr_resource (l_geo_territory_id number,l_role varchar2) IS
3968: SELECT distinct a.resource_id
3969: , a.rsc_group_id
3970: , nvl(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
3971: from jtf_tty_geo_terr_rsc a
3972: , jtf_tty_geo_terr b
3973: where a.geo_territory_id = b.geo_territory_id
3974: and b.geo_territory_id = l_geo_territory_id
3975: and a.rsc_role_code = l_role;

Line 3972: , jtf_tty_geo_terr b

3968: SELECT distinct a.resource_id
3969: , a.rsc_group_id
3970: , nvl(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
3971: from jtf_tty_geo_terr_rsc a
3972: , jtf_tty_geo_terr b
3973: where a.geo_territory_id = b.geo_territory_id
3974: and b.geo_territory_id = l_geo_territory_id
3975: and a.rsc_role_code = l_role;
3976:

Line 4020: FROM jtf_tty_geo_terr gterr

4016:
4017: CURSOR get_OVLY_geographies(LP_terr_group_id number) IS
4018: SELECT gterr.geo_territory_id
4019: , gterr.geo_terr_name
4020: FROM jtf_tty_geo_terr gterr
4021: WHERE gterr.terr_group_id = lp_terr_group_id
4022: AND EXISTS (
4023: /* Salesperson, with Role that has a Product
4024: ** Interest defined, exists for this Named Account */

Line 4026: FROM jtf_tty_geo_terr_rsc grsc

4022: AND EXISTS (
4023: /* Salesperson, with Role that has a Product
4024: ** Interest defined, exists for this Named Account */
4025: SELECT NULL
4026: FROM jtf_tty_geo_terr_rsc grsc
4027: , jtf_tty_role_prod_int rpi
4028: , jtf_tty_terr_grp_roles tgr
4029: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
4030: AND tgr.terr_group_id = gterr.TERR_GROUP_ID

Line 4050: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

4046: and b.terr_group_id = lp_terr_group_id
4047: AND EXISTS (
4048: /* Named Account exists with Salesperson with this role */
4049: SELECT NULL
4050: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
4051: WHERE gterr.geo_territory_id = grsc.geo_territory_id
4052: AND grsc.geo_territory_id = lp_geo_territory_id
4053: AND gterr.terr_group_id = b.terr_group_id
4054: AND grsc.rsc_role_code = b.role_code );

Line 4453: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

4449: and b.terr_group_id = p_terr_group_rec.TERR_GROUP_ID
4450: AND EXISTS (
4451: /* Named Account exists with Salesperson with this role */
4452: SELECT NULL
4453: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
4454: WHERE grsc.geo_territory_id = gterr.geo_territory_id
4455: AND gterr.terr_group_id = b.terr_group_id
4456: AND grsc.rsc_role_code = b.role_code )
4457: AND ROWNUM < 2;