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.

[Home] [Help]

APPS.OZF_VOLUME_OFFER_ADJ dependencies on OZF_OFFER_DISCOUNT_LINES

Line 36: FROM ozf_offer_discount_lines a, ozf_offer_adjustment_tiers b

32: SELECT a.object_version_number
33: , a.offer_id
34: , a.parent_discount_line_id
35: , b.modified_discount
36: FROM ozf_offer_discount_lines a, ozf_offer_adjustment_tiers b
37: WHERE a.offer_discount_line_id = b.offer_discount_line_id
38: AND b.offer_discount_line_id = cp_offerDiscountLineId
39: AND b.offer_adjustment_id = cp_offerAdjustmentId;
40: BEGIN

Line 203: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c

199: IS
200: CURSOR c_qpListLines(cp_offerAdjustmentId NUMBER)
201: IS
202: SELECT distinct parent_discount_line_id , c.list_line_id
203: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c
204: WHERE a.offer_discount_line_id = b.offer_discount_line_id
205: AND b.parent_discount_line_id = c.offer_discount_line_id
206: AND a.offer_adjustment_id = cp_offerAdjustmentId;
207: BEGIN

Line 762: FROM ozf_offer_discount_lines

758: IS
759: SELECT discount
760: , tier_type
761: , offer_discount_line_id
762: FROM ozf_offer_discount_lines
763: WHERE offer_discount_line_id = cp_offerDiscountlineId
764: OR parent_discount_line_id = cp_offerDiscountLineId;
765: CURSOR c_products(cp_offerDiscountLineId NUMBER) IS
766: SELECT off_discount_product_id

Line 880: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d

876: l_pricing_attr_tbl QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type;
877: CURSOR c_tierHeader(cp_offerAdjustmentId NUMBER)
878: IS
879: SELECT distinct parent_discount_line_id , c.list_line_id
880: FROM ozf_offer_adjustment_tiers a, ozf_offer_discount_lines b , ozf_qp_discounts c , qp_list_lines d
881: WHERE a.offer_discount_line_id = b.offer_discount_line_id
882: AND b.parent_discount_line_id = c.offer_discount_line_id
883: AND c.list_line_id = d.list_line_id
884: AND d.list_line_type_code = 'PBH'

Line 1182: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b

1178: , a.include_volume_flag
1179: , b.offer_id
1180: , a.offer_adjustment_product_id
1181: , a.object_version_number
1182: FROM ozf_offer_adjustment_products a, ozf_offer_discount_lines b
1183: WHERE
1184: a.offer_discount_line_id = b.offer_discount_line_id
1185: AND offer_adjustment_id = cp_offerAdjustmentId;
1186:

Line 1304: ozf_offer_discount_lines a, ozf_offers b , ozf_offer_adjustments_b c , ozf_offer_discount_lines d

1300: , a.formula_id
1301: , a.discount
1302: , c.effective_date
1303: FROM
1304: ozf_offer_discount_lines a, ozf_offers b , ozf_offer_adjustments_b c , ozf_offer_discount_lines d
1305: WHERE
1306: a.offer_discount_line_id = cp_offerDiscountLineId
1307: AND a.offer_id = b.offer_id
1308: AND b.qp_list_header_id = c.list_header_id

Line 1382: FROM ozf_offer_discount_lines b , ozf_offer_discount_lines a

1378: , b.volume_from
1379: , b.volume_to
1380: , nvl( a.volume_type,b.volume_type) volume_type
1381: , nvl(b.volume_operator,'BETWEEN') comparison_operator_code
1382: FROM ozf_offer_discount_lines b , ozf_offer_discount_lines a
1383: WHERE b.offer_discount_line_id = cp_offerDiscountLineId
1384: AND b.parent_discount_line_id = a.offer_discount_line_id(+);
1385: BEGIN
1386: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1409: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b

1405: l_volumeFrom NUMBER;
1406: CURSOR c_minVolume(cp_offDiscountProductId NUMBER)
1407: IS
1408: SELECT min(volume_from)
1409: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b
1410: WHERE a.parent_discount_line_id = b.offer_discount_line_id
1411: AND b.off_discount_product_id = cp_offDiscountProductId;
1412: BEGIN
1413: OPEN c_minVolume(cp_offDiscountProductId => p_offDiscountProductId);

Line 1474: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b

1470: IS
1471: CURSOR c_discountLines(cp_parentDiscountLineId NUMBER , cp_offDiscountProductId NUMBER)
1472: IS
1473: SELECT a.offer_discount_line_id , b.apply_discount_flag
1474: FROM ozf_offer_discount_lines a, ozf_offer_discount_products b
1475: WHERE parent_discount_line_id = cp_parentDiscountLineId
1476: AND a.parent_discount_line_id = b.offer_discount_line_id
1477: AND b.off_discount_product_id = cp_offDiscountProductId;
1478: