eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_BACKDATE_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

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 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

Line 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

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