DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1357: from mtl_system_items_kfv

1353: RETURN l_id;
1354: END IF;
1355: */
1356: select inventory_item_id into l_id
1357: from mtl_system_items_kfv
1358: where concatenated_segments = p_revised_item_num
1359: and organization_id = p_organization_id;
1360:
1361: return l_id;

Line 1416: from mtl_system_items_kfv

1412: IF (ret_code <> 0) THEN
1413: RETURN NULL;
1414: END IF;*/
1415: select inventory_item_id into l_id
1416: from mtl_system_items_kfv
1417: where concatenated_segments = p_use_up_item_num
1418: and organization_id = p_organization_id;
1419:
1420: RETURN l_id;

Line 1449: from mtl_system_items_kfv

1445: IF (ret_code <> 0) THEN
1446: NULL;
1447: END IF;*/
1448: select inventory_item_id into l_id
1449: from mtl_system_items_kfv
1450: where concatenated_segments = p_assembly_item_num
1451: and organization_id = p_organization_id;
1452:
1453: RETURN l_id;