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 DUAL

Line 25: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;

21: -- DESCRIPTION: This procedure is creates the descriptive header in the parameter form
22: --
23: -----------------------------------------------------------------------------------------------
24: begin
25: select to_char(sysdate,G_DATE_FORMAT) into v_date_time from dual;
26: htp.htmlopen;
27: htp.headOpen;
28: htp.title('Territory Defintion Report');
29: htp.headClose;

Line 65: from dual

61:
62: /* this resource cursor to be used in final delivery*/
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;

Line 74: from dual

70:
71: /* qualifier cursor */
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