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_FORMULA_PRICE_CALC_PVT dependencies on QP_FACTOR_LIST_ATTRS

Line 223: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_FACTOR_LIST_ATTRS_N1,LIST_HEADER_ID,1

219: --POSCO performance related.
220: /*
221: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PRICE_FORMULA_LINES_N1,PRICE_FORMULA_LINE_TYPE_CODE,1
222: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PRICE_FORMULA_LINES_N1,PRICE_FORMULA_ID,2
223: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_FACTOR_LIST_ATTRS_N1,LIST_HEADER_ID,1
224: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,PRICING_STATUS_CODE,1
225: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,ATTRIBUTE_TYPE,2
226: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,CONTEXT,3
227: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,ATTRIBUTE,4

Line 247: FROM qp_price_formula_lines fl, qp_factor_list_attrs fla,

243: SELECT /*+ ORDERED index(a QP_PRICING_ATTRIBUTES_N8) index(t qp_preq_line_attrs_frml_tmp_n1) */ -- 9362867
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

Line 273: FROM qp_price_formula_lines fl, qp_factor_list_attrs fla,

269: SELECT /*+ ORDERED index(a QP_PRICING_ATTRIBUTES_N10) index(t qp_preq_line_attrs_frml_tmp_n1) */ -- 9362867
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

Line 299: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sub_factors_cur,QP_FACTOR_LIST_ATTRS_N1,LIST_HEADER_ID,1

295:
296: --Introduced sub_factors_cur to incorporate search_ind for pricing_attributes.
297: --POSCO performance related.
298: /*
299: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sub_factors_cur,QP_FACTOR_LIST_ATTRS_N1,LIST_HEADER_ID,1
300: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sub_factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,PRICING_STATUS_CODE,1
301: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sub_factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,ATTRIBUTE_TYPE,2
302: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sub_factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,CONTEXT,3
303: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sub_factors_cur,QP_PREQ_LINE_ATTRS_FRML_TMP_N1,ATTRIBUTE,4

Line 325: FROM qp_factor_list_attrs fla,

321: IS
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

Line 347: -- FROM qp_factor_list_attrs fla,

343:
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

Line 367: -- FROM qp_factor_list_attrs fla,

363: -- HAVING count(*) = a_group_count
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