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_PRICING_ATTRIBUTES

Line 109: or not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id))

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

Line 179: and exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

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:
183: --dbms_output.put_line(SQL%ROWCOUNT);

Line 200: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

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:
204: --dbms_output.put_line(SQL%ROWCOUNT);

Line 221: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

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:
225: --dbms_output.put_line(SQL%ROWCOUNT);

Line 242: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

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:
246: --dbms_output.put_line(SQL%ROWCOUNT);

Line 263: and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

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:
267: --dbms_output.put_line(SQL%ROWCOUNT);

Line 284: and exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)

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:
288: --dbms_output.put_line(SQL%ROWCOUNT);