How to filter out duplicate rows with same values in BI report.

Summary:
I need to create one BI report where I need columns like Item_Number, Item_Description, Prc_BU_Name, Order_Num (PO_num), PO_Quantity, Invoice_quantity, Invoice_num, Receipt_num, Hold_reason etc…
I have created one query but it is repeating same rows again and again. Sometime it is missing some values also.

Content (please ensure you mask any confidential information):

Also it is missing some order numbers.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):
SELECT
esivl.ITEM_NUMBER AS ItemNumber,
esitl.DESCRIPTION AS ItemDescription,