DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 169: FROM mtl_system_items_kfv c,

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

Line 485: FROM mtl_system_items_kfv msik

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