How to get the Base Price of an Item from the Price List corresponding to the Customer Ship to Site

Summary:

Hello All,

Could you please help me to get the base price of an item from the Price List corresponding to the Customer Ship to Site. And I have prepare an query, but it is giving me the multiple base price of an single Item.

Navigation : Order Management→ Pricing Administration → Manage Pricing Strategy→ Search the Name of Pricing Strategy→ Go to Segment Price List → click on name → Price List Line → Select Line Type as Buy → Select the Item Name → Go to the Base Price of an Item


SELECT HCA.ACCOUNT_NAME Customer_Name,
HCA.ACCOUNT_NUMBER Customer_Account,
HCSU.LOCATION Ship_To_Site,