DBA Data[Home] [Help]

APPS.OE_FREIGHT_RATING_PVT dependencies on OE_ORDER_LINES

Line 234: FROM oe_order_lines ool

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