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.QP_QUALIFICATION_IND_UPG_UTIL dependencies on QP_LIST_LINES

Line 38: update qp_list_lines qpl set qpl.qualification_ind=3

34:
35: --dbms_output.put_line(v_min_line);
36: --dbms_output.put_line(v_max_line);
37: loop
38: update qp_list_lines qpl set qpl.qualification_ind=3
39: where list_line_id between v_min_line and v_max_line
40: and (qualification_ind is null or qualification_ind <> 3)
41: and rownum<=p_batchsize;
42:

Line 104: update qp_list_lines qpl set qpl.qualification_ind=1

100: return;
101: end;
102:
103: loop
104: update qp_list_lines qpl set qpl.qualification_ind=1
105: where list_line_id between v_min_line and v_max_line
106: and qualification_ind = 3
107: and (exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
108: or exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))

Line 175: update qp_list_lines qpl set qpl.qualification_ind=2

171: --dbms_output.put_line('v_min_line : ' || v_min_line);
172: --dbms_output.put_line('v_max_line : ' || v_max_line);
173:
174: loop
175: update qp_list_lines qpl set qpl.qualification_ind=2
176: where qpl.list_line_id between v_min_line and v_max_line
177: and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
178: and not exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
179: and exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

Line 196: update qp_list_lines qpl set qpl.qualification_ind=4

192:
193: commit;
194:
195: loop
196: update qp_list_lines qpl set qpl.qualification_ind=4
197: where qpl.list_line_id between v_min_line and v_max_line
198: and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
199: and exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
200: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

Line 217: update qp_list_lines qpl set qpl.qualification_ind=5

213:
214: commit;
215:
216: loop
217: update qp_list_lines qpl set qpl.qualification_ind=5
218: where qpl.list_line_id between v_min_line and v_max_line
219: and not exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
220: and exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
221: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

Line 238: update qp_list_lines qpl set qpl.qualification_ind=6

234:
235: commit;
236:
237: loop
238: update qp_list_lines qpl set qpl.qualification_ind=6
239: where qpl.list_line_id between v_min_line and v_max_line
240: and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
241: and not exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
242: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

Line 259: update qp_list_lines qpl set qpl.qualification_ind=7

255:
256: commit;
257:
258: loop
259: update qp_list_lines qpl set qpl.qualification_ind=7
260: where qpl.list_line_id between v_min_line and v_max_line
261: and not exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
262: and not exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
263: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

Line 280: update qp_list_lines qpl set qpl.qualification_ind=NULL

276:
277: commit;
278:
279: loop
280: update qp_list_lines qpl set qpl.qualification_ind=NULL
281: where qpl.list_line_id between v_min_line and v_max_line
282: and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
283: and exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
284: and exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

Line 345: from qp_list_lines;

341: BEGIN
342: IF l_type = 'QUA' THEN
343: select nvl(min(list_line_id),0), nvl(max(list_line_id),0)
344: into l_min_line, l_max_line
345: from qp_list_lines;
346:
347: ELSIF l_type = 'DEN' THEN -- Related to Denormalization code
348: select nvl(min(list_header_id),0), nvl(max(list_header_id),0)
349: into l_min_line, l_max_line

Line 426: from qp_list_lines;

422: commit;
423:
424: select round(count(*)/l_workers) + 1
425: into l_slab
426: from qp_list_lines;
427:
428: for i in 1..l_workers
429: loop
430: begin

Line 435: from qp_list_lines

431: select max(list_line_id), min(list_line_id)
432: into l_max, l_min
433: from (select list_line_id
434: from (select list_line_id
435: from qp_list_lines
436: where list_line_id > l_max
437: order by list_line_id
438: )
439: where rownum < l_slab + 1