2392: CURSOR c_incremental_actual_values(l_date DATE)
2393: IS
2394: select distinct adj.list_header_id offer_id,
2395: af.forecast_uom_code
2396: from oe_price_adjustments adj,
2397: oe_order_lines line,
2398: ozf_act_forecasts_all af
2399: where adj.line_id = line.line_id
2400: and line.open_flag = 'N'
2435: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2436: line.order_quantity_uom,
2437: head.transactional_curr_code order_currency,
2438: NVL(line.actual_shipment_date, line.request_date) trans_date
2439: FROM oe_price_adjustments adj,
2440: oe_order_lines_all line,
2441: oe_order_headers_all head
2442: WHERE adj.list_header_id = l_offer_id
2443: AND adj.line_id = line.line_id
2466: --CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
2467: line.order_quantity_uom,
2468: head.transactional_curr_code order_currency,
2469: NVL(line.actual_shipment_date, line.request_date) trans_date
2470: FROM oe_price_adjustments adj,
2471: oe_order_lines_all line,
2472: oe_order_headers_all head
2473: WHERE adj.list_header_id = l_offer_id
2474: AND adj.line_id = line.line_id
4087: CST_COST_API.get_item_cost(1, line.inventory_item_id, l_org_id, NULL,NULL) cost,
4088: line.order_quantity_uom,
4089: head.transactional_curr_code order_currency,
4090: NVL(line.actual_shipment_date,line.request_date) trans_date
4091: FROM oe_price_adjustments adj,
4092: oe_order_lines_all line,
4093: oe_order_headers_all head
4094: WHERE adj.list_header_id = l_offer_id
4095: AND adj.line_id = line.line_id