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) */
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) */
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 545: INDX,QP_FORMULA_PRICE_CALC_PVT.calculate.sel1,QP_PRICE_FORMULA_LINES_U1,PRICE_FORMULA_ID,1

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

Line 549: FROM qp_price_formula_lines

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

Line 1213: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;

1209: p_null_step_number_tbl IN STEP_NUMBER_TBL_TYPE)
1210:
1211: IS
1212:
1213: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1214: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1215: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1216: l_all_steps VARCHAR2(100);
1217: l_formula_name qp_price_formulas_tl.name%TYPE;

Line 1214: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;

1210:
1211: IS
1212:
1213: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1214: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1215: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1216: l_all_steps VARCHAR2(100);
1217: l_formula_name qp_price_formulas_tl.name%TYPE;
1218: l_index NUMBER;

Line 1215: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;

1211: IS
1212:
1213: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1214: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1215: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1216: l_all_steps VARCHAR2(100);
1217: l_formula_name qp_price_formulas_tl.name%TYPE;
1218: l_index NUMBER;
1219: l_attribute VARCHAR2(80);

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

1232: -- query on formula ID instead of name, SQL repos
1233: SELECT formula into l_formula from qp_price_formulas_b
1234: WHERE price_formula_id = p_price_formula_id;
1235:
1236: SELECT count(*) into l_no_of_comps from qp_price_formula_lines
1237: WHERE price_formula_id = p_price_formula_id;
1238:
1239: FOR i IN 1..LENGTH(l_formula) LOOP
1240: l_char :=SUBSTR(l_formula,i,1);

Line 1269: FROM qp_price_formula_lines

1265: pricing_attribute
1266: INTO l_price_formula_line_type_code,
1267: l_pricing_attribute_context,
1268: l_pricing_attribute
1269: FROM qp_price_formula_lines
1270: WHERE price_formula_id = p_price_formula_id
1271: AND step_number = l_index;
1272:
1273: IF l_price_formula_line_type_code = 'LP'