APPS.OE_CHARGE_PVT dependencies on OE_PRICE_ADJUSTMENTS_V

Line 303: FROM OE_PRICE_ADJUSTMENTS_V

299: oe_debug_pub.add( 'LINE IS SHIPPABLE AND IS SHIPPED' ) ;
300: END IF;
301: SELECT SUM(ADJUSTED_AMOUNT)
302: INTO l_cost_amount
303: FROM OE_PRICE_ADJUSTMENTS_V
304: WHERE LINE_ID = l_line_rec.line_id
305: AND LIST_LINE_TYPE_CODE = 'COST'
306: AND CHARGE_TYPE_CODE = p_cost_type_code;
307:

Line 377: FROM OE_PRICE_ADJUSTMENTS_V

373: l_count NUMBER := 0;
374: l_line_rec OE_Order_PUB.Line_Rec_Type;
375: Cursor C_Get_Cost_Types(p_line_id NUMBER) IS
376: SELECT DISTINCT CHARGE_TYPE_CODE
377: FROM OE_PRICE_ADJUSTMENTS_V
378: WHERE LINE_ID = p_line_id
379: AND LIST_LINE_TYPE_CODE = 'COST';
380: --
381: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1254: FROM OE_PRICE_ADJUSTMENTS_V

1250: -- list_line_type_code = 'COST'
1251: Begin
1252: SELECT SUM(ADJUSTED_AMOUNT)
1253: INTO l_cost_amount
1254: FROM OE_PRICE_ADJUSTMENTS_V
1255: WHERE LINE_ID = l_line_rec.line_id
1256: AND LIST_LINE_TYPE_CODE = 'COST'
1257: AND CHARGE_TYPE_CODE = l_cost_type_code;
1258: IF l_debug_level > 0 THEN