[Home] [Help]
1956: UNION ALL
1957: SELECT adj.offer_adjustment_line_id,
1958: to_list_line_id
1959: FROM ozf_offer_adjustment_lines adj,
1960: qp_list_lines lines,
1961: ozf_offer_adj_rltd_lines rltd
1962: WHERE adj.offer_adjustment_id = p_offer_adjustment_id
1963: AND lines.list_line_type_code = 'DIS'
1964: AND lines.list_line_id =nvl(adj.list_line_id, adj.list_line_id_td)
2044: ozf_adj_temp_eligibility temp,
2045: ozf_offer_adjustments_b adj,
2046: ozf_offer_adjustment_lines adj_line,
2047: ozf_offers off,
2048: qp_list_lines lines,
2049: qp_list_headers_all qp,
2050: qp_pricing_attributes qpa
2051: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))
2052: BETWEEN decode(adj_line.created_from_adjustments, 'Y', TRUNC(nvl(lines.start_date_active, adj.effective_date)), adj.effective_date)
2143: ozf_adj_temp_eligibility temp,
2144: ozf_offer_adjustments_b adj,
2145: ozf_offer_adjustment_lines adj_line,
2146: ozf_offers off,
2147: qp_list_lines lines,
2148: qp_list_headers_all qp,
2149: qp_pricing_attributes qpa
2150: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))
2151: BETWEEN decode(adj_line.created_from_adjustments, 'Y', TRUNC(nvl(lines.start_date_active, adj.effective_date)), adj.effective_date)
2249: ozf_adj_temp_eligibility temp,
2250: ozf_offer_adjustments_b adj,
2251: ozf_offer_adjustment_lines adj_line,
2252: ozf_offers off,
2253: qp_list_lines lines,
2254: qp_list_headers_all qp,
2255: qp_pricing_attributes qpa
2256: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))
2257: BETWEEN decode(adj_line.created_from_adjustments, 'Y', TRUNC(nvl(lines.start_date_active, adj.effective_date)), adj.effective_date)
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'
2358: AND line.cancelled_flag = 'N'
2433: ozf_adj_temp_eligibility temp,
2434: ozf_offer_adjustments_b adj,
2435: ozf_offer_adjustment_lines adj_line,
2436: ozf_offers off,
2437: qp_list_lines lines,
2438: qp_list_headers_all qp,
2439: qp_pricing_attributes qpa
2440: WHERE TRUNC(nvl(line.pricing_date, nvl(line.actual_shipment_date, line.fulfillment_date)))
2441: BETWEEN decode(adj_line.created_from_adjustments, 'Y', TRUNC(nvl(lines.start_date_active, adj.effective_date)), adj.effective_date)
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'
2542: AND line.cancelled_flag = 'N'
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;
2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;
2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;