APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on QP_LIST_HEADERS_ALL

Line 2049: qp_list_headers_all qp,

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)
2053: AND decode(adj_line.created_from_adjustments, 'Y', TRUNC(

Line 2148: qp_list_headers_all qp,

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)
2152: AND decode(adj_line.created_from_adjustments, 'Y', TRUNC(

Line 2254: qp_list_headers_all qp,

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)
2258: AND decode(adj_line.created_from_adjustments, 'Y', TRUNC(

Line 2352: qp_list_headers_all qp,

2348: ozf_offer_adjustments_b adj,
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.

Line 2438: qp_list_headers_all qp,

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)
2442: AND decode(adj_line.created_from_adjustments, 'Y', TRUNC(

Line 2536: qp_list_headers_all qp,

2532: ozf_offer_adjustments_b adj,
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.

Line 2608: FROM qp_list_headers_all qp, ozf_offers off

2604: --kdass 09-DEC-2005 fix for bug 4872799
2605: trunc(off.start_date) start_date
2606: ,off.volume_offer_type
2607: ,qp.orig_org_id offer_org_id, off.transaction_currency_code offer_currency
2608: FROM qp_list_headers_all qp, ozf_offers off
2609: WHERE qp.list_header_id = p_list_header_id
2610: AND qp.list_header_id = off.qp_list_header_id;
2611:
2612:

Line 4803: FROM ozf_offers off, qp_list_headers_all qp

4799: beneficiary_account_id,
4800: autopay_party_attr,
4801: autopay_party_id,
4802: description
4803: FROM ozf_offers off, qp_list_headers_all qp
4804: WHERE off.qp_list_header_id = p_list_header_id
4805: AND off.qp_list_header_id = qp.list_header_id;
4806:
4807: CURSOR c_adj_info(p_list_line_id IN NUMBER) IS