920: In IB, there is no ing return transaction*/
921: IF (l_trxn_type IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_byprod_completion)) THEN
922: SELECT concatenated_segments
923: INTO l_item_no
924: FROM mtl_system_items_kfv
925: WHERE inventory_item_id = p_material_detail_rec.inventory_item_id
926: AND organization_id = p_material_detail_rec.organization_id;
927: END IF;
928: