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 WF_NOTIFICATION

Line 46: select terr_id, wf_notification.substitutespecialchars(name) name,

42:
43:
44: -- cursor to get territory records
45: cursor cur_territory(c_from_date date, c_to_date date) is
46: select terr_id, wf_notification.substitutespecialchars(name) name,
47: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,
48: trunc(creation_date) creation_date, trunc(last_update_date) last_update_date
49: from jtf_terr_overview_v
50: where last_update_date >= c_from_date --'01-OCT-2001'

Line 47: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,

43:
44: -- cursor to get territory records
45: cursor cur_territory(c_from_date date, c_to_date date) is
46: select terr_id, wf_notification.substitutespecialchars(name) name,
47: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,
48: trunc(creation_date) creation_date, trunc(last_update_date) last_update_date
49: from jtf_terr_overview_v
50: where last_update_date >= c_from_date --'01-OCT-2001'
51: and last_update_date <= c_to_date; --'11-JUN-1997'

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

55: from jtf_terr_rsc where terr_id = ci_terr_id;
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:

Line 70: wf_notification.substitutespecialchars(qualifier_name) qualifier_name

66: SELECT distinct TERR_QUAL_ID,
67: TERR_ID,
68: QUAL_USG_ID,
69: ORG_ID,
70: wf_notification.substitutespecialchars(qualifier_name) qualifier_name
71: FROM jtf_terr_qualifiers_v
72: WHERE terr_id = p_template_terr_id;
73: -- cursor to get values for dynamic qualifier values
74: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS

Line 76: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR

72: WHERE terr_id = p_template_terr_id;
73: -- cursor to get values for dynamic qualifier values
74: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
75: SELECT j1.TERR_VALUE_ID
76: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
77: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
78: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
79: , j1.LOW_VALUE_NUMBER
80: , j1.HIGH_VALUE_NUMBER

Line 77: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC

73: -- cursor to get values for dynamic qualifier values
74: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
75: SELECT j1.TERR_VALUE_ID
76: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
77: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
78: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
79: , j1.LOW_VALUE_NUMBER
80: , j1.HIGH_VALUE_NUMBER
81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE

Line 78: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC

74: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
75: SELECT j1.TERR_VALUE_ID
76: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
77: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
78: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
79: , j1.LOW_VALUE_NUMBER
80: , j1.HIGH_VALUE_NUMBER
81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE

Line 81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE

77: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
78: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
79: , j1.LOW_VALUE_NUMBER
80: , j1.HIGH_VALUE_NUMBER
81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
85: , j1.LOW_VALUE_CHAR_ID

Line 82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE

78: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
79: , j1.LOW_VALUE_NUMBER
80: , j1.HIGH_VALUE_NUMBER
81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
85: , j1.LOW_VALUE_CHAR_ID
86: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

Line 83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE

79: , j1.LOW_VALUE_NUMBER
80: , j1.HIGH_VALUE_NUMBER
81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
85: , j1.LOW_VALUE_CHAR_ID
86: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
87: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

Line 84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE

80: , j1.HIGH_VALUE_NUMBER
81: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
85: , j1.LOW_VALUE_CHAR_ID
86: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
87: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
88: FROM jtf_terr_values_desc_v j1

Line 86: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

82: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
85: , j1.LOW_VALUE_CHAR_ID
86: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
87: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
88: FROM jtf_terr_values_desc_v j1
89: WHERE j1.terr_qual_id = p_terr_qual_id
90: ORDER BY j1.value_set;

Line 87: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

83: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
84: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
85: , j1.LOW_VALUE_CHAR_ID
86: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
87: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
88: FROM jtf_terr_values_desc_v j1
89: WHERE j1.terr_qual_id = p_terr_qual_id
90: ORDER BY j1.value_set;
91:

Line 348: select terr_id, wf_notification.substitutespecialchars(name) name,

344:
345:
346: -- cursor to get territory records
347: cursor cur_territory(c_from_date date, c_to_date date) is
348: select terr_id, wf_notification.substitutespecialchars(name) name,
349: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,
350: trunc(creation_date) creation_date, trunc(last_update_date) last_update_date
351: from jtf_terr_overview_v
352: where last_update_date >= c_from_date --'01-OCT-2001'

Line 349: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,

345:
346: -- cursor to get territory records
347: cursor cur_territory(c_from_date date, c_to_date date) is
348: select terr_id, wf_notification.substitutespecialchars(name) name,
349: wf_notification.substitutespecialchars(terr_type_name) terr_type_name, rank,
350: trunc(creation_date) creation_date, trunc(last_update_date) last_update_date
351: from jtf_terr_overview_v
352: where last_update_date >= c_from_date --'01-OCT-2001'
353: and last_update_date <= c_to_date; --'11-JUN-1997'

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

353: and last_update_date <= c_to_date; --'11-JUN-1997'
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

Line 367: wf_notification.substitutespecialchars(qualifier_name) qualifier_name

363: SELECT distinct TERR_QUAL_ID,
364: TERR_ID,
365: QUAL_USG_ID,
366: ORG_ID,
367: wf_notification.substitutespecialchars(qualifier_name) qualifier_name
368: FROM jtf_terr_qualifiers_v
369: WHERE terr_id = p_template_terr_id;
370: -- cursor to get values for dynamic qualifier values
371: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS

Line 373: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR

369: WHERE terr_id = p_template_terr_id;
370: -- cursor to get values for dynamic qualifier values
371: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
372: SELECT j1.TERR_VALUE_ID
373: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
374: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
375: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
376: , j1.LOW_VALUE_NUMBER
377: , j1.HIGH_VALUE_NUMBER

Line 374: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC

370: -- cursor to get values for dynamic qualifier values
371: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
372: SELECT j1.TERR_VALUE_ID
373: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
374: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
375: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
376: , j1.LOW_VALUE_NUMBER
377: , j1.HIGH_VALUE_NUMBER
378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE

Line 375: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC

371: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
372: SELECT j1.TERR_VALUE_ID
373: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
374: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
375: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
376: , j1.LOW_VALUE_NUMBER
377: , j1.HIGH_VALUE_NUMBER
378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE

Line 378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE

374: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
375: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
376: , j1.LOW_VALUE_NUMBER
377: , j1.HIGH_VALUE_NUMBER
378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
382: , j1.LOW_VALUE_CHAR_ID

Line 379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE

375: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
376: , j1.LOW_VALUE_NUMBER
377: , j1.HIGH_VALUE_NUMBER
378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
382: , j1.LOW_VALUE_CHAR_ID
383: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

Line 380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE

376: , j1.LOW_VALUE_NUMBER
377: , j1.HIGH_VALUE_NUMBER
378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
382: , j1.LOW_VALUE_CHAR_ID
383: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
384: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

Line 381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE

377: , j1.HIGH_VALUE_NUMBER
378: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
382: , j1.LOW_VALUE_CHAR_ID
383: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
384: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
385: FROM jtf_terr_values_desc_v j1

Line 383: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

379: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
382: , j1.LOW_VALUE_CHAR_ID
383: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
384: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
385: FROM jtf_terr_values_desc_v j1
386: WHERE j1.terr_qual_id = p_terr_qual_id
387: ORDER BY j1.value_set;

Line 384: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

380: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
381: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
382: , j1.LOW_VALUE_CHAR_ID
383: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
384: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
385: FROM jtf_terr_values_desc_v j1
386: WHERE j1.terr_qual_id = p_terr_qual_id
387: ORDER BY j1.value_set;
388: