DBA Data[Home] [Help]

APPS.QP_UPDATE_UTIL dependencies on QP_LIST_LINES

Line 31: from qp_list_lines l, qp_list_headers_b h

27:
28: cursor list_lines_cur(a_list_line_id NUMBER,b_list_line_id NUMBER)
29: is
30: select l.list_line_id, l.qualification_ind, h.list_type_code, h.list_header_id
31: from qp_list_lines l, qp_list_headers_b h
32: where l.list_header_id = h.list_header_id
33: and (l.list_line_id between a_list_line_id and b_list_line_id)
34: order by l.list_line_id;
35:

Line 235: UPDATE qp_list_lines

231:
232: END LOOP; --End of For Loop
233:
234: FORALL j IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
235: UPDATE qp_list_lines
236: SET qualification_ind = l_qualification_ind_tbl(j)
237: WHERE list_line_id = l_list_line_id_tbl(j);
238:
239: FORALL k IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST

Line 321: FROM qp_list_lines ll

317: WHERE rowid BETWEEN
318: p_start_rowid AND p_end_rowid) pa
319: SET (list_header_id, pricing_phase_id, qualification_ind) =
320: (SELECT ll.list_header_id, ll.pricing_phase_id, ll.qualification_ind
321: FROM qp_list_lines ll
322: WHERE ll.list_line_id = pa.list_line_id),
323: pricing_attr_value_from = new_from,
324: pricing_attr_value_to = new_to,
325: pricing_attr_value_from_number =

Line 351: from qp_pricing_attributes pa, qp_list_lines ll

347: cursor pricing_attributes
348: is
349: select pa.pricing_attribute_id pricing_attribute_id
350: /* Removed hint to tune the sqlstmt */
351: from qp_pricing_attributes pa, qp_list_lines ll
352: where pa.list_line_id = ll.list_line_id
353: and pa.list_header_id is null
354: and pa.pricing_phase_id is null
355: order by pricing_attribute_id;

Line 386: from qp_pricing_attributes pa, qp_list_lines ll

382: into
383: l_total_lines,
384: l_min_line,
385: l_max_line
386: from qp_pricing_attributes pa, qp_list_lines ll
387: where pa.list_line_id = ll.list_line_id
388: and pa.list_header_id is null
389: and pa.pricing_phase_id is null;
390: