DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_ADJUSTMENT_TIERS

Line 1971: FROM ozf_offer_adjustment_tiers adj_line,

1967: UNION ALL
1968: SELECT DISTINCT orig_line.parent_discount_line_id offer_adjustment_line_id,
1969: --AMITAMKU Fix for bug 15935374
1970: orig_line.parent_discount_line_id to_list_line_id --null to_list_line_id
1971: FROM ozf_offer_adjustment_tiers adj_line,
1972: ozf_offer_discount_lines orig_line
1973: WHERE adj_line.offer_adjustment_id = p_offer_adjustment_id
1974: AND adj_line.offer_discount_line_id = orig_line.offer_discount_line_id;
1975:

Line 2349: ozf_offer_adjustment_tiers adj_line,

2345: line.fulfillment_base -- Catch Weight ER
2346: FROM oe_order_lines_all line,
2347: ozf_adj_temp_eligibility temp,
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,

Line 2533: ozf_offer_adjustment_tiers adj_line,

2529: line.fulfillment_base -- Catch Weight ER
2530: FROM oe_order_lines_all line,
2531: ozf_adj_temp_eligibility temp,
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,