APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on SO_PRICING_RULE_LINES

Line 644: FROM so_pricing_rule_lines b);

640: SELECT *
641: FROM so_rule_formula_components c
642: WHERE c.formula_component_id NOT IN
643: (SELECT b.formula_component_id
644: FROM so_pricing_rule_lines b);
645:
646: BEGIN
647:
648: FOR l_comp_rec IN unused_components_cur

Line 1083: CURSOR so_pricing_rule_lines_cur (a_pricing_rule_id NUMBER)

1079: SELECT *
1080: FROM so_pricing_rules_vl
1081: WHERE pricing_rule_id BETWEEN a_min_line AND a_max_line;
1082:
1083: CURSOR so_pricing_rule_lines_cur (a_pricing_rule_id NUMBER)
1084: IS
1085: SELECT *
1086: FROM so_pricing_rule_lines l
1087: WHERE l.pricing_rule_id = a_pricing_rule_id;

Line 1086: FROM so_pricing_rule_lines l

1082:
1083: CURSOR so_pricing_rule_lines_cur (a_pricing_rule_id NUMBER)
1084: IS
1085: SELECT *
1086: FROM so_pricing_rule_lines l
1087: WHERE l.pricing_rule_id = a_pricing_rule_id;
1088:
1089: CURSOR so_rule_line_comp_values_cur(a_pricing_rule_id NUMBER,
1090: a_step_number NUMBER)

Line 1115: FROM so_pricing_rule_lines l, so_pricing_rule_line_values v,

1111: c.attribute11 c_attribute11, c.attribute12 c_attribute12,
1112: c.attribute13 c_attribute13, c.attribute14 c_attribute14,
1113: c.attribute15 c_attribute15
1114:
1115: FROM so_pricing_rule_lines l, so_pricing_rule_line_values v,
1116: so_rule_formula_components c
1117: WHERE l.pricing_rule_id = v.pricing_rule_id(+)
1118: AND l.step_number = v.step_number(+)
1119: AND l.formula_component_id = c.formula_component_id

Line 1188: so_pricing_rule_lines_cur(l_rec.pricing_rule_id)

1184: l_rec.description);
1185:
1186:
1187: FOR l_lines_rec IN
1188: so_pricing_rule_lines_cur(l_rec.pricing_rule_id)
1189: LOOP
1190:
1191: SELECT QP_PRICE_FORMULA_LINES_S.nextval
1192: INTO l_price_formula_line_id

Line 1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');

1553: -- Flexfield Merging
1554: -- Run the utility procedure to upgrade Descriptive Flexfields
1555: -- from Pricing to Price Formulas
1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');
1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');
1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');
1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');
1560: commit;
1561: