DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_PVT dependencies on OE_ORDER_LINES

Line 235: FROM oe_order_lines ool

231: CURSOR C_CONFIG_ITEM_PARENTS(p_ato_line_id IN NUMBER) IS
232: SELECT opa.price_adjustment_id,ool.line_id,
233: opa.adjusted_amount, opa.list_line_type_code,
234: opa.charge_type_code
235: FROM oe_order_lines ool
236: ,oe_price_adjustments opa
237: WHERE opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
238: AND ool.line_id = opa.line_id
239: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG