DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on OE_PRICE_LISTS

Line 310: oe_price_lists spl

306: NVL(-spl.rounding_factor,2))
307: into arg_price
308: from oe_price_list_lines sopl,
309: mtl_system_items msi,
310: oe_price_lists spl
311: where spl.price_list_id = FND_PROFILE.Value_Specific('MRP_BIS_PRICE_LIST')
312: and sopl.price_list_id = spl.price_list_id
313: and sopl.inventory_item_id = arg_item_id
314: and msi.inventory_item_id = arg_item_id

Line 344: oe_price_lists spl

340: select round(list_price,NVL(spl.rounding_factor,2))
341: into arg_price
342: from oe_price_list_lines sopl,
343: mtl_system_items msi,
344: oe_price_lists spl
345: where spl.price_list_id = arg_price_list_id
346: and sopl.price_list_id = spl.price_list_id
347: and sopl.inventory_item_id = arg_item_id
348: and msi.inventory_item_id = arg_item_id