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_DEFINITION_PARAM_PVT dependencies on WF_NOTIFICATION

Line 67: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name

63: Cursor cur_salesrep is
64: select -1 resource_id, 'ALL' resource_name
65: from dual
66: union
67: select distinct resource_id, wf_notification.substitutespecialchars(resource_name) resource_name
68: from jtf_terr_resources_v
69: order by resource_name;
70:
71: /* qualifier cursor */

Line 76: select qual_usg_id , wf_notification.substitutespecialchars(usage) || ' - ' ||

72: Cursor cur_qual is
73: select -1 qual_usg_id ,'ALL' seeded_qual_name
74: from dual
75: union
76: select qual_usg_id , wf_notification.substitutespecialchars(usage) || ' - ' ||
77: wf_notification.substitutespecialchars(seeded_qual_name) seeded_qual_name
78: from jtf_seeded_qual_usgs_v
79: where enabled_flag = 'Y' and not (qual_type_id = -1001)
80: order by seeded_qual_name;

Line 77: wf_notification.substitutespecialchars(seeded_qual_name) seeded_qual_name

73: select -1 qual_usg_id ,'ALL' seeded_qual_name
74: from dual
75: union
76: select qual_usg_id , wf_notification.substitutespecialchars(usage) || ' - ' ||
77: wf_notification.substitutespecialchars(seeded_qual_name) seeded_qual_name
78: from jtf_seeded_qual_usgs_v
79: where enabled_flag = 'Y' and not (qual_type_id = -1001)
80: order by seeded_qual_name;
81: