APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on SO_RULE_FORMULA_COMPONENTS

Line 641: FROM so_rule_formula_components c

637:
638: CURSOR unused_components_cur
639: IS
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:

Line 1116: so_rule_formula_components c

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
1120: AND l.pricing_rule_id = a_pricing_rule_id

Line 1201: FROM so_rule_formula_components

1197: --(Factor Pricing Attributes). Need to get contexts first.
1198:
1199: SELECT entity_id_1, entity_id_2, entity_id_3, entity_id_4, entity_id_5
1200: INTO l_entity1, l_entity2, l_entity3, l_entity4, l_entity5
1201: FROM so_rule_formula_components
1202: WHERE formula_component_id = l_lines_rec.formula_component_id;
1203:
1204: --Function to get Context and Attribute based on entity_code.
1205: --If entity_code is not an item-context then fetch contexts from

Line 1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');

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:
1562: EXCEPTION