APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 167: FROM mtl_system_items_kfv c,

163: c.inventory_item_id item_id,
164: c.planner_code planner,
165: build_in_wip_flag build_in_wip,
166: pick_components_flag pick_components
167: FROM mtl_system_items_kfv c,
168: mtl_parameters p
169: WHERE c.concatenated_segments = p_item_Segments
170: AND c.organization_id = p.organization_id
171: AND p.organization_id = p_organization_id;

Line 483: FROM mtl_system_items_kfv msik

479:
480: Begin
481: SELECT msik.inventory_item_id
482: INTO l_item_id
483: FROM mtl_system_items_kfv msik
484: WHERE msik.concatenated_segments = inv_rec.item_segments
485: AND msik.organization_id = p_organization_id;
486: Exception
487: When no_data_found then