APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 2453: from oe_price_adjustments adj,

2449: CURSOR c_incremental_actual_values(l_date DATE)
2450: IS
2451: select distinct adj.list_header_id offer_id,
2452: af.forecast_uom_code
2453: from oe_price_adjustments adj,
2454: oe_order_lines line,
2455: ozf_act_forecasts_all af
2456: where adj.line_id = line.line_id
2457: and line.open_flag = 'N'

Line 2496: FROM oe_price_adjustments adj,

2492: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2493: line.order_quantity_uom,
2494: head.transactional_curr_code order_currency,
2495: NVL(line.actual_shipment_date, line.request_date) trans_date
2496: FROM oe_price_adjustments adj,
2497: oe_order_lines_all line,
2498: oe_order_headers_all head
2499: WHERE adj.list_header_id = l_offer_id
2500: AND adj.line_id = line.line_id

Line 2527: FROM oe_price_adjustments adj,

2523: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2524: line.order_quantity_uom,
2525: head.transactional_curr_code order_currency,
2526: NVL(line.actual_shipment_date, line.request_date) trans_date
2527: FROM oe_price_adjustments adj,
2528: oe_order_lines_all line,
2529: oe_order_headers_all head
2530: WHERE adj.list_header_id = l_offer_id
2531: AND adj.line_id = line.line_id

Line 4154: FROM oe_price_adjustments adj,

4150: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
4151: line.order_quantity_uom,
4152: head.transactional_curr_code order_currency,
4153: NVL(line.actual_shipment_date,line.request_date) trans_date
4154: FROM oe_price_adjustments adj,
4155: oe_order_lines_all line,
4156: oe_order_headers_all head
4157: WHERE adj.list_header_id = l_offer_id
4158: AND adj.line_id = line.line_id