APPS.INV_VALIDATE_TROLIN dependencies on MTL_SYSTEM_ITEMS

Line 188: FROM mtl_system_items_kfv

184: ( p_item_id IN NUMBER
185: , p_organization_id IN NUMBER
186: ) IS
187: SELECT concatenated_segments
188: FROM mtl_system_items_kfv
189: WHERE inventory_item_id = p_item_id
190: AND organization_id = p_organization_id;
191:
192: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 381: from mtl_system_items_b

377: END IF;
378: elsif (l_sub_loc_control = 5) THEN
379: select nvl(location_control_code,1)
380: into l_item_loc_control
381: from mtl_system_items_b
382: where organization_id = p_trolin_rec.organization_id
383: and inventory_item_id = p_trolin_rec.inventory_item_id;
384:
385: if (l_item_loc_control = 1) THEN