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_QUALIFIERS

Line 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))

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))
109: or not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id))
110: and rownum<=p_batchsize;
111:
112: --dbms_output.put_line(SQL%ROWCOUNT);

Line 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))

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)
180: and qpl.qualification_ind=1
181: and rownum<=p_batchsize;
182:

Line 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))

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)
201: and qpl.qualification_ind=1
202: and rownum<=p_batchsize;
203:

Line 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))

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)
222: and qpl.qualification_ind=1
223: and rownum<=p_batchsize;
224:

Line 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))

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)
243: and qpl.qualification_ind=1
244: and rownum<=p_batchsize;
245:

Line 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))

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)
264: and qpl.qualification_ind=1
265: and rownum<=p_batchsize;
266:

Line 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))

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)
285: and qpl.qualification_ind=1
286: and rownum<=p_batchsize;
287: