APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 530: FROM ozf_offer_discount_products

526: product_level,
527: off_discount_product_id,
528: offer_discount_line_id,
529: NVL(uom_code, 'NA') uom_code
530: FROM ozf_offer_discount_products
531: WHERE excluder_flag = 'N'
532: AND offer_id = p_offer_id;
533:
534: CURSOR c_exclusion(p_off_discount_product_id NUMBER) IS

Line 537: FROM ozf_offer_discount_products

533:
534: CURSOR c_exclusion(p_off_discount_product_id NUMBER) IS
535: SELECT product_level,
536: product_id
537: FROM ozf_offer_discount_products
538: WHERE parent_off_disc_prod_id = p_off_discount_product_id
539: AND excluder_flag = 'Y';
540:
541: CURSOR c_discount(p_offer_discount_line_id NUMBER) IS

Line 740: FROM ozf_offer_discount_products

736: SELECT product_id,
737: product_level,
738: off_discount_product_id,
739: NVL(uom_code, 'NA') uom_code
740: FROM ozf_offer_discount_products
741: WHERE excluder_flag = 'N'
742: AND offer_id = p_offer_id;
743:
744: --amitamku - Added for Bug fix 13510229

Line 748: FROM ozf_offer_discount_products

744: --amitamku - Added for Bug fix 13510229
745: CURSOR c_exclusion(p_off_discount_product_id NUMBER) IS
746: SELECT product_level,
747: product_id
748: FROM ozf_offer_discount_products
749: WHERE parent_off_disc_prod_id = p_off_discount_product_id
750: AND excluder_flag = 'Y';
751: ----amitamku - End of - Added for Bug fix 13510229
752:

Line 1236: l_stmt := l_stmt || ' ozf_offer_discount_products b, ';

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 ';
1240: l_stmt := l_stmt || ' WHERE a.offer_discount_line_id = b.offer_discount_line_id ';