APPS.OZF_OFFER_BACKDATE_PVT dependencies on OZF_OFFER_ADJUSTMENT_PRODUCTS

Line 1684: FROM ozf_offer_adjustment_products a , ozf_offer_adjustments_b b, ozf_offers c

1680: , product_attribute
1681: , product_attr_value
1682: , apply_discount_flag
1683: , include_volume_flag
1684: FROM ozf_offer_adjustment_products a , ozf_offer_adjustments_b b, ozf_offers c
1685: WHERE a.offer_adjustment_id = b.offer_adjustment_id
1686: AND b.list_header_id = c.qp_list_header_id
1687: AND a.offer_adjustment_id = p_adjustment_id;
1688:

Line 1753: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_discount_lines c , ozf_offers d , ozf_offer_adjustments_b e

1749: , c.discount_type
1750: , e.effective_date
1751: , a.apply_discount_flag
1752: , a.include_volume_flag
1753: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_discount_lines c , ozf_offers d , ozf_offer_adjustments_b e
1754: WHERE a.offer_discount_line_id = c.offer_discount_line_id
1755: AND b.offer_discount_line_id = c.offer_discount_line_id
1756: AND a.product_context = b.product_context
1757: AND a.product_attribute = b.product_attribute

Line 1929: FROM ozf_offer_adjustment_products a, ozf_offer_discount_products b , ozf_offer_adjustments_b c, qp_pricing_attributes d

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

Line 1941: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b, ozf_offer_adjustments_b c, qp_list_lines d

1937: AND a.product_attr_value = d.product_attr_value
1938: AND a.offer_adjustment_id = p_offer_adjustment_id;
1939: CURSOR c_prod_reln(p_offer_adjustment_id NUMBER) IS
1940: SELECT b.offer_discount_line_id , d.list_line_id
1941: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b, ozf_offer_adjustments_b c, qp_list_lines d
1942: WHERE a.offer_discount_line_id = DECODE(b.tier_type,'PBH',offer_discount_line_id,parent_discount_line_id)
1943: AND b.offer_adjustment_id = a.offer_adjustment_id
1944: AND a.offer_adjustment_id = p_offer_adjustment_id
1945: AND c.list_header_id = d.list_header_id

Line 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

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)

Line 2006: ozf_offer_adjustment_products a, ozf_offer_adjustments_b b , ozf_offer_discount_products c, qp_pricing_attributes d

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