Seeking guidance on SQL query

Summary:

Hello, can someone please advise how to transform this query in order to return only records where a combination of (esib.item_number, hp.party_name, and pltl.line_type) exist on other records as well, and exclude all records that have a unique (esib.item_number, hp.party_name, and pltl.line_type) combination?

We are looking to identify duplicates based on those three fields, while also bringing in other fields to describe the records

Thank you

Content (please ensure you mask any confidential information):

SELECT
esib.item_number,
hp.party_name AS vendor_name,
pla.vendor_product_num,