4367: BEGIN
4368: IF (x_sub_item_id_record.substitute_item_num IS NOT NULL) THEN
4369: SELECT MAX(inventory_item_id)
4370: INTO x_sub_item_id_record.substitute_item_id
4371: FROM mtl_system_items_kfv
4372: WHERE concatenated_segments = x_sub_item_id_record.substitute_item_num;
4373: ELSE
4374: SELECT MAX(inventory_item_id)
4375: INTO x_sub_item_id_record.substitute_item_id
4372: WHERE concatenated_segments = x_sub_item_id_record.substitute_item_num;
4373: ELSE
4374: SELECT MAX(inventory_item_id)
4375: INTO x_sub_item_id_record.substitute_item_id
4376: FROM mtl_system_items_kfv
4377: WHERE concatenated_segments = x_sub_item_id_record.vendor_item_num;
4378: END IF;
4379:
4380: IF (x_sub_item_id_record.substitute_item_id IS NULL) THEN