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_GEN_TERR_PVT dependencies on JTF_TTY_GEO_GRP_VALUES

Line 1041: FROM jtf_tty_geo_grp_values grpv,

1037: /* postal code */
1038: SELECT g.postal_code postal_code
1039: ,g.geo_id geo_id
1040: ,terr.geo_territory_id geo_territory_id
1041: FROM jtf_tty_geo_grp_values grpv,
1042: jtf_tty_terr_groups tg,
1043: jtf_tty_geo_terr terr,
1044: jtf_tty_geographies g --postal_code level
1045: WHERE terr.terr_group_id = tg.terr_group_id

Line 1058: FROM jtf_tty_geo_grp_values grpv,

1054: /* postal code range */
1055: SELECT g.postal_code postal_code
1056: ,g.geo_id geo_id
1057: ,terr.geo_territory_id geo_territory_id
1058: FROM jtf_tty_geo_grp_values grpv,
1059: jtf_tty_terr_groups tg,
1060: jtf_tty_geo_terr terr,
1061: jtf_tty_geographies g, --postal_code level
1062: jtf_tty_geographies g1,

Line 1077: FROM jtf_tty_geo_grp_values grpv,

1073: UNION
1074: SELECT g.postal_code postal_code
1075: ,g.geo_id geo_id
1076: ,terr.geo_territory_id geo_territory_id
1077: FROM jtf_tty_geo_grp_values grpv,
1078: jtf_tty_terr_groups tg,
1079: jtf_tty_geo_terr terr,
1080: jtf_tty_geographies g,
1081: jtf_tty_geographies g1

Line 2542: FROM jtf_tty_geo_grp_values grpv,

2538: /* postal code */
2539: SELECT g.postal_code postal_code
2540: ,g.geo_id geo_id
2541: ,terr.geo_territory_id geo_territory_id
2542: FROM jtf_tty_geo_grp_values grpv,
2543: jtf_tty_terr_groups tg,
2544: jtf_tty_geo_terr terr,
2545: jtf_tty_geographies g --postal_code level
2546: WHERE terr.terr_group_id = tg.terr_group_id

Line 2559: FROM jtf_tty_geo_grp_values grpv,

2555: /* postal code range */
2556: SELECT g.postal_code postal_code
2557: ,g.geo_id geo_id
2558: ,terr.geo_territory_id geo_territory_id
2559: FROM jtf_tty_geo_grp_values grpv,
2560: jtf_tty_terr_groups tg,
2561: jtf_tty_geo_terr terr,
2562: jtf_tty_geographies g, --postal_code level
2563: jtf_tty_geographies g1,

Line 2578: FROM jtf_tty_geo_grp_values grpv,

2574: UNION
2575: SELECT g.postal_code postal_code
2576: ,g.geo_id geo_id
2577: ,terr.geo_territory_id geo_territory_id
2578: FROM jtf_tty_geo_grp_values grpv,
2579: jtf_tty_terr_groups tg,
2580: jtf_tty_geo_terr terr,
2581: jtf_tty_geographies g,
2582: jtf_tty_geographies g1

Line 2898: , jtf_tty_geo_grp_values gterr

2894: /* does Territory Group have at least 1 Geo Territory ? */
2895: SELECT COUNT(*)
2896: INTO l_na_count
2897: FROM jtf_tty_terr_groups tgrp
2898: , jtf_tty_geo_grp_values gterr
2899: WHERE tgrp.terr_group_id = gterr.terr_group_id
2900: AND tgrp.terr_group_id = p_terr_group_id(x)
2901: AND ROWNUM < 2;
2902: