APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 547: FROM ozf_offer_discount_lines

543: discount_type,
544: NVL(volume_from,0),
545: volume_to,
546: DECODE(volume_type, 'PRICING_ATTRIBUTE12', 'AMT', 'PRICING_ATTRIBUTE10', 'QTY', NULL, 'NA')
547: FROM ozf_offer_discount_lines
548: WHERE offer_discount_line_id = p_offer_discount_line_id;
549:
550:
551: l_api_name CONSTANT VARCHAR2(30) := 'populate_prod_line';

Line 759: FROM ozf_offer_discount_lines

755: discount_type,
756: NVL(volume_from,0) volume_from,
757: volume_to,
758: DECODE(volume_type, 'PRICING_ATTRIBUTE12', 'AMT', 'PRICING_ATTRIBUTE10', 'QTY', NULL, 'NA') volume_type
759: FROM ozf_offer_discount_lines
760: WHERE offer_id = p_offer_id;
761:
762: l_api_name CONSTANT VARCHAR2(30) := 'populate_prod_tier';
763: l_discount NUMBER;

Line 1235: l_stmt := l_stmt || ' FROM ozf_offer_discount_lines a, ';

1231: --
1232: l_stmt := 'SELECT';
1233: l_stmt := l_stmt || ' DISTINCT FIRST_VALUE(a.discount) OVER (PARTITION BY epdhv.child_id ORDER BY c.category_level_num DESC NULLS LAST) discount, ' ;
1234: l_stmt := l_stmt || ' FIRST_VALUE(b.product_id) OVER (PARTITION BY epdhv.child_id ORDER BY c.category_level_num DESC NULLS LAST) product_id ';
1235: l_stmt := l_stmt || ' FROM ozf_offer_discount_lines a, ';
1236: l_stmt := l_stmt || ' ozf_offer_discount_products b, ';
1237: l_stmt := l_stmt || ' eni_prod_den_hrchy_parents_v c, ';
1238: l_stmt := l_stmt || ' mtl_item_categories mic, ';
1239: l_stmt := l_stmt || ' eni_prod_denorm_hrchy_v epdhv ';

Line 2168: FROM ozf_offer_discount_lines

2164:
2165: -- Catch Weight ER - start
2166: CURSOR c_offer_uom_code(l_offer_id NUMBER) IS
2167: SELECT uom_code
2168: FROM ozf_offer_discount_lines
2169: WHERE offer_id = l_offer_id;
2170:
2171: l_offer_uom_code VARCHAR2(10);
2172: l_ship_quantity NUMBER;