662:
663: BEGIN
664: SELECT concatenated_segments
665: INTO l_concatenated_segments
666: FROM MTL_SYSTEM_ITEMS_KFV
667: WHERE inventory_item_id = config_rec.inventory_item_id
668: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
863:
864: BEGIN
865: SELECT concatenated_segments
866: INTO l_concatenated_segments
867: FROM MTL_SYSTEM_ITEMS_KFV
868: WHERE inventory_item_id = config_rec.inventory_item_id
869: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
870: EXCEPTION
871: WHEN NO_DATA_FOUND THEN