1347: RETURN l_id;
1348: END IF;
1349: */
1350: select inventory_item_id into l_id
1351: from mtl_system_items_kfv
1352: where concatenated_segments = p_revised_item_num
1353: and organization_id = p_organization_id;
1354:
1355: return l_id;
1406: IF (ret_code <> 0) THEN
1407: RETURN NULL;
1408: END IF;*/
1409: select inventory_item_id into l_id
1410: from mtl_system_items_kfv
1411: where concatenated_segments = p_use_up_item_num
1412: and organization_id = p_organization_id;
1413:
1414: RETURN l_id;
1439: IF (ret_code <> 0) THEN
1440: NULL;
1441: END IF;*/
1442: select inventory_item_id into l_id
1443: from mtl_system_items_kfv
1444: where concatenated_segments = p_assembly_item_num
1445: and organization_id = p_organization_id;
1446:
1447: RETURN l_id;