APPS.JTF_TERRITORY_CUSTOM dependencies on JTF_TERR_VALUES

Line 51: from jtf_terr_values jtv

47: --dbms_output.put_line('chk_party_id '|| p_party_id || ' ' || p_terr_id || ' ' || p_terr_qual_id);
48:
49: Select 1
50: into l_dummy
51: from jtf_terr_values jtv
52: where jtv.terr_qual_id = p_Terr_Qual_Id and
53: ( ( jtv.COMPARISON_OPERATOR IN ('!=', '<>') and jtv.low_value_char_id <> p_party_id )
54: or ( jtv.COMPARISON_OPERATOR = '=' and jtv.low_value_char_id = p_party_id )
55: )

Line 80: from jtf_terr_values jtv

76: --dbms_output.put_line('chk_comp_name_range '|| p_company_name || ' ' || p_terr_id || ' ' || p_terr_qual_id);
77:
78: Select 1
79: into l_dummy
80: from jtf_terr_values jtv
81: where jtv.terr_qual_id = p_Terr_Qual_Id and
82: ( ( jtv.COMPARISON_OPERATOR = '<' and jtv.low_value_char < p_company_name )
83: or ( jtv.COMPARISON_OPERATOR = '<=' and jtv.low_value_char <= p_company_name )
84: or ( jtv.COMPARISON_OPERATOR = '<>' and jtv.low_value_char <> p_company_name )

Line 124: ' FROM jtf_terr_values jtv ' ||

120:
121:
122: query_str :=
123: ' SELECT 1 ' ||
124: ' FROM jtf_terr_values jtv ' ||
125: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
126: ' AND rownum < 2 ' ||
127: ' AND :p_hierarchy_id IN ( ' ||
128: ' SELECT hpr.subject_id ' ||

Line 161: ' FROM jtf_terr_values jtv ' ||

157: BEGIN
158:
159: query_str :=
160: ' SELECT 1 ' ||
161: ' FROM jtf_terr_values jtv ' ||
162: ' , hz_party_relationships hpr ' ||
163: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
164: ' AND hpr.subject_id = :p_partner_Id ' ||
165: ' AND hpr.object_id = jtv.low_value_char_id ' ||

Line 195: ' FROM jtf_terr_values jtv ' ||

191: BEGIN
192:
193: query_str :=
194: ' SELECT 1 ' ||
195: ' FROM jtf_terr_values jtv ' ||
196: ' , as_interests ai ' ||
197: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
198: ' AND ai.customer_id = :p_Party_Id ' ||
199: ' AND ai.interest_type_id = jtv.interest_type_id ' ||

Line 231: ' FROM jtf_terr_values jtv ' ||

227: BEGIN
228:
229: query_str :=
230: ' SELECT 1 ' ||
231: ' FROM jtf_terr_values jtv ' ||
232: ' , as_interests ai ' ||
233: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
234: ' AND ai.lead_id = :p_Lead_Id ' ||
235: ' AND ai.interest_type_id = jtv.interest_type_id ' ||

Line 270: ' FROM jtf_terr_values jtv ' ||

266: BEGIN
267:
268: query_str :=
269: ' SELECT 1 ' ||
270: ' FROM jtf_terr_values jtv ' ||
271: ' , as_lead_lines al ' ||
272: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
273: ' AND al.lead_id = :p_Lead_Id ' ||
274: ' AND al.interest_type_id = jtv.interest_type_id ' ||

Line 304: ' FROM jtf_terr_values jtv ' ||

300: BEGIN
301:
302: query_str :=
303: ' SELECT 1 ' ||
304: ' FROM jtf_terr_values jtv ' ||
305: ' , as_sales_lead_lines asl ' ||
306: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
307: ' AND asl.sales_lead_id = :p_Sales_Lead_Id ' ||
308: ' AND asl.interest_type_id = jtv.interest_type_id ' ||

Line 339: ' FROM jtf_terr_values jtv ' ||

335: BEGIN
336:
337: query_str :=
338: ' SELECT 1 ' ||
339: ' FROM jtf_terr_values jtv ' ||
340: ' , as_lead_lines al ' ||
341: ' WHERE jtv.terr_qual_id = :p_terr_qual_id ' ||
342: ' AND al.Lead_id = :p_Lead_Id ' ||
343: ' AND al.inventory_item_id = jtv.low_value_char_id ' ||