4123: IF l_head_item_id_table(i) IS NULL
4124: THEN
4125: SELECT inventory_item_id
4126: INTO l_head_item_id_table(i)
4127: FROM mtl_system_items_kfv
4128: WHERE concatenated_segments = l_head_name_table(i)
4129: AND organization_id = l_org_id_table(i);
4130: END IF;
4131:
4194: IF l_comp_item_id_table(i) IS NULL
4195: THEN
4196: SELECT inventory_item_id
4197: INTO l_comp_item_id_table(i)
4198: FROM mtl_system_items_kfv
4199: WHERE concatenated_segments = l_comp_name_table(i)
4200: AND organization_id = l_org_id_table(i);
4201: END IF;
4202:
4212: IF l_head_item_id_table(i) IS NULL
4213: THEN
4214: SELECT inventory_item_id
4215: INTO l_head_item_id_table(i)
4216: FROM mtl_system_items_kfv
4217: WHERE concatenated_segments = l_head_name_table(i)
4218: AND organization_id = l_org_id_table(i);
4219: END IF;
4220: