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 324: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a

320: a_group_count NUMBER)
321: IS
322: SELECT /*+ ordered */ a.list_line_id --5900728
323: FROM qp_factor_list_attrs fla,
324: qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a
325: WHERE fla.list_header_id = a_list_header_id
326: AND fla.pricing_attribute_context = t.context
327: AND fla.pricing_attribute = t.attribute
328: AND t.context = a.pricing_attribute_context

Line 346: -- qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a

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

Line 366: -- qp_preq_line_attrs_formula_tmp t, qp_pricing_attributes a

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

Line 410: FROM qp_preq_line_attrs_formula_tmp

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

Line 472: FROM qp_preq_line_attrs_formula_tmp

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

Line 480: FROM qp_preq_line_attrs_formula_tmp

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