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_GEOGRAPHIES

Line 1044: jtf_tty_geographies g --postal_code level

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
1046: AND terr.terr_group_id = grpv.terr_group_id
1047: AND terr.owner_resource_id < 0
1048: AND terr.parent_geo_terr_id < 0 -- default terr

Line 1061: jtf_tty_geographies g, --postal_code level

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,
1063: jtf_tty_geographies g2
1064: WHERE terr.terr_group_id = tg.terr_group_id
1065: AND terr.terr_group_id = grpv.terr_group_id

Line 1062: jtf_tty_geographies g1,

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,
1063: jtf_tty_geographies g2
1064: WHERE terr.terr_group_id = tg.terr_group_id
1065: AND terr.terr_group_id = grpv.terr_group_id
1066: AND terr.owner_resource_id < 0

Line 1063: jtf_tty_geographies g2

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,
1063: jtf_tty_geographies g2
1064: WHERE terr.terr_group_id = tg.terr_group_id
1065: AND terr.terr_group_id = grpv.terr_group_id
1066: AND terr.owner_resource_id < 0
1067: AND terr.parent_geo_terr_id < 0 -- default terr

Line 1080: jtf_tty_geographies g,

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
1082: WHERE terr.terr_group_id = tg.terr_group_id
1083: AND terr.terr_group_id = grpv.terr_group_id
1084: AND terr.owner_resource_id < 0

Line 1081: jtf_tty_geographies g1

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
1082: WHERE terr.terr_group_id = tg.terr_group_id
1083: AND terr.terr_group_id = grpv.terr_group_id
1084: AND terr.owner_resource_id < 0
1085: AND terr.parent_geo_terr_id < 0 -- default terr

Line 1130: jtf_tty_geographies g,

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

Line 2545: jtf_tty_geographies g --postal_code level

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
2547: AND terr.terr_group_id = grpv.terr_group_id
2548: AND terr.owner_resource_id < 0
2549: AND terr.parent_geo_terr_id < 0 -- default terr

Line 2562: jtf_tty_geographies g, --postal_code level

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,
2564: jtf_tty_geographies g2
2565: WHERE terr.terr_group_id = tg.terr_group_id
2566: AND terr.terr_group_id = grpv.terr_group_id

Line 2563: jtf_tty_geographies g1,

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,
2564: jtf_tty_geographies g2
2565: WHERE terr.terr_group_id = tg.terr_group_id
2566: AND terr.terr_group_id = grpv.terr_group_id
2567: AND terr.owner_resource_id < 0

Line 2564: jtf_tty_geographies g2

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,
2564: jtf_tty_geographies g2
2565: WHERE terr.terr_group_id = tg.terr_group_id
2566: AND terr.terr_group_id = grpv.terr_group_id
2567: AND terr.owner_resource_id < 0
2568: AND terr.parent_geo_terr_id < 0 -- default terr

Line 2581: jtf_tty_geographies g,

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
2583: WHERE terr.terr_group_id = tg.terr_group_id
2584: AND terr.terr_group_id = grpv.terr_group_id
2585: AND terr.owner_resource_id < 0

Line 2582: jtf_tty_geographies g1

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
2583: WHERE terr.terr_group_id = tg.terr_group_id
2584: AND terr.terr_group_id = grpv.terr_group_id
2585: AND terr.owner_resource_id < 0
2586: AND terr.parent_geo_terr_id < 0 -- default terr

Line 2631: jtf_tty_geographies g,

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