APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_PREQ_LINE_ATTRS_FORMULA_TMP

Line 248: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a,

244: a.list_header_id, l.list_line_id, l.operand,
245: l.start_date_active, l.end_date_active, l.group_count,
246: fl.price_formula_id, fl.step_number
247: FROM qp_price_formula_lines fl, qp_factor_list_attrs fla,
248: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a,
249: qp_list_lines l
250: WHERE t.context = a.pricing_attribute_context
251: AND t.attribute = a.pricing_attribute
252: AND fl.price_formula_line_type_code = 'ML'

Line 274: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a,

270: a.list_header_id, l.list_line_id, l.operand,
271: l.start_date_active, l.end_date_active, l.group_count,
272: fl.price_formula_id, fl.step_number
273: FROM qp_price_formula_lines fl, qp_factor_list_attrs fla,
274: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a,
275: qp_list_lines l
276: WHERE t.context = a.pricing_attribute_context
277: AND t.attribute = a.pricing_attribute
278: AND fl.price_formula_line_type_code = 'ML'

Line 326: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a

322: SELECT /*+ index(t QP_PREQ_LINE_ATTRS_FRML_TMP_N1) index(A QP_PRICING_ATTRIBUTES_N2) */ --Bug 7452538 Added index hints
323: a.list_line_id --Bug 8359591 Removing ordered hint
324: -- /*+ ordered */ a.list_line_id --5900728
325: FROM qp_factor_list_attrs fla,
326: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a
327: WHERE fla.list_header_id = a_list_header_id
328: AND fla.pricing_attribute_context = t.context
329: AND fla.pricing_attribute = t.attribute
330: AND t.context = a.pricing_attribute_context

Line 348: -- qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a

344: -- 5900728
345: -- SELECT /*+ ORDERED index(a QP_PRICING_ATTRIBUTES_N8) */
346: -- a.list_line_id
347: -- FROM qp_factor_list_attrs fla,
348: -- qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a
349: -- WHERE fla.list_header_id = a_list_header_id
350: -- AND fla.pricing_attribute_context = t.context
351: -- AND fla.pricing_attribute = t.attribute
352: -- AND t.context = a.pricing_attribute_context

Line 368: -- qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a

364: --UNION ----separate sqls for positive and negative pattern_values for 3520634
365: -- SELECT /*+ ORDERED index(a QP_PRICING_ATTRIBUTES_N10) */
366: -- a.list_line_id
367: -- FROM qp_factor_list_attrs fla,
368: -- qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a
369: -- WHERE fla.list_header_id = a_list_header_id
370: -- AND fla.pricing_attribute_context = t.context
371: -- AND fla.pricing_attribute = t.attribute
372: -- AND t.context = a.pricing_attribute_context

Line 412: FROM qp_preq_line_attrs_formula_tmp

408: a_pricing_attribute VARCHAR2,
409: a_line_index NUMBER)
410: IS
411: SELECT value_from
412: FROM qp_preq_line_attrs_formula_tmp
413: WHERE context = a_pricing_attribute_context
414: AND attribute = a_pricing_attribute
415: AND line_index = a_line_index
416: AND attribute_type in ('PRICING','PRODUCT')

Line 474: FROM qp_preq_line_attrs_formula_tmp

470: IS
471: SELECT line_index, attribute_type, context, attribute, value_from value
472: --FROM qp_npreq_line_attrs_tmp
473: -- bug2425851
474: FROM qp_preq_line_attrs_formula_tmp
475: WHERE line_index = a_line_index
476: AND attribute_type IN ('PRICING','PRODUCT');
477:
478: -- Bug 2772214, Added qual cursor

Line 482: FROM qp_preq_line_attrs_formula_tmp

478: -- Bug 2772214, Added qual cursor
479: CURSOR req_line_attrs_qual_cur(a_line_index NUMBER)
480: IS
481: SELECT line_index, attribute_type, context, attribute, value_from value
482: FROM qp_preq_line_attrs_formula_tmp
483: WHERE line_index = a_line_index
484: AND attribute_type IN ('PRICING','PRODUCT','QUALIFIER');
485:
486: