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_VOLUME_OFFER_ADJ dependencies on OZF_QP_DISCOUNTS

Line 13: -- with ozf_qp_discounts. The default tier for price breaks starting with "0" does not correspong to any ozf_qp_discount.

9: -- History
10: -- Tue Mar 14 2006:4/33 PM RSSHARMA Created
11: -- Mon Apr 03 2006:1/27 PM RSSHARMA Fixed end date Query for end dating lines
12: -- Tue Aug 15 2006:3/26 PM RSSHARMA Fixed bug # 5468261. Fixed query in populate_dis_lines, to outer join qp_rltd_deal_lines
13: -- with ozf_qp_discounts. The default tier for price breaks starting with "0" does not correspong to any ozf_qp_discount.
14: -- This outer join will enable selection of the default tier starting with "0".
15: -- Tue Aug 15 2006:6/17 PM RSSHARMA Contd # 5468261 fixes. Changed order of calling zero discounts. Also DO not create
16: -- relations for default line.
17: -- NOTE

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 506: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d

502: IS
503: CURSOR c_discountLines(cp_listLineId NUMBER , cp_offerAdjustmentId NUMBER)
504: IS
505: SELECT a.from_rltd_modifier_id, a.to_rltd_modifier_id, b.offer_discount_line_id , nvl(c.modified_discount,d.operand) discount , d.arithmetic_operator
506: FROM qp_rltd_modifiers a, ozf_qp_discounts b , ozf_offer_adjustment_tiers c , qp_list_lines d
507: WHERE a.to_rltd_modifier_id = b.list_line_id(+)
508: and b.offer_discount_line_id = c.offer_discount_line_id(+)
509: AND a.to_rltd_modifier_id = d.list_line_id
510: AND a.from_rltd_modifier_id = cp_listLineId

Line 750: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;

746: ,p_modifier_line_tbl IN QP_MODIFIERS_PUB.Modifiers_Tbl_Type
747: ,p_pricing_attr_tbl IN QP_MODIFIERS_PUB.Pricing_Attr_Tbl_Type
748: )
749: IS
750: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
751: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
752: l_qpDiscountId NUMBER;
753: l_qpProductId NUMBER;
754: l_objectVersion NUMBER;

Line 777: -- check for discount equality, in case yes insert into ozf_qp_discounts table

773: BEGIN
774: -- initialize
775: -- loop thru the Discount Structure
776: -- for each discount line loop thru. the qp_modifiers table
777: -- check for discount equality, in case yes insert into ozf_qp_discounts table
778: -- similar thing for relating products
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780: --dbms_output.put_line('Map Ozf qp lines');
781: --dbms_output.put_line('Table counts are :'||p_modifier_line_tbl.count||' : '||p_pricing_attr_tbl.count);

Line 798: OZF_QP_DISCOUNTS_PVT. Create_ozf_qp_discount

794: l_qpDiscountsRec := null;
795: l_qpDiscountsRec.list_line_id := p_modifier_line_tbl(i).list_line_id;
796: l_qpDiscountsRec.offer_discount_line_id := l_discounts.offer_discount_line_id;
797: l_qpDiscountsRec.start_date := sysdate;
798: OZF_QP_DISCOUNTS_PVT. Create_ozf_qp_discount
799: (
800: p_api_version_number => 1.0
801: , p_init_msg_list => FND_API.G_FALSE
802: , p_commit => FND_API.G_FALSE

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 1689: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;

1685: , x_msg_count OUT NOCOPY NUMBER
1686: , x_msg_data OUT NOCOPY VARCHAR2
1687: )
1688: IS
1689: l_qpDiscountsRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
1690: l_qpProductsRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;
1691: l_qpDiscountId NUMBER;
1692: l_qpProductId NUMBER;
1693: l_objectVersion NUMBER;

Line 1706: OZF_QP_DISCOUNTS_PVT.Create_ozf_qp_discount

1702: l_qpDiscountsRec := null;
1703: l_qpDiscountsRec.list_line_id := p_modifiers_tbl(i).list_line_id;
1704: l_qpDiscountsRec.offer_discount_line_id := p_modifiers_tbl(i).comments;
1705: l_qpDiscountsRec.start_date := sysdate;
1706: OZF_QP_DISCOUNTS_PVT.Create_ozf_qp_discount
1707: (
1708: p_api_version_number => 1.0
1709: , p_init_msg_list => FND_API.G_FALSE
1710: , p_commit => FND_API.G_FALSE

Line 1810: FROM ozf_offer_discount_products a, ozf_qp_discounts b , qp_list_lines c

1806: i NUMBER;
1807: CURSOR c_qpListLines(cp_offDiscountProductId NUMBER)
1808: IS
1809: SELECT b.list_line_id, a.product_attribute, a.product_attr_value , c.list_header_id
1810: FROM ozf_offer_discount_products a, ozf_qp_discounts b , qp_list_lines c
1811: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1812: AND b.list_line_id = c.list_line_id
1813: AND a.off_discount_product_id = p_offDiscountProductId;
1814: