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_ADJUSTMENT_TIERS

Line 1484: FROM OZF_OFFER_ADJUSTMENT_TIERS

1480:
1481:
1482: CURSOR c_adj_lines IS
1483: SELECT modified_discount , qp_list_header_id
1484: FROM OZF_OFFER_ADJUSTMENT_TIERS
1485: WHERE
1486: offer_adjustment_id = p_offer_adjustment_id
1487: AND original_discount =
1488: (SELECT operand FROM qp_list_lines WHERE list_header_id

Line 1489: = (select qp_list_header_id FROM ozf_offer_adjustment_tiers WHERE offer_adjustment_id = p_offer_adjustment_id and rownum < 2)

1485: WHERE
1486: offer_adjustment_id = p_offer_adjustment_id
1487: AND original_discount =
1488: (SELECT operand FROM qp_list_lines WHERE list_header_id
1489: = (select qp_list_header_id FROM ozf_offer_adjustment_tiers WHERE offer_adjustment_id = p_offer_adjustment_id and rownum < 2)
1490: and rownum < 2)
1491: ;
1492:
1493:

Line 1520: FROM ozf_offer_adjustment_tiers

1516:
1517: CURSOR c_adj_tiers IS
1518: SELECT volume_offer_tiers_id
1519: ,modified_discount
1520: FROM ozf_offer_adjustment_tiers
1521: WHERE offer_adjustment_id = p_offer_adjustment_id;
1522:
1523: CURSOR c_tier_detail(l_tier_id NUMBER) IS
1524: SELECT *

Line 2153: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b , qp_list_Lines c, ozf_offer_adjustments_b d

2149: DECLARE
2150: CURSOR c_qp_list_lines(p_adjustment_id NUMBER)
2151: IS
2152: SELECT c.list_line_id , c.list_header_id , d.effective_date , a.modified_discount, c.arithmetic_operator
2153: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b , qp_list_Lines c, ozf_offer_adjustments_b d
2154: WHERE a.offer_discount_line_id = b.offer_discount_line_id
2155: AND b.list_line_id = c.list_line_id
2156: AND a.offer_adjustment_id = d.offer_adjustment_id
2157: AND a.offer_adjustment_id = p_adjustment_id;

Line 2201: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b

2197: DECLARE
2198: CURSOR c_discounts(p_offer_adjustment_id NUMBER) IS
2199: SELECT
2200: a.modified_discount, a.offer_discount_line_id , b.object_version_number , b.offer_id
2201: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b
2202: WHERE a.offer_adjustment_id = p_offer_adjustment_id
2203: AND a.offer_discount_line_id = b.offer_discount_line_id;
2204: l_vo_disc_rec OZF_Volume_Offer_disc_PVT.vo_disc_rec_type;
2205: BEGIN

Line 2244: FROM ozf_offer_adjustment_tiers a, ozf_qp_discounts b, qp_pricing_attributes c, qp_rltd_modifiers d

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

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