DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on OE_PRICE_LIST_LINES

Line 308: from oe_price_list_lines sopl,

304: select round(list_price *
305: (1 - (NVL(FND_PROFILE.Value_Specific('MRP_BIS_AV_DISCOUNT'),0)/100)),
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

Line 342: from oe_price_list_lines sopl,

338: BEGIN
339:
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