APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 727: FROM ozf_offer_discount_products

723: CURSOR c_products(l_used_by_id NUMBER) IS
724: SELECT off_discount_product_id,
725: product_id,
726: product_level
727: FROM ozf_offer_discount_products
728: WHERE offer_id = l_used_by_id
729: AND off_discount_product_id = nvl(p_lline_id, off_discount_product_id)
730: AND excluder_flag = 'N';
731:

Line 736: FROM ozf_offer_discount_products

732: CURSOR c_excluded_products(l_used_by_id NUMBER,l_product_id NUMBER) IS
733: SELECT off_discount_product_id,
734: product_id,
735: product_level
736: FROM ozf_offer_discount_products
737: WHERE offer_id = l_used_by_id
738: AND parent_off_disc_prod_id = l_product_id
739: AND excluder_flag = 'Y';
740:

Line 743: FROM ozf_offer_discount_products

739: AND excluder_flag = 'Y';
740:
741: CURSOR c_no_products(l_used_by_id NUMBER) IS
742: SELECT COUNT(*)
743: FROM ozf_offer_discount_products
744: WHERE offer_id = l_used_by_id
745: AND off_discount_product_id = nvl(p_lline_id, off_discount_product_id)
746: AND excluder_flag = 'N';
747:

Line 750: FROM ozf_offer_discount_products

746: AND excluder_flag = 'N';
747:
748: CURSOR c_no_excl_products(l_used_by_id NUMBER,l_product_id NUMBER) IS
749: SELECT COUNT(*)
750: FROM ozf_offer_discount_products
751: WHERE offer_id = l_used_by_id
752: AND parent_off_disc_prod_id = l_product_id
753: AND excluder_flag = 'Y';
754:

Line 971: FROM ozf_offer_discount_products

967: product_context,
968: product_attribute,
969: product_attr_value,
970: offer_discount_line_id
971: FROM ozf_offer_discount_products
972: WHERE offer_id = l_offer_id
973: AND offer_discount_line_id = l_offer_discount_line_id
974: AND excluder_flag = 'N';
975:

Line 982: FROM ozf_offer_discount_products

978: product_context,
979: product_attribute,
980: product_attr_value,
981: offer_discount_line_id
982: FROM ozf_offer_discount_products
983: WHERE offer_id = l_offer_id
984: AND offer_discount_line_id = l_offer_discount_line_id
985: AND excluder_flag = 'Y';
986:

Line 989: FROM ozf_offer_discount_products

985: AND excluder_flag = 'Y';
986:
987: CURSOR c_no_products(l_offer_id NUMBER,l_offer_discount_line_id NUMBER) IS
988: SELECT COUNT(*)
989: FROM ozf_offer_discount_products
990: WHERE offer_id = l_offer_id
991: AND offer_discount_line_id = l_offer_discount_line_id
992: AND excluder_flag = 'N';
993:

Line 996: FROM ozf_offer_discount_products

992: AND excluder_flag = 'N';
993:
994: CURSOR c_no_excl_products(l_offer_id NUMBER,l_offer_discount_line_id NUMBER) IS
995: SELECT COUNT(*)
996: FROM ozf_offer_discount_products
997: WHERE offer_id = l_offer_id
998: AND offer_discount_line_id = l_offer_discount_line_id
999: AND excluder_flag = 'Y';
1000:

Line 2603: FROM ozf_offer_discount_products a, ozf_offers b

2599: AND (a.end_date_active IS NULL
2600: OR a.end_date_active >= SYSDATE)
2601: UNION
2602: SELECT off_discount_product_id lline_id
2603: FROM ozf_offer_discount_products a, ozf_offers b
2604: WHERE b.qp_list_header_id = ll_list_header_id
2605: AND a.offer_id = b.offer_id
2606: and b.offer_type = 'NET_ACCRUAL'
2607: AND a.excluder_flag = 'N'

Line 3044: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */

3040: END IF;
3041:
3042: ozf_utility_pvt.write_conc_log ('-- 1 --');
3043:
3044: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */
3045: IF l_stmt_product IS NOT NULL THEN
3046: -- FND_DSQL.add_text(' UNION SELECT distinct discount_line_id,apply_discount,include_volume, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3047: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
3048: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');