APPS.OE_MARGIN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 496: --mtl_system_items_kfv

492:
493: --A drop shipment line, getting cost from
494: --Try to get cost from drop ship views (PO).
495: --If record no available that means PO has not been created, then we need to get cost from
496: --mtl_system_items_kfv
497: IF l_line_rec.source_type_code = 'EXTERNAL' THEN
498: debug(' This is a drop ship line');
499:
500: /* begin bug 3181730: the following SQL consumes over 1MB memory

Line 530: FROM mtl_system_items_kfv

526: select inventory_organization_id into l_inventory_org_id from financials_system_parameters; --bug 2733946
527:
528: SELECT list_price_per_unit
529: INTO l_unit_cost
530: FROM mtl_system_items_kfv
531: WHERE inventory_item_id = nvl(l_line_rec.inventory_item_id,p_inventory_item_id)
532: AND organization_id = l_inventory_org_id; --nvl(l_line_rec.ship_from_org_id,p_ship_from_org_id);
533:
534: EXCEPTION