Answer
Where IFS already exposes that value through a dedicated API function — for example Purchase_Order_Line_API.Get_Part_Description(order_no, release_no, sequence_no, order_type) for the part description shown on a purchase order line — calling that function directly in your SQL expression avoids the join and stays aligned with however IFS derives the value internally.