Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Salesperson LOV query for Contract > Billing Tab — Cloud Customer Connect
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

Received Response
2
Views
2
Comments

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!