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

In table does the Customer name related to a Project in stored?

in Project Management 2 comments

Hi Team,

I am looking for the Customer name related to a Project. I am using the following query to the customer name but unable get the customer name.

Kindly let me know any other table needs to checked.

query
Select PPA.Segment1,

HP.PARTY_NAME

FROM

PJF_PROJECTS_ALL_B PPA,

PJF_PROJECT_PARTIES PPP,

HZ_PARTIES HP

WHERE PPA.PROJECT_ID = PPP.PROJECT_ID

AND PPP.RESOURCE_SOURCE_ID = HP.PARTY_ID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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