[Home] [Help]
1044:
1045: --query to retrieve list_line_id
1046: CURSOR c_list_line (p_offer_id IN NUMBER, p_product_id IN VARCHAR2) IS
1047: SELECT oq.list_line_id, op.product_attribute, op.product_attr_value
1048: FROM ozf_offer_discount_products op, ozf_qp_discounts oq
1049: WHERE (op.product_attr_value = p_product_id OR op.product_attr_value = 'ALL')
1050: AND op.offer_id = p_offer_id
1051: AND op.offer_discount_line_id = oq.offer_discount_line_id
1052: AND rownum = 1;
2349: ozf_offer_adjustment_tiers adj_line,
2350: ozf_offer_discount_lines orig_disc,
2351: ozf_offers off,
2352: qp_list_headers_all qp,
2353: ozf_qp_discounts map_lines,
2354: qp_list_lines lines
2355: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date))) BETWEEN adj.effective_date
2356: AND TRUNC(off.start_date) -- no new products for volume offer.
2357: AND line.booked_flag = 'Y'
2533: ozf_offer_adjustment_tiers adj_line,
2534: ozf_offer_discount_lines orig_disc,
2535: ozf_offers off,
2536: qp_list_headers_all qp,
2537: ozf_qp_discounts map_lines,
2538: qp_list_lines lines
2539: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date))) BETWEEN adj.effective_date
2540: AND TRUNC(off.start_date) -- no new products for volume offer.
2541: AND line.booked_flag = 'Y'