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

Line 34: select j.terr_id, wf_notification.substitutespecialchars(j.name) name, j.rank

30: p_territory_type_id NUMBER;
31:
32: -- cursor of result territory searches with resource and qualifier restrictions
33: CURSOR cur_terr is
34: select j.terr_id, wf_notification.substitutespecialchars(j.name) name, j.rank
35: from jtf_terr j
36: where NVL(j.end_date_active, sysdate) >= sysdate
37: AND j.start_date_active <= sysdate
38: AND EXISTS

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

46: );
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:

Line 61: wf_notification.substitutespecialchars(qualifier_name) qualifier_name

57: SELECT distinct TERR_QUAL_ID,
58: TERR_ID,
59: QUAL_USG_ID,
60: ORG_ID,
61: wf_notification.substitutespecialchars(qualifier_name) qualifier_name
62: FROM jtf_terr_qualifiers_v
63: WHERE terr_id = p_template_terr_id;
64:
65: -- cursor to get values for dynamic qualifier values

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

64:
65: -- cursor to get values for dynamic qualifier values
66: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
67: SELECT j1.TERR_VALUE_ID
68: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
69: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
70: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
71: , j1.LOW_VALUE_NUMBER
72: , j1.HIGH_VALUE_NUMBER

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

65: -- cursor to get values for dynamic qualifier values
66: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
67: SELECT j1.TERR_VALUE_ID
68: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
69: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
70: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
71: , j1.LOW_VALUE_NUMBER
72: , j1.HIGH_VALUE_NUMBER
73: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE

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

66: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
67: SELECT j1.TERR_VALUE_ID
68: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
69: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
70: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
71: , j1.LOW_VALUE_NUMBER
72: , j1.HIGH_VALUE_NUMBER
73: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
74: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE

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

69: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
70: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
71: , j1.LOW_VALUE_NUMBER
72: , j1.HIGH_VALUE_NUMBER
73: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
74: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
75: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID

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

70: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
71: , j1.LOW_VALUE_NUMBER
72: , j1.HIGH_VALUE_NUMBER
73: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
74: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
75: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID
78: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME

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

71: , j1.LOW_VALUE_NUMBER
72: , j1.HIGH_VALUE_NUMBER
73: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
74: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
75: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID
78: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

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

72: , j1.HIGH_VALUE_NUMBER
73: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
74: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
75: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID
78: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
80: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

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

74: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
75: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID
78: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
80: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
81: --bug#3175772
82: , VALUE1_ID

Line 79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

75: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID
78: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
80: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
81: --bug#3175772
82: , VALUE1_ID
83: , wf_notification.substitutespecialchars(VALUE1_DESC) VALUE1_DESC

Line 80: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

76: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
77: , j1.LOW_VALUE_CHAR_ID
78: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
80: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
81: --bug#3175772
82: , VALUE1_ID
83: , wf_notification.substitutespecialchars(VALUE1_DESC) VALUE1_DESC
84: , VALUE2_ID

Line 83: , wf_notification.substitutespecialchars(VALUE1_DESC) VALUE1_DESC

79: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
80: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
81: --bug#3175772
82: , VALUE1_ID
83: , wf_notification.substitutespecialchars(VALUE1_DESC) VALUE1_DESC
84: , VALUE2_ID
85: , wf_notification.substitutespecialchars(VALUE2_DESC) VALUE2_DESC
86: , VALUE3_ID
87: , wf_notification.substitutespecialchars(VALUE3_DESC) VALUE3_DESC

Line 85: , wf_notification.substitutespecialchars(VALUE2_DESC) VALUE2_DESC

81: --bug#3175772
82: , VALUE1_ID
83: , wf_notification.substitutespecialchars(VALUE1_DESC) VALUE1_DESC
84: , VALUE2_ID
85: , wf_notification.substitutespecialchars(VALUE2_DESC) VALUE2_DESC
86: , VALUE3_ID
87: , wf_notification.substitutespecialchars(VALUE3_DESC) VALUE3_DESC
88: FROM jtf_terr_values_desc_v j1
89: WHERE j1.terr_qual_id = p_terr_qual_id

Line 87: , wf_notification.substitutespecialchars(VALUE3_DESC) VALUE3_DESC

83: , wf_notification.substitutespecialchars(VALUE1_DESC) VALUE1_DESC
84: , VALUE2_ID
85: , wf_notification.substitutespecialchars(VALUE2_DESC) VALUE2_DESC
86: , VALUE3_ID
87: , wf_notification.substitutespecialchars(VALUE3_DESC) VALUE3_DESC
88: FROM jtf_terr_values_desc_v j1
89: WHERE j1.terr_qual_id = p_terr_qual_id
90: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;
91:

Line 371: select terr_id, wf_notification.substitutespecialchars(name) name, rank from jtf_terr_all

367: p_territory_type_id as_territories.territory_type_id%type ;
368:
369: -- cursor of result territory searches with resource and qualifier restrictions
370: CURSOR cur_terr is
371: select terr_id, wf_notification.substitutespecialchars(name) name, rank from jtf_terr_all
372: where terr_id in
373: (select jtr.terr_id from jtf_terr_rsc jtr, jtf_terr_qual jtq
374: where jtr.terr_id = jtq.terr_id
375: and jtr.resource_id = decode(l_srp,-1,jtr.resource_id,l_srp)

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

376: and jtq.qual_usg_id = decode(l_qual, -1, jtq.qual_usg_id, l_qual));
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:

Line 391: wf_notification.substitutespecialchars(qualifier_name) qualifier_name

387: SELECT distinct TERR_QUAL_ID,
388: TERR_ID,
389: QUAL_USG_ID,
390: ORG_ID,
391: wf_notification.substitutespecialchars(qualifier_name) qualifier_name
392: FROM jtf_terr_qualifiers_v
393: WHERE terr_id = p_template_terr_id;
394:
395: -- cursor to get values for dynamic qualifier values

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

394:
395: -- cursor to get values for dynamic qualifier values
396: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
397: SELECT j1.TERR_VALUE_ID
398: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
399: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
400: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
401: , j1.LOW_VALUE_NUMBER
402: , j1.HIGH_VALUE_NUMBER

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

395: -- cursor to get values for dynamic qualifier values
396: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
397: SELECT j1.TERR_VALUE_ID
398: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
399: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
400: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
401: , j1.LOW_VALUE_NUMBER
402: , j1.HIGH_VALUE_NUMBER
403: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE

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

396: CURSOR c_get_terr_values (p_terr_qual_id NUMBER) IS
397: SELECT j1.TERR_VALUE_ID
398: , wf_notification.substitutespecialchars(j1.COMPARISON_OPERATOR) COMPARISON_OPERATOR
399: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
400: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
401: , j1.LOW_VALUE_NUMBER
402: , j1.HIGH_VALUE_NUMBER
403: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
404: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE

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

399: , wf_notification.substitutespecialchars(j1.LOW_VALUE_CHAR_DESC) LOW_VALUE_CHAR_DESC
400: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
401: , j1.LOW_VALUE_NUMBER
402: , j1.HIGH_VALUE_NUMBER
403: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
404: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
405: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID

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

400: , wf_notification.substitutespecialchars(j1.HIGH_VALUE_CHAR_DESC) HIGH_VALUE_CHAR_DESC
401: , j1.LOW_VALUE_NUMBER
402: , j1.HIGH_VALUE_NUMBER
403: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
404: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
405: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME

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

401: , j1.LOW_VALUE_NUMBER
402: , j1.HIGH_VALUE_NUMBER
403: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
404: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
405: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

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

402: , j1.HIGH_VALUE_NUMBER
403: , wf_notification.substitutespecialchars(j1.INTEREST_TYPE) INTEREST_TYPE
404: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
405: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
410: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

Line 408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME

404: , wf_notification.substitutespecialchars(j1.PRIMARY_INTEREST_CODE) PRIMARY_INTEREST_CODE
405: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
410: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
411: FROM jtf_terr_values_desc_v j1
412: WHERE j1.terr_qual_id = p_terr_qual_id

Line 409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE

405: , wf_notification.substitutespecialchars(j1.SECONDARY_INTEREST_CODE) SECONDARY_INTEREST_CODE
406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
410: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
411: FROM jtf_terr_values_desc_v j1
412: WHERE j1.terr_qual_id = p_terr_qual_id
413: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;

Line 410: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG

406: , wf_notification.substitutespecialchars(j1.CURRENCY_CODE) CURRENCY_CODE
407: , j1.LOW_VALUE_CHAR_ID
408: , wf_notification.substitutespecialchars(j1.CNR_GROUP_NAME) CNR_GROUP_NAME
409: , wf_notification.substitutespecialchars(DISPLAY_TYPE) DISPLAY_TYPE
410: , wf_notification.substitutespecialchars(CONVERT_TO_ID_FLAG) CONVERT_TO_ID_FLAG
411: FROM jtf_terr_values_desc_v j1
412: WHERE j1.terr_qual_id = p_terr_qual_id
413: ORDER BY j1.LOW_VALUE_CHAR_DESC, j1.COMPARISON_OPERATOR;
414: