DBA Data[Home] [Help]

APPS.JTF_TERR_DEFINITION_REPORT_PVT dependencies on JTF_TERR_RESOURCES_V

Line 51: from jtf_terr_resources_v jtrv

47:
48: -- cursor to get salesreps DELIVERY
49: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS
50: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
51: from jtf_terr_resources_v jtrv
52: where jtrv.terr_id = ci_terr_id
53: order by resource_name;
54:
55: -- cursor to get dynamic qualifiers

Line 381: from jtf_terr_resources_v jtrv

377:
378: -- cursor to get salesreps DELIVERY
379: CURSOR c_get_salesrep(ci_terr_id NUMBER) IS
380: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
381: from jtf_terr_resources_v jtrv
382: where jtrv.terr_id = ci_terr_id
383: order by resource_name;
384:
385: -- cursor to get dynamic qualifiers