APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 730: FROM ozf_offer_discount_products

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

Line 739: FROM ozf_offer_discount_products

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

Line 746: FROM ozf_offer_discount_products

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

Line 753: FROM ozf_offer_discount_products

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

Line 962: FROM ozf_offer_discount_products

958: product_context,
959: product_attribute,
960: product_attr_value,
961: offer_discount_line_id
962: FROM ozf_offer_discount_products
963: WHERE offer_id = l_offer_id
964: AND offer_discount_line_id = l_offer_discount_line_id
965: AND excluder_flag = 'N';
966:

Line 973: FROM ozf_offer_discount_products

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

Line 980: FROM ozf_offer_discount_products

976: AND excluder_flag = 'Y';
977:
978: CURSOR c_no_products(l_offer_id NUMBER,l_offer_discount_line_id NUMBER) IS
979: SELECT COUNT(*)
980: FROM ozf_offer_discount_products
981: WHERE offer_id = l_offer_id
982: AND offer_discount_line_id = l_offer_discount_line_id
983: AND excluder_flag = 'N';
984:

Line 987: FROM ozf_offer_discount_products

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

Line 2546: FROM ozf_offer_discount_products a, ozf_offers b

2542: AND (a.end_date_active IS NULL
2543: OR a.end_date_active >= SYSDATE)
2544: UNION
2545: SELECT off_discount_product_id lline_id
2546: FROM ozf_offer_discount_products a, ozf_offers b
2547: WHERE b.qp_list_header_id = ll_list_header_id
2548: AND a.offer_id = b.offer_id
2549: and b.offer_type = 'NET_ACCRUAL'
2550: AND a.excluder_flag = 'N'

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

2981: END IF;
2982:
2983: ozf_utility_pvt.write_conc_log ('-- 1 --');
2984:
2985: /* the following has to modified to read from ozf_offer_discount_products to handle volume offers */
2986: IF l_stmt_product IS NOT NULL THEN
2987: -- 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, ');
2988: FND_DSQL.add_text(' UNION ALL SELECT distinct null items_category, to_number(decode(product_attr_value,''ALL'',''-9999'',product_attr_value)) product_id, ');
2989: FND_DSQL.add_text(' product_attribute product_type FROM qp_pricing_attributes ');