APPS.JTF_TTY_GEN_TERR_PVT dependencies on JTF_TTY_GEO_TERR_VALUES

Line 1131: jtf_tty_geo_terr_values tv

1127: ,terr.geo_territory_id geo_territory_id
1128: FROM jtf_tty_terr_groups tg,
1129: jtf_tty_geo_terr terr,
1130: jtf_tty_geographies g,
1131: jtf_tty_geo_terr_values tv
1132: WHERE terr.terr_group_id = tg.terr_group_id
1133: AND terr.owner_resource_id >= 0
1134: AND terr.parent_geo_terr_id >= 0 -- not default terr
1135: AND tv.geo_territory_id = terr.geo_territory_id

Line 1142: jtf_tty_geo_terr_values tv

1138: WHERE main.geo_id NOT IN -- the terr the user owners
1139: (
1140: SELECT tv.geo_id geo_id
1141: FROM jtf_tty_geo_terr terr,
1142: jtf_tty_geo_terr_values tv
1143: WHERE tv.geo_territory_id = terr.geo_territory_id
1144: AND main.geo_territory_id = terr.parent_geo_terr_id
1145: )
1146: AND geo_territory_id = l_geo_territory_id;

Line 1399: FROM jtf_tty_geo_terr_values gtval

1395: WHERE gterr.geo_territory_id = p_geo_territory_id(x)
1396: AND ( gterr.parent_geo_terr_id < 0
1397: OR EXISTS (
1398: SELECT 1
1399: FROM jtf_tty_geo_terr_values gtval
1400: WHERE gterr.geo_territory_id = gtval.geo_territory_id));
1401: EXCEPTION
1402: WHEN NO_DATA_FOUND THEN
1403: l_geo_count := 0;

Line 2484: FROM jtf_tty_geo_terr_values gtval

2480: WHERE gterr.terr_group_id = l_terr_group_id
2481: AND ( gterr.parent_geo_terr_id < 0
2482: OR EXISTS (
2483: SELECT 1
2484: FROM jtf_tty_geo_terr_values gtval
2485: WHERE gterr.geo_territory_id = gtval.geo_territory_id));
2486:
2487: /** Transaction Types for a NON-OVERLAY territory are
2488: ** determined by all salesteam members on this geography territories

Line 2632: jtf_tty_geo_terr_values tv

2628: ,terr.geo_territory_id geo_territory_id
2629: FROM jtf_tty_terr_groups tg,
2630: jtf_tty_geo_terr terr,
2631: jtf_tty_geographies g,
2632: jtf_tty_geo_terr_values tv
2633: WHERE terr.terr_group_id = tg.terr_group_id
2634: AND terr.owner_resource_id >= 0
2635: AND terr.parent_geo_terr_id >= 0 -- not default terr
2636: AND tv.geo_territory_id = terr.geo_territory_id

Line 2643: jtf_tty_geo_terr_values tv

2639: WHERE main.geo_id NOT IN -- the terr the user owners
2640: (
2641: SELECT tv.geo_id geo_id
2642: FROM jtf_tty_geo_terr terr,
2643: jtf_tty_geo_terr_values tv
2644: WHERE tv.geo_territory_id = terr.geo_territory_id
2645: AND main.geo_territory_id = terr.parent_geo_terr_id
2646: )
2647: AND geo_territory_id = l_geo_territory_id;