DBA Data[Home] [Help]

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 721: FROM ozf_offer_discount_products

717: SELECT product_id,
718: product_level,
719: off_discount_product_id,
720: NVL(uom_code, 'NA') uom_code
721: FROM ozf_offer_discount_products
722: WHERE excluder_flag = 'N'
723: AND offer_id = p_offer_id;
724:
725: CURSOR c_discount IS

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

1135: l_stmt := 'SELECT';
1136: 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, ' ;
1137: 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 ';
1138: l_stmt := l_stmt || ' FROM ozf_offer_discount_lines a, ';
1139: l_stmt := l_stmt || ' ozf_offer_discount_products b, ';
1140: l_stmt := l_stmt || ' eni_prod_den_hrchy_parents_v c, ';
1141: l_stmt := l_stmt || ' mtl_item_categories mic, ';
1142: l_stmt := l_stmt || ' eni_prod_denorm_hrchy_v epdhv ';
1143: l_stmt := l_stmt || ' WHERE a.offer_discount_line_id = b.offer_discount_line_id ';