How to retrieve the subscription owner name entered from Team menu in Subscription Management?

Hi guys,

We have a requirement to develop a report in which we need to retrieve the subscription owner name. The name of the team member from Subscription Management page where owner_YN = 'Y' should be displayed. I tried below query but the party ID is not exsiting on hz_parties table.

select hp.party_name

from oss_subscriptions os, oss_contacts oc, oss_parties op, hz_parties hp

where oc.subscription_id = os.subscription_id

AND oc.subscription_party_id = op.subscription_party_id

AND op.party_id = hp.party_id

AND oc.internal_yn = 'Y'

AND oc.owner_yn = 'Y';