APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 2050: qp_pricing_attributes qpa

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(
2054: CASE

Line 2149: qp_pricing_attributes qpa

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(
2153: CASE

Line 2255: qp_pricing_attributes qpa

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(
2259: CASE

Line 2439: qp_pricing_attributes qpa

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(
2443: CASE

Line 6838: FROM ozf_offer_adjustment_lines adjl, qp_pricing_attributes qppa

6834: CURSOR c_off_adj_lines IS
6835: SELECT offer_adjustment_line_id,
6836: qppa.product_attribute,
6837: qppa.product_attr_value
6838: FROM ozf_offer_adjustment_lines adjl, qp_pricing_attributes qppa
6839: WHERE adjl.offer_adjustment_id = p_offer_adjustment_id AND adjl.list_line_id = qppa.list_line_id;
6840: BEGIN
6841: -- ozf_utility_pvt.debug_message('enter validate_product_budget obj_id=' || p_object_id || ' budget_id=' || p_budget_id);
6842: