APPS.ONT_FREIGHT_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 112: from oe_price_adjustments pa,

108: pa.cost_id,
109: pa.list_line_type_code,
110: pa.adjusted_amount,
111: pa.operand
112: from oe_price_adjustments pa,
113: wsh_delivery_details dd,
114: wsh_delivery_assignments da,
115: wsh_new_deliveries dl
116: where dl.name = 'delivery_name'

Line 125: From oe_price_adjustments

121: and pa.list_line_type_code = 'COST'; */
122:
123: Cursor Other_Cost is
124: Select CHARGE_TYPE_CODE,Adjusted_amount
125: From oe_price_adjustments
126: Where line_id = l_line_rec.line_id
127: and list_line_type_code = 'COST';
128:
129: Cursor formula_attribute(p_price_formula_id In Number) is

Line 412: -- Cost records are stored in OE_PRICE_ADJUSTMENTS table with

408: --check if cost record have been inserted into OM
409: *************************************************/
410: DBMS_DEBUG('Checking if freight cost has been passed to OM');
411:
412: -- Cost records are stored in OE_PRICE_ADJUSTMENTS table with
413: -- list_line_type_code = 'COST'
414: Begin
415: SELECT SUM(ADJUSTED_AMOUNT)
416: INTO l_cost_amount

Line 417: FROM OE_PRICE_ADJUSTMENTS_V

413: -- list_line_type_code = 'COST'
414: Begin
415: SELECT SUM(ADJUSTED_AMOUNT)
416: INTO l_cost_amount
417: FROM OE_PRICE_ADJUSTMENTS_V
418: WHERE LINE_ID = l_line_rec.line_id
419: AND LIST_LINE_TYPE_CODE = 'COST'
420: AND CHARGE_TYPE_CODE = l_cost_type_code;
421: If l_cost_amount is not Null Then