You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!