DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on FND_PROFILE

Line 305: (1 - (NVL(FND_PROFILE.Value_Specific('MRP_BIS_AV_DISCOUNT'),0)/100)),

301: IS
302: arg_price number;
303: BEGIN
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,

Line 311: where spl.price_list_id = FND_PROFILE.Value_Specific('MRP_BIS_PRICE_LIST')

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
315: and msi.organization_id = arg_org_id