APPS.OE_MARGIN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 423: --mtl_system_items_kfv

419:
420: --A drop shipment line, getting cost from
421: --Try to get cost from drop ship views (PO).
422: --If record no available that means PO has not been created, then we need to get cost from
423: --mtl_system_items_kfv
424: IF l_line_rec.source_type_code = 'EXTERNAL' THEN
425: debug(' This is a drop ship line');
426:
427: /* begin bug 3181730: the following SQL consumes over 1MB memory

Line 457: FROM mtl_system_items_kfv

453: select inventory_organization_id into l_inventory_org_id from financials_system_parameters; --bug 2733946
454:
455: SELECT list_price_per_unit
456: INTO l_unit_cost
457: FROM mtl_system_items_kfv
458: WHERE inventory_item_id = nvl(l_line_rec.inventory_item_id,p_inventory_item_id)
459: AND organization_id = l_inventory_org_id; --nvl(l_line_rec.ship_from_org_id,p_ship_from_org_id);
460:
461: EXCEPTION