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_PRICE_FORMULA_LINES

Line 208: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.formula_lines_cur,QP_PRICE_FORMULA_LINES_U1,PRICE_FORMULA_ID,1

204: RETURN NUMBER
205: IS
206:
207: /*
208: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.formula_lines_cur,QP_PRICE_FORMULA_LINES_U1,PRICE_FORMULA_ID,1
209: */
210: CURSOR formula_lines_cur (a_price_formula_id NUMBER)
211: IS
212: SELECT step_number, price_formula_line_type_code, numeric_constant,

Line 215: FROM qp_price_formula_lines

211: IS
212: SELECT step_number, price_formula_line_type_code, numeric_constant,
213: pricing_attribute, pricing_attribute_context,
214: price_formula_id, price_list_line_id
215: FROM qp_price_formula_lines
216: WHERE price_formula_id = a_price_formula_id;
217:
218: --Modified factors_cur to incorporate search_ind for pricing_attributes.
219: --POSCO performance related.

Line 221: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PRICE_FORMULA_LINES_N1,PRICE_FORMULA_LINE_TYPE_CODE,1

217:
218: --Modified factors_cur to incorporate search_ind for pricing_attributes.
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

Line 222: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.factors_cur,QP_PRICE_FORMULA_LINES_N1,PRICE_FORMULA_ID,2

218: --Modified factors_cur to incorporate search_ind for pricing_attributes.
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

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 549: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sel1,QP_PRICE_FORMULA_LINES_U1,PRICE_FORMULA_ID,1

545: END IF;
546:
547: --Get the no_of_components in the formula
548: /*
549: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sel1,QP_PRICE_FORMULA_LINES_U1,PRICE_FORMULA_ID,1
550: */
551: SELECT count(*)
552: INTO l_no_of_comps
553: FROM qp_price_formula_lines

Line 553: FROM qp_price_formula_lines

549: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sel1,QP_PRICE_FORMULA_LINES_U1,PRICE_FORMULA_ID,1
550: */
551: SELECT count(*)
552: INTO l_no_of_comps
553: FROM qp_price_formula_lines
554: WHERE price_formula_id = p_price_formula_id;
555:
556: IF l_no_of_comps = 0 THEN
557:

Line 1427: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;

1423: p_null_step_number_tbl IN STEP_NUMBER_TBL_TYPE)
1424:
1425: IS
1426:
1427: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1428: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1429: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1430: l_all_steps VARCHAR2(100);
1431: l_formula_name qp_price_formulas_tl.name%TYPE;

Line 1428: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;

1424:
1425: IS
1426:
1427: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1428: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1429: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1430: l_all_steps VARCHAR2(100);
1431: l_formula_name qp_price_formulas_tl.name%TYPE;
1432: l_index NUMBER;

Line 1429: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;

1425: IS
1426:
1427: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1428: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1429: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1430: l_all_steps VARCHAR2(100);
1431: l_formula_name qp_price_formulas_tl.name%TYPE;
1432: l_index NUMBER;
1433: l_attribute VARCHAR2(80);

Line 1450: SELECT count(*) into l_no_of_comps from qp_price_formula_lines

1446: -- query on formula ID instead of name, SQL repos
1447: SELECT formula into l_formula from qp_price_formulas_b
1448: WHERE price_formula_id = p_price_formula_id;
1449:
1450: SELECT count(*) into l_no_of_comps from qp_price_formula_lines
1451: WHERE price_formula_id = p_price_formula_id;
1452:
1453: FOR i IN 1..LENGTH(l_formula) LOOP
1454: l_char :=SUBSTR(l_formula,i,1);

Line 1483: FROM qp_price_formula_lines

1479: pricing_attribute
1480: INTO l_price_formula_line_type_code,
1481: l_pricing_attribute_context,
1482: l_pricing_attribute
1483: FROM qp_price_formula_lines
1484: WHERE price_formula_id = p_price_formula_id
1485: AND step_number = l_index;
1486:
1487: IF l_price_formula_line_type_code = 'LP'