983: -- Update Line Item Status
984: UPDATE eng_change_lines SET STATUS_CODE = 1 WHERE change_line_id = l_change_line_id;
985: ELSE
986: SELECT CONCATENATED_SEGMENTS INTO l_sfa_item
987: FROM MTL_SYSTEM_ITEMS_KFV
988: WHERE inventory_item_id = l_pk1_value
989: AND organization_id = l_pk2_value
990: AND LAST_SUBMITTED_NIR_ID <> p_change_id;
991: