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_TERR_CHANGES_REPORT_PVT dependencies on JTF_TERR_RESOURCES_V

Line 60: from jtf_terr_resources_v jtrv

56: */
57: -- cursor to get salesreps DELIVERY
58: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS
59: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
60: from jtf_terr_resources_v jtrv
61: where jtrv.terr_id = ci_terr_id
62: order by resource_name;
63:
64: -- cursor to get dynamic qualifiers

Line 358: from jtf_terr_resources_v jtrv

354:
355: -- cursor to get salesreps DELIVERY
356: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS
357: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
358: from jtf_terr_resources_v jtrv
359: where jtrv.terr_id = ci_terr_id
360: order by resource_name;
361: -- cursor to get dynamic qualifiers
362: CURSOR c_get_terr_qual (p_template_terr_id NUMBER) IS