Salesperson LOV query for Contract > Billing Tab

Summary:

Content (required):

(Project Contracts) Contract Management > Contracts > Search and open Contract > Billing Tab Salesperson field

There is showing a salesrep "No Sales Credit" ( we understand this is a seeded salesperson). But, We are not finding any details for this salesperson in below tables. OKC_K_SALES_CREDITS,  JTF_RS_SALESREPS,  hz_parties.

We are trying to create a BI report to show the Salesperson name with the contract details using these tables.

SELECT HP.PARTY_NAME AS SALES_PERSON

FROM OKC_K_HEADERS_ALL_B OKH,

    OKC_K_SALES_CREDITS OKS,

    JTF_RS_SALESREPS JRS,

    hz_parties HP,

    hr_all_organization_units HOU