APPS.AHL_MC_RULE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1493: FROM MTL_SYSTEM_ITEMS_KFV KFV

1489: AND MP.eam_enabled_flag = 'Y');
1490:
1491: CURSOR chk_item_name_csr (p_item_name VARCHAR2) IS
1492: SELECT inventory_item_id
1493: FROM MTL_SYSTEM_ITEMS_KFV KFV
1494: WHERE concatenated_segments = p_item_name
1495: AND EXISTS
1496: (SELECT 'X'
1497: FROM MTL_PARAMETERS MP