[Home] [Help]
1166: select qp.pricing_attribute_id,
1167: ql.list_line_id,
1168: ql.arithmetic_operator,
1169: ql.operand
1170: from qp_pricing_attributes qp,
1171: qp_list_lines ql
1172: where ql.list_header_id = l_id
1173: and qp.list_header_id = l_id -- julou added for sql performance xxfix
1174: and ql.list_line_id = qp.list_line_id
1501: ,pricing_attribute
1502: ,pricing_attr_value_from
1503: ,pricing_attr_value_to
1504: ,excluder_flag
1505: FROM qp_pricing_attributes
1506: WHERE list_header_id = l_list_header_id
1507: AND list_line_id = l_list_line_id;
1508:
1509: CURSOR c_qualifier(l_list_header_id NUMBER, l_list_line_id NUMBER) IS
1586: l_modifier_line_tbl(l_index).inactive_flag := 'Y';
1587: END IF;
1588: -- end benefit quantity
1589:
1590: -- get pricing attribute from qp_pricing_attributes
1591: OPEN c_pricing_attr(l_qp_line_detail.list_header_id, l_qp_line_detail.list_line_id);
1592: FETCH c_pricing_attr INTO l_modifier_line_tbl(l_index).pricing_attribute_id
1593: ,l_modifier_line_tbl(l_index).product_attribute_context
1594: ,l_modifier_line_tbl(l_index).product_attr
1925:
1926: DECLARE
1927: /*CURSOR c_disc_reln(p_offer_adjustment_id NUMBER) IS
1928: SELECT distinct b.off_discount_product_id , d.pricing_attribute_id
1929: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_adjustments_b c, qp_pricing_attributes d
1930: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1931: AND a.product_attribute = b.product_attribute
1932: AND a.product_attr_value = b.product_attr_value
1933: AND a.excluder_flag = b.excluder_flag
1948: --AND nvl(b.discount_type,'-1') = nvl(d.arithmetic_operator)
1949: */
1950: CURSOR c_create_reln(p_offer_adjustment_id NUMBER) IS
1951: SELECT c.offer_discount_line_id, b.off_discount_product_id , d.list_line_id , d.pricing_attribute_id
1952: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b, ozf_offer_discount_lines c , ozf_offer_adjustments_b e ,qp_pricing_attributes d
1953: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1954: AND a.product_attr_value = b.product_attr_value
1955: AND a.offer_adjustment_id = p_offer_adjustment_id
1956: AND b.offer_discount_line_id = decode(c.tier_type , 'DIS',c.parent_discount_line_id, c.offer_discount_line_id)
2002: DECLARE
2003: CURSOR c_dis_products(p_offer_adjustment_id NUMBER) IS
2004: SELECT c.off_discount_product_id , d.pricing_attribute_id
2005: FROM
2006: ozf_offer_adjustment_products a, ozf_offer_adjustments_b b , ozf_offer_discount_products c, qp_pricing_attributes d
2007: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2008: AND a.offer_adjustment_id = p_offer_adjustment_id
2009: AND a.offer_discount_line_id = c.offer_discount_line_id
2010: AND a.product_attribute = c.product_attribute
2240: , a.modified_discount operand
2241: , f.arithmetic_operator arithmetic_operator
2242: , c.pricing_attribute pricing_attribute
2243: , e.effective_date start_date_active
2244: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b, qp_pricing_attributes c, qp_rltd_modifiers d
2245: , ozf_offer_adjustments_b e, qp_list_lines f
2246: WHERE a.offer_discount_line_id = b.offer_discount_line_id
2247: AND b.list_line_id = c.list_line_id
2248: AND c.list_line_id = d.to_rltd_modifier_id
2291: DECLARE
2292: CURSOR c_create_reln(p_offer_adjustment_id NUMBER)
2293: IS
2294: SELECT a.offer_discount_line_id , f.off_discount_product_id , e.pricing_attribute_id , d.list_line_id
2295: FROM ozf_offer_adjustment_tiers a, ozf_offer_adjustments_b b , ozf_offer_discount_lines c , qp_list_lines d , qp_pricing_attributes e , ozf_offer_discount_products f
2296: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2297: AND c.offer_discount_line_id = a.offer_discount_line_id
2298: AND b.list_header_id = d.list_header_id
2299: AND d.list_line_id = e.list_line_id