30: AND a.product_attribute_context = 'ITEM'
31: AND a.product_attribute = 'PRICING_ATTRIBUTE1'
32: AND a.product_attr_value = P_Inventory_Id
33: AND (price_by_formula_id IN (SELECT price_formula_id
34: FROM qp_price_formulas_b
35: WHERE EXISTS (SELECT 'x'
36: FROM qp_price_formula_lines fl, qp_price_formulas_b b
37: WHERE fl.price_formula_line_type_code = 'PRA'
38: AND fl.price_formula_id = b.price_formula_id)
32: AND a.product_attr_value = P_Inventory_Id
33: AND (price_by_formula_id IN (SELECT price_formula_id
34: FROM qp_price_formulas_b
35: WHERE EXISTS (SELECT 'x'
36: FROM qp_price_formula_lines fl, qp_price_formulas_b b
37: WHERE fl.price_formula_line_type_code = 'PRA'
38: AND fl.price_formula_id = b.price_formula_id)
39: )
40: OR (a.pricing_attribute_context IS NOT NULL